Truncate the envelope table. It can be re-filled using dbmail-util.
On 20-05-14 23:53, Jorge Bastos wrote:
Hi,
I’m doing some offline tests to upgrade my DBMail to latest 3.1.13.
My 1^st sql upgrade script to run is: 2_3_6-3_0_0.mysql
But when I run it I get:
mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON
dbmail_envelope(physmessage_id);
ERROR 1062 (23000): Duplicate entry '2424862' for key 3
mysql>
So I went to see why and saw that have MANY duplicated records, check
the below image.
Also, the table structure is different than the create_tables.mysql file
that has the column order:
id/physmessage/envelope
and I have:
physmessage/id/envelope
Is this problematic, or in the code the insertions on the table are
hardcoded with an “insert into dbmail_envelope (id,physmessage,envelope)
values (?,?,?)” and the column order doesn’t matter at all?
What can I do to proceed?
Thanks in advanced,
Jorge,
dup envelope.jpg
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/[email protected]/+31.85.877.99.97
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
