Mark... Unfortunately for me, that is not the problem I'm having. The database only has about 4 accounts in it, with a total of about 20 messages. So I'm not having any issues with keys or id's yet.
-- Jason On 3/6/03 1:16 PM, "Mark Mackay - Orcon Internet" <[EMAIL PROTECTED]> wrote: > Check the unique_id column of the database. We had the same problem and it > was because the UIDLs were stuffed up.From memory i think we fixed it by > doing the following query: > > update messages set unique_id=concat(message_idnr,'A',unix_timestamp()); > > i don't think it matters what the values are tho. It will mean anyone who > has keep mail on server ticked will have to redownload all their messages; > but i think it will fix the problem. > > It does beg the question - why isn't the message_idnr simply used as the > UIDL reference anyway? > > Hope this helps though. > > /Mark > > > ----- Original Message ----- > From: "Jason Burfield" <> > To: <dbmail@dbmail.org> > Sent: Friday, March 07, 2003 7:05 AM > Subject: [Dbmail] Multiple copies of every email > > >> I found a few things that were close to this in the archives...but no real >> answers. >> >> I've got DBMail set up and running with Postfix. I am having a few > glitches, >> but the most annoying one at the moment is that mail is not deleted from > the >> tables in DBMail. >> >> Each time I check mail I get the same exact mail I already retrieved. >> >> I have the dbmail-maintenanace set up to run each night, however that does >> not seem to delete any mail. >> >> I have also manually run dbmail-maintenance a few times with no luck there >> either. >> >> Can anyone point me in a good direction here? >> >> Thanks much. >> >> -- Jason >> >> _______________________________________________ >> Dbmail mailing list >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > --------------------------------------------------- | Jason Burfield | | | [EMAIL PROTECTED] | http://www.burfield.com | ---------------------------------------------------
