[EMAIL PROTECTED] wrote: > Tue, Mar 13, 2007 at 11:40:39AM +0100, Paul J Stevens написал: >> [EMAIL PROTECTED] wrote: >>> Sat, Mar 10, 2007 at 12:31:22PM +0600, [EMAIL PROTECTED] написал: >>>> hello >>>> >>>> ~$ mysql -u root dbmail < migrate_from_2.0_to_2.2.mysql >>>> ERROR 1062 (23000) at line 22: Duplicate entry '3-Sent' for key 2 >>>> >>>> any ideas ? >>> please help. i try it again with other db mysql, but still with this error. >>> what can i do ? >>> >> Try running >> >> mysql -u root -v -v -v -T dbmail < ... >> >> so we can see what's going on. > > > mysql -u root -v -v -v -T dbmail < migrate_from_2.0_to_2.2.mysql > -------------- > ALTER TABLE dbmail_physmessage ENGINE=InnoDB > -------------- > > Query OK, 21428 rows affected (0,59 sec) > Records: 21428 Duplicates: 0 Warnings: 0 > > -------------- > ALTER TABLE dbmail_messageblks MODIFY messageblk LONGBLOB NOT NULL > -------------- > > Query OK, 45027 rows affected (7 min 50,49 sec) > Records: 45027 Duplicates: 0 Warnings: 0 > > -------------- > ALTER TABLE dbmail_mailboxes MODIFY name VARCHAR(100) NOT NULL default > '' > -------------- > > ERROR 1062 (23000) at line 22: Duplicate entry '3-Sent' for key 2
So user_idnr=3 has more than one mailbox called 'Sent', perhaps? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
