hm - interesting this did the upgrade on our main production server without any problem, but not easy to say since it is a one-shot thing :-(
Am 17.04.2012 10:50, schrieb ITronic Harald Leithner: > There is a problem in the sql Script from Harald Reindl. > > The script creates the envelope table to early. > > You could try to use the 2_2-3_0.mysql script in sql/mysql directory found in > the dbmail.tar.gz > > after "DROP PROCEDURE IF EXISTS dodropkeys;" > > regards, > > Harald > > Am 17.04.2012, 10:30 Uhr, schrieb Pascal Longrais <pascal.longr...@orange.fr>: > > >> Hello >> >> I am following Reindl Harald dbmail3-migration procedures. >> >> Upstream version dbmail v2.2.17 with mysql 5.5.21. >> >> Target server is dbmail v3.0.2 with mysql 5.5.21 and Reindl's proposed >> config setup files in dbmail3-migration.zip package (dbmail.conf, my.cnf). >> >> Used scenario was: >> >> 1) mysqldump dbmail from v2.2.17 >> >> 2) create fresh new dbmail v3 database >> >> 3) import mysqldump.sql >> >> 3) run sql-convert-2_2-3_0.sql >> >> After waiting several hours dodropkeys() procedure to be done, I got the >> following error: >> >> .... >> >> -------------- >> DROP TABLE IF EXISTS `dbmail_envelope` >> -------------- >> >> -------------- >> CREATE TABLE `dbmail_envelope` ( >> `physmessage_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', >> `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, >> `envelope` TEXT NOT NULL, >> PRIMARY KEY (`id`), >> UNIQUE KEY `physmessage_id_1` (`physmessage_id`), >> UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`id`), >> CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) >> REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 >> -------------- >> >> ERROR 1005 (HY000) at line 77: Can't create table >> 'dbmail.dbmail_envelope' (errno: 150) >> >> >> Thanks for your help >> Pascal >> >> >> _______________________________________________ >> 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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
