Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-23164

DB conversion script fails to update MySQL table due to lowercase table name

    XMLWordPrintable

    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

                Activity

                  People

                  Assignee:
                  aaronz Aaron Zeckoski (Inactive)
                  Reporter:
                  cmw6s Cynthia Gast
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration