A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=512 ====================================================================== Reported By: bjohnson Assigned To: ====================================================================== Project: DBMail Issue ID: 512 Category: Database layer Reproducibility: have not tried Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 25-Feb-07 10:57 CET Last Modified: 25-Feb-07 19:30 CET ====================================================================== Summary: error in SQL syntax Description: Have some of these in my log file:
Feb 22 19:55:16 mailhost dbmail/imap4d[11895]: Error [You have an error in your SQ L syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY message_idnr' at line 1] [SELECT message_idn r FROM dbmail_messages WHERE mailbox_idnr = 1 AND status IN (0,1) AND ORDER BY message_idnr] Feb 22 19:55:16 mailhost dbmail/imap4d[11895]: Error could not execute query ====================================================================== ---------------------------------------------------------------------- paul - 25-Feb-07 11:17 ---------------------------------------------------------------------- I can't fix this without seeing the SEARCH or SORT command that precedes this error. ---------------------------------------------------------------------- bjohnson - 25-Feb-07 11:26 ---------------------------------------------------------------------- Unfortunately, I was running at the lowest log level because I haven't had any recent issues. There were three of these logged over the last week. I have no idea how to reproduce it. I'll turn of the log level and see if I can get anymore. ---------------------------------------------------------------------- bjohnson - 25-Feb-07 11:27 ---------------------------------------------------------------------- This server has very little memory and cpu power. What is the least amount of logging that I can do and still capture the information that you need? I have it set to 5 right now, but I'm sure the people who use it are going to complain about how slow it is now :) ---------------------------------------------------------------------- paul - 25-Feb-07 19:30 ---------------------------------------------------------------------- imap commands are logged at level=4 Issue History Date Modified Username Field Change ====================================================================== 25-Feb-07 10:57 bjohnson New Issue 25-Feb-07 11:17 paul Note Added: 0001833 25-Feb-07 11:26 bjohnson Note Added: 0001834 25-Feb-07 11:27 bjohnson Note Added: 0001835 25-Feb-07 19:30 paul Note Added: 0001836 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
