Details
-
Type:
Bug
-
Status: CLOSED
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.9.0
-
Fix Version/s: 2.9.1
-
Component/s: Citations
-
Labels:None
-
Environment:MySQL 5.5.24 with variable lower_case_table_names=0 (the default); database conversion from 2.8.1 to 2.9.0
-
2.9 Status:Resolved
-
Conversion Script Required:Yes
Description
The distributed DB conversion script contains table names in lowercase; this fails for MySQL upgrades to Sakai 2.9.0 (from 2.8.1) because the database tablename was created in uppercase.
DB conversion script: sakai_2_8_2-2_8_3_mysql_conversion.sql
Details:
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 ... but the table in the DB is "CITATION_SCHEMA_FIELD".
The table name needs to be in uppercase for MySQL. The attached script runs without error.
Gliffy Diagrams
Zeplin
Attachments
Issue Links
- is related to
-
SAK-22700 SAK-16091 sql update is missing checked in upgrade scripts
-
- CLOSED
-