Thanks Paul! > -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Paul J Stevens > Sent: sábado, 24 de Maio de 2014 18:56 > To: DBMail mailinglist > Subject: Re: [Dbmail] Help upgrading from arround 2.3.6 to 3.1.13 > > > On 21-05-14 21:33, Jorge Bastos wrote: > > 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? > > Yes. > > > > > > > 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? > > I don't see a problem there. The envelope table will be empty and only > partially filled. This will confuse connecting IMAP clients. So you > will probably want to disable IMAP while this is running. POP3 and > delivery are not affected. > > > > >> > >> > >> > >> 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 > >>> DBmail@dbmail.org > >>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > >>> > >> > >> -- > >> ________________________________________________________________ > >> Paul J Stevens pjstevns @ gmail, twitter, github, linkedin > >> www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 > >> _______________________________________________ > >> DBmail mailing list > >> DBmail@dbmail.org > >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > > _______________________________________________ > > DBmail mailing list > > DBmail@dbmail.org > > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > > -- > ________________________________________________________________ > Paul J Stevens pjstevns @ gmail, twitter, github, linkedin > www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail