[Building Sakai] 2.9.0 DB Conversion, MySQL script error

[Gast, Cynthia (cmw6s)]

Thank-you for the information, Mark.  Our 'lower_case_table_names' is currently set to 0.  I'll ask our DBA about this.

BTW, we are running MySQL 5.5.24, and 'SHOW lower_case_table_names;'  threw a syntax error, so to see this variable setting I found I could use:
    show variables;

Thanks again,
Cynthia


________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Mark J. Norton [markjnorton at earthlink.net]
Sent: Wednesday, January 23, 2013 11:31 AM
To: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] 2.9.0 DB Conversion, MySQL script error

Have a look at http://www.google.com/url?q=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fidentifier-case-sensitivity.html&sa=D&sntz=1&usg=AFrqEzdg2e7ezXlIZjIiXeakJy7WhxejlA

There is a MySQL system variable called lower_case_table_names that should be to 1:  not case sensitive.  You can view the current value using this query:

    SHOW lower_case_table_names;

The variable can be set in your my.cnf file.

- Mark Norton

On 1/23/2013 11:01 AM, Gast, Cynthia (cmw6s) wrote:
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






_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto: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/20130123/a4db0b2a/attachment.html