[Building Sakai] Sakai 2.9.0 mysql conversion script failure

[Matthew Jones]

Looks like that line is at

455 ALTER TABLE MFR_HIDDEN_GROUPS_T
456     ADD CONSTRAINT FK1DDE4138A306F94D
457     FOREIGN KEY(a_surrogateKey)
458     REFERENCES mfr_area_t(ID)
459     ON DELETE RESTRICT
460     ON UPDATE RESTRICT;


My guess is it's case sensitivity on mft_area_t and something we missed
fixing in this script. Try making that table uppercase in the conversion
script, or changing my.cnf to be lower_case_table_names.

https://confluence.sakaiproject.org/pages/viewpage.action?pageId=37290167


On Mon, Nov 19, 2012 at 12:14 PM, Norman Danner <ndanner at wesleyan.edu>wrote:

> I am upgrading from 2.8.0 to 2.9.0.  After downloading
>
>
> http://source.sakaiproject.org/release/2.9.0/artifacts/sakai-src-2.9.0.tgz
>
> I start by applying the database conversion scripts:
>
>    $ mysql -u sakai -p sakai < sakai_2_8_0-2_8_1_mysql_conversion.sql
>    $ mysql -u sakai -p sakai < sakai_2_8_1-2_8_2_mysql_conversion.sql
>    $ mysql -u sakai -p sakai < sakai_2_8_2-2_8_3_mysql_conversion.sql
>
> All is well until...
>
>    $ mysql -u sakai -p sakai < sakai_2_9_0_mysql_conversion.sql
>    ERROR 1005 (HY000) at line 457: Can't create table
> 'sakai.#sql-1b01_21e' (errno: 150)
>
> Could someone tell me what I'm doing wrong?  Thanks!
>
>         - Norman
>
> --
> Norman Danner - ndanner at wesleyan.edu - http://ndanner.web.wesleyan.edu
> Department of Mathematics and Computer Science - Wesleyan University
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121119/55f26cf9/attachment.html