Hello, Sounds like it's trying to cache the message, which would fix your issue, but something's not right. What do you get for the following queries?
describe dbmail_datefield; select * from dbmail_datefield where physmessage_id = 1543; select last_value from dbmail_datefield_idnr_seq; select max(id) from dbmail_datefield; Jesse On Sat, 2006-07-29 at 13:47 -0400, DK wrote: > So I checked the mail.log on trace level 4 and this is what I am > getting after running 'dbmail-util -by' seams there is something wrong > with the date field it says 1970-01-01 which is beginning of Linux > time. Plus it says something about no Subject field value. What should > I do? > > > Jul 29 13:39:05 safe dbmail/maintenance[23411]: Error > dbmysql.c,db_query: [Duplicate entry '1543-1970-01-01 00:00:00' for > key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) > VALUES (1543,'1970-01-01 00:00:00')] > Jul 29 13:39:05 safe dbmail/maintenance[23411]: Error > dbmail-message.c,insert_field_cache: insert datefield failed [INSERT > INTO dbmail_datefield (physmessage_id, datefield) VALUES > (1543,'1970-01-01 00:00:00')] > Jul 29 13:39:05 safe dbmail/maintenance[23411]: Message > dbmail-message.c,dbmail_message_cache_subjectfield: no subject field > value [1543] > > > > On 7/28/06, DK <[EMAIL PROTECTED]> wrote: > > Well it isn't fixing it > > > > On 7/28/06, Jesse Norell <[EMAIL PROTECTED]> wrote: > > > > > > > When ever I do a "dbmail-util -ya" I get following message. > > > > > > > > Repairing DBMAIL for cached header values... > > > > Ok. Found [1] un-cached physmessages. > > > > > > From memory (not using 2.1 yet), isn't it "dbmail-util -by" that > > > creates the message caches? Maybe try running that. Possibly in your > > > previous package upgrade/etc. issues you had stored an email using > > > dbmail-smtp (or dbmail-lmtp) from version 2.0? That would put it in the > > > right format other than the new caching stuff added in 2.1. > > > > > > > > > -- > > > Jesse Norell - [EMAIL PROTECTED] > > > Kentec Communications, Inc. > > > > > > _______________________________________________ > > > Dbmail mailing list > > > [email protected] > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > -- > > > > Demi > > > > -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
