[Building Sakai] (no subject)

[Adrian Fish]

Hi all,

I'm currently testing a mysql db migration from a 2.8 db to 2.9 and have
hit a problem with this statement in the 2_9_0 conversion script.

ALTER TABLE MFR_HIDDEN_GROUPS_T
    ADD CONSTRAINT FK1DDE4138A306F94D
    FOREIGN KEY(a_surrogateKey)
    REFERENCES mfr_area_t(ID)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT;

Mysql throws this error:

ERROR 1005 (HY000) at line 391: Can't create table
'sakai_2_9_x.#sql-44d_47c' (errno: 150)

... and I found this in the Mysql forums:

http://forums.mysql.com/read.php?22,19755,200849#msg-200849

Anybody else hit this?

Cheers,
Adrian.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120816/3d843f68/attachment.html