[Building Sakai] 2.9.0 DB Conversion, MySQL script error

Gast, Cynthia (cmw6s) cmw6s at eservices.virginia.edu
Wed Jan 23 08:01:58 PST 2013


Hello:

In running the MySQL DB upgrade SQL scripts for a 2.9.0 upgrade (from 2.8.1), I received an error for the following script:  sakai_2_8_2-2_8_3_mysql_conversion.sql
    Error:  ERROR 1146 (42S02): Table 'sakai_29x_dev.citation_schema_field' doesn't exist

The script attempts to affect one table: update citation_schema_field ...

The table name needs to be in uppercase for MySQL.

Unsure if this has been reported.  If not, should SAK-22700 or SAK-16091 be re-opened, or a new issue opened?

Attaching the adjusted script, which runs without error after editing the table name.

Thanks,
Cynthia Gast, UVa



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130123/a1e3a6ef/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sakai_2_8_2-2_8_3_mysql_conversion.sql
Type: application/octet-stream
Size: 2638 bytes
Desc: sakai_2_8_2-2_8_3_mysql_conversion.sql
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130123/a1e3a6ef/attachment.obj 


More information about the sakai-dev mailing list