It looks like you have either a db schema issue, or database server problem.
Please do a show create table dbmail_messages;
You should have a recent_flag field.
If you are missing that field (unlikely) do a alter table
dbmail_messages add column `recent_flag` tinyint(1) NOT NULL DEFAULT '0';
You should also check the output for other fields that are missing
against the create_tables.mysql file in the dist.
Also, what version of MySQL are you running?
-Jon
Jon Duggan wrote:
I have had a few occasions where users say they have lost email, are these
errors possibly related?
That would be the first time, afaik. I can't tell if there's a relation.
This possibly isn’t dbmail related (could be our spam filtering)
Next time you see this error, try find out what query triggers the error.
Full log level 5 for a session with such an error can be found here;
http://pure.noffle.net/~jduggan/debug5.imapd.out
If you need further information do let me know.
TIA
Jon
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
