[Building Sakai] 2.9.0 DB Conversion, MySQL script error

[Mark J. Norton]

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
> 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/20130123/5b8bacb6/attachment.html