I think Paul explained that sometimes the size of the integers were different because they were not explicitly specified in the creation of tables in dbmail 2.2, so perhaps different platforms or versions of Linux used different sizes of integers. Thanks, Dirce
> the workaround is in the link you posted > > ALTER TABLE dbmail_sievescripts ADD UNIQUE INDEX > dbmail_sievescripts_1 (owner_idnr, name); > > no idea why your keys are different, my definitions are > from fedora summer 2009, however i would generally reccomend > exclude all unique-key-changes out of the migration-sql-file > and add them BEFORE migration because i had also existing records > which did not allow add unique keys in one of the tables becuase > they were redundant/oprhaned over the years and i had to delet > them before set unique keys > > the unique keys are to prevevent insert such records in the > future but you can not add them if duplicate entries still > exists > _______________________ > > your `dbmail_sievescripts` > > CREATE TABLE `dbmail_sievescripts` ( > `owner_idnr` bigint(21) NOT NULL default '0', > `name` varchar(100) NOT NULL, > `script` text, > `active` tinyint(1) NOT NULL default '0', > KEY `name` (`name`), > KEY `owner_idnr` (`owner_idnr`), > KEY `owner_idnr_2` (`owner_idnr`,`name`), > CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) > REFERENCES > `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > _______________________ > > my dbmail-2.2 `dbmail_sievescripts` > > dbmail_sievescripts | CREATE TABLE `dbmail_sievescripts` ( > `owner_idnr` bigint(10) unsigned NOT NULL DEFAULT '0', > `name` varchar(100) NOT NULL, > `script` text, > `active` tinyint(3) unsigned NOT NULL DEFAULT '0', > UNIQUE KEY `dbmail_sievescripts_1` (`owner_idnr`,`name`), > KEY `name` (`name`), > KEY `owner_idnr` (`owner_idnr`), > CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) > REFERENCES > `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 > > Am 08.02.2012 21:07, schrieb drsyst...@globalcerts.net: >> Here is one of the places where this problem is discussed, but I don't >> find or understand the workarounds for this. >> Thanks, >> Dirce >> >> http://www.gossamer-threads.com/lists/dbmail/dev/30854?do=post_view_threaded> >> >> >> >>> >>> Am 08.02.2012 19:46, schrieb drsyst...@globalcerts.net: >>>> Hi, >>>> >>>> I am running the script >>>> >>>> /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql >>>> >>>> on an old host (test host) that I want to migrate. >>>> >>>> I get the error: >>>> >>>> ERROR 1025 (HY000) at line 68: Error on rename of >>>> './dbmail/#sql-9dd_357e' >>>> to './dbmail/dbmail_users' (errno: 150) >>>> >>>> I have been fixing it one db at a time by doing: >>>> mysql>show create table dbmail_... >>>> and then >>>> mysql>alter table dbmail_sievescripts drop foreign key >>>> dbmail_sievescripts_ibfk_1; (for example) >>> >>> * what mysql version >>> * what OS >>> * what yasys the mysqld errorlog >>> * how much free space on disk >>> >>> the error message alone is pointless because >>> this is only a standard message of the mysql-client >>> >>> _______________________________________________ >>> 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 > > -- > > Mit besten Grüßen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofmühlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 > icq: 154546673, http://www.thelounge.net/ > > http://www.thelounge.net/signature.asc.what.htm > > _______________________________________________ > 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
