Hi Paul, Thanks,
So steps should be: Truncate table Apply unique index Run Dbmail-util -by .... Later on/after it apply the rest of the DB changes and upgrade. Am I right? Could I truncate the table, apply the unique index and run dbmail-util -by with the system running? (receiving emails) or no email can be received while this ends? > > > > 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 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
