The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=820 ====================================================================== Reported By: ttessier Assigned To: ====================================================================== Project: DBMail Issue ID: 820 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: tweak Priority: normal Status: new target: ====================================================================== Date Submitted: 14-Dec-09 18:17 CET Last Modified: 14-Dec-09 18:17 CET ====================================================================== Summary: dbmail-util Repairing DBMAIL for cached header values... Description: Ok. Found [5] un-cached physmessages. Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, datefield are not unique, INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (5,'1970-01-01 00:00:00') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (5,'1970-01-01 00:00:00')] Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, subjectfield are not unique, INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (5,'(No Subject)') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (5,'(No Subject)')] ..Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, datefield are not unique, INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (4,'1970-01-01 00:00:00') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (4,'1970-01-01 00:00:00')] Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, subjectfield are not unique, INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (4,'(No Subject)') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (4,'(No Subject)')] ..Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, datefield are not unique, INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (3,'1970-01-01 00:00:00') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (3,'1970-01-01 00:00:00')] Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, subjectfield are not unique, INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (3,'(No Subject)') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (3,'(No Subject)')] ..Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, datefield are not unique, INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (2,'1970-01-01 00:00:00') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (2,'1970-01-01 00:00:00')] Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, subjectfield are not unique, INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (2,'(No Subject)') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (2,'(No Subject)')] ..Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, datefield are not unique, INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1,'1970-01-01 00:00:00') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1,'1970-01-01 00:00:00')] Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[sql] dbsqlite.c,db_query(+374): sqlite3_get_table failed: columns physmessage_id, subjectfield are not unique, INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (1,'(No Subject)') Dec 14 12:03:17 microagets.swhistlesoft.com [24894]: Error:[message] dbmail-message.c,insert_field_cache(+1132): insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (1,'(No Subject)')] ======================================================================
Issue History Date Modified Username Field Change ====================================================================== 14-Dec-09 18:17 ttessier New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
