The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=440 ====================================================================== Reported By: cmayo Assigned To: ====================================================================== Project: DBMail Issue ID: 440 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 06-Nov-06 19:34 CET Last Modified: 06-Nov-06 19:34 CET ====================================================================== Summary: dbmail-util -b fails with SQL error Description: On dbmail_2_2_branch r2356 running dbmail-util -b gives:
Choosing dry-run mode. Use -y to disable it.Opening connection to database... Opening connection to authentication... Ok. Connected. Checking DBMAIL for incorrect is_header flags... Error query failed [SELECT MIN(messageblk_idnr),is_header FROM dbmail_messageblks GROUP BY physmessage_id HAVING is_header=0] : [ERROR: column "dbmail_messageblks.is_header" must appear in the GROUP BY clause or be used in an aggregate function ] Error could not access messageblks table Failed. An error occured. Please check log. Maintenance done. No errors found. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 06-Nov-06 19:34 cmayo New Issue ======================================================================
