Mysql upgrade script from 1.4.3 to 1.5.0 does not work

Steps to reproduce

Steps to reproduce:
1. get a Matterhorn 1.4.3+ mysql database
2. use the mysql upgrade script from 1.4.3_to_1.5.0
3. I get the error:
ERROR 1005 (HY000) at line 4: Can't create table 'matterhorneinsvier.mh_role' (errno: 150)

The table mh_role is renamed to mh_role_tmp with different columns. errno is:
If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the right column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not satisfied, MySQL returns error number 1005 and refers to error 150 in the error message.

Status

Assignee

Lukas Rohner

Reporter

RĂ¼diger Rolf

Severity

Incorrectly Functioning Without Workaround

Tags (folksonomy)

Components

Fix versions

Affects versions

1.5.0

Priority

Blocker
Configure