While having the message_idnr serve as the unique_id makes sense initially, I believe that it would be problematic for backups and migrations. Explaining to the users that they need to download all messages again because of a change on the server side isn't pretty.
Granted, that's what you're suggesting to do here, but perhaps there's a more elegant solution that avoids this step... Aaron On Fri, 7 Mar 2003, Mark Mackay - Orcon Internet 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 > > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
