The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=440 ====================================================================== Reported By: cmayo Assigned To: paul ====================================================================== Project: DBMail Issue ID: 440 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.2 branch ====================================================================== Date Submitted: 06-Nov-06 19:34 CET Last Modified: 06-Nov-06 23:09 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. ====================================================================== ---------------------------------------------------------------------- paul - 06-Nov-06 23:09 ---------------------------------------------------------------------- I've backed out the ill conceived mysqlism that caused this. Issue History Date Modified Username Field Change ====================================================================== 06-Nov-06 19:34 cmayo New Issue 06-Nov-06 23:09 paul Note Added: 0001543 06-Nov-06 23:09 paul Assigned To => paul 06-Nov-06 23:09 paul Status new => resolved 06-Nov-06 23:09 paul Resolution open => fixed 06-Nov-06 23:09 paul Fixed in Version => 2.2 branch ======================================================================
