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
>
