The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=751 ====================================================================== Reported By: maximP Assigned To: ====================================================================== Project: DBMail Issue ID: 751 Category: Database layer Reproducibility: always Severity: crash Priority: normal Status: new target: ====================================================================== Date Submitted: 12-Jan-09 09:30 CET Last Modified: 12-Jan-09 09:30 CET ====================================================================== Summary: SQLException during POP3 session Description: After deleting messages during the POP3 session dbmail tries to calculate mailbox size by executing "select sum(...)". It gets one record with NULL value and tries to convert it to int in db_result_get_u64() function. The result is the following log message:
Error:[db] dm_quota_rebuild_user(+908): SQLException: (Tested with PostgreSQL 8.3) I suggest to replace sum(...) with coalesce(sum(...), 0) The patch is attached. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 12-Jan-09 09:30 maximP New Issue 12-Jan-09 09:30 maximP File Added: dm_db.c.diff ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev