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 11:17 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. Issue History Date Modified Username Field Change ====================================================================== 25-Feb-07 10:57 bjohnson New Issue 25-Feb-07 11:17 paul Note Added: 0001833 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
