The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=774 ====================================================================== Reported By: tvrosmalen Assigned To: ====================================================================== Project: DBMail Issue ID: 774 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.3.6 ====================================================================== Date Submitted: 01-Mar-09 14:57 CET Last Modified: 01-Mar-09 16:19 CET ====================================================================== Summary: SQLException using dbmail-imapd Description: I found the following logentries while testing dbmail. Mar 1 14:37:33 195066 dbmail/imap4d[8062]: [0x80a0ed8] Error:[db] db_query(+347): SQLException: Mar 1 14:37:33 195066 dbmail/imap4d[8062]: [0x80a0ed8] Error:[db] db_query(+348): failed query [SELECT message_idnr, keyword FROM dbmail_keywords k JOIN dbma il_messages m USING (message_idnr) JOIN dbmai
After crancking up the debuglevel I found a slight fault in the query that's executed. It's missing a table-identifier in order to execute the query succesfully. I've included a small path in the additional information section. ====================================================================== ---------------------------------------------------------------------- (0002797) paul (administrator) - 01-Mar-09 16:19 http://www.dbmail.org/mantis/view.php?id=774#c2797 ---------------------------------------------------------------------- Patch accepted. Thanks Ton. Issue History Date Modified Username Field Change ====================================================================== 01-Mar-09 14:57 tvrosmalen New Issue 01-Mar-09 16:19 paul Note Added: 0002797 01-Mar-09 16:19 paul Status new => resolved 01-Mar-09 16:19 paul Resolution open => fixed 01-Mar-09 16:19 paul Fixed in Version => 2.3.6 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev