Hi I get such errors each night. Database is mysql, dbmail version is 2.2.10-1+b1 from current stable Debian Lenny 5.0.4:
Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry '7503-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (7503,'1970-01-01 00:00:00')] Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[message] dbmail-message.c,insert_field_cache(+1105): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (7503,'1970-01-01 00:00:00')] Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry '7446-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (7446,'1970-01-01 00:00:00')] Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[message] dbmail-message.c,insert_field_cache(+1105): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (7446,'1970-01-01 00:00:00')] Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry '3335-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (3335,'1970-01-01 00:00:00')] Jun 2 03:00:11 jupiter dbmail/maintenance[1076]: Error:[message] dbmail-message.c,insert_field_cache(+1105): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (3335,'1970-01-01 00:00:00')] First I installed the system, everything was OK. Then I started to move emails from my another dbmail account. For this I used Thunderbird and IMAP. Next night after this i got errors above in the log file. Is this bad? Why maintenance process trys to insert values? What should I do? -- Best regards, Sergey Spiridonov _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
