Got it. Regression introduced by fix for bug #557. I'm testing a fix.
Guido Piazzi wrote: > Hi all, > > I just installed the 2.2.5-0rc1 packages from debian.nfgd.net. The > upgrade process ran smoothly, but now I keep getting these message in > mail.log: > > Apr 22 18:17:18 lagrange dbmail/imap4d[11777]: Error:[sql] > dbpgsql.c,db_query(+289): query failed [SELECT DISTINCT(message_idnr) > FROM dbmail_messages m LEFT JOIN dbmail_physmessage p ON > m.physmessage_id=p.id LEFT JOIN dbmail_datefield ON > m.physmessage_id=dbmail_datefield.physmessage_id WHERE m.mailbox_idnr = > 28 AND m.status IN (0,1) ORDER BY datefield,message_idnr] : [ERROR: for > SELECT DISTINCT, ORDER BY expressions must appear in select list ] > > Hope it helps... > > Guido > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
