[daisy] database upgrade error, 2.1 to 2.2-RC upgrade

[Karel Vervaeke]

Just dumping the trivial stuff here, maybe it will ring a bell and
someone will be able to give more information.

This is line 82 from the db upgrade script:
alter table document_versions add FOREIGN KEY (last_modifier) REFERENCES
users (id);

This page gives more information about the errno 150 message:
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

It still does not explain what exactly went wrong.  If we can reproduce
it, perhaps running the first 82 lines from the mysql commandline
followed by "SHOW ENGINE INNODB STATUS" could help

Regards,
Karel

On Tue, 2008-03-04 at 15:28 +0100, Jano Kula wrote:
> Hi,
> 
> while upgrading daisyrepository database with:
> 
> $>mysql -Ddaisyrepositorycsds -u<user> -p<password> < daisy-2_1-to-2_2.sql
> 
> I've got the following error:
> 
> ERROR 1005 (HY000) at line 82: Can't create table 
> './daisyrepositorycsds/#sql-427_12.frm' (errno: 150)
> 
> My daisyrepository database name is different from usual 
> "daisyrepository", but there is no database name in the upgrade script. 
> Access is OK; e.g. new "acl_accessdetail" table was already created. 
> Could you help me to resolve the issue? Thank you.
> 
> Jano
> 
> mysql server version: 5.0.32-Debian_7etch5-log Debian etch distribution
> 
> _______________________________________________
> daisy community mailing list
> Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
> mail to: daisy at lists.cocoondev.org
> list information: http://lists.cocoondev.org/mailman/listinfo/daisy