[Building Sakai] Database migration error (from 2.4 to 2.5)

[Kyong Kim]

Am,
Did you recently make MySQL variable changes or migrate from 
Windows/Mac to Ubuntu?
There is a MySQL variable that controls table name case sensitivity. 
This is normally a cross-platform problem.
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Kyong

At 05:28 PM 5/27/2009, Am Khan wrote:

>I am running into the following error with Sakai 2.6 on Ubuntu 9.04:
>
>2009-05-27 16:08:42,353  WARN main 
>org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select 
>ROLE_NAME from SAKAI_REALM_ROLE
>com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 
>'sakai.SAKAI_REALM_ROLE' doesn't exist
>
>This is after I have migrated our 2.4 database. I have checked the 
>database and I know that the table is there. I used the following 
>script to migrate:
>
>https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-0/docs/conversion/sakai_2_4_0-2_5_0_mysql_conversion.sql
>
>Seems like an issue with case sensitivity; is there a configuration 
>that I am missing?
>
>-Am
>
>-----Original Message-----
>From: Beth Kirschner [mailto:bkirschn at umich.edu]
>Sent: Wednesday, May 27, 2009 8:26 AM
>To: Am Khan
>Cc: sakai-dev at collab.sakaiproject.org
>Subject: Re: [Building Sakai] Database migration error (from 2.4 to 2.5)
>
>I'm guessing this is a problem with upper-case/lower-case table names.
>Which specific conversion script and database are you using?
>
>- Beth
>
>On May 26, 2009, at 5:53 PM, Am Khan wrote:
>
> >
> > I am trying to migrate Sakai 2.4 to Sakai 2.6; I am using the
> > following script and running in to errors:
> >
> > 
> https://source.sakaiproject.org/svn/reference/tags/sakai_2-4-1/docs/conversion/
> >
> > Errors:
> > Table 'sakai.ASSIGNMENT_SUBMISSION' doesn't exist
> > Table 'sakai.CALENDAR_EVENT' doesn't exist
> > Table 'sakai.CHAT2_CHANNEL' doesn't exist
> > Table 'sakai.CITATION_CITATION' doesn't exist
> >
> > Table 'sakai.CITATION_COLLECTION' doesn't exist
> > Table 'sakai.CITATION_SCHEMA' doesn't exist
> > Table 'sakai.CITATION_SCHEMA' doesn't exist
> >
> >
> > Table 'sakai.CITATION_SCHEMA_FIELD' doesn't exist
> > Table 'sakai.CONTENT_COLLECTION' doesn't exist
> > Table 'sakai.CONTENT_RESOURCE' doesn't exist
> >
> > Table 'sakai.CONTENT_RESOURCE_DELETE' doesn't exist
> >
> > Table 'sakai.GB_GRADABLE_OBJECT_T' doesn't exist
> >
> > Table 'sakai.GB_GRADEBOOK_T' doesn't exist
> >
> > Table 'sakai.MFR_MEMBERSHIP_ITEM_T' doesn't exist
> >
> > Table 'sakai.MFR_MESSAGE_T' doesn't exist
> > Table 'sakai.MFR_TOPIC_T' doesn't exist
> > Table 'sakai.MFR_UNREAD_STATUS_T' doesn't exist
> > Table 'sakai.POLL_OPTION' doesn't exist
> > Table 'sakai.POLL_POLL' doesn't exist
> > Table 'sakai.SAKAI_PERSON_T' doesn't exist
> > Table 'sakai.SAKAI_POSTEM_HEADINGS' doesn't exist
> >
> > Table 'sakai.SAKAI_REALM_FUNCTION' doesn't exist
> > Table 'sakai.SAKAI_REALM_RL_FN' doesn't exist
> >
> > Table 'sakai.SAKAI_REALM_ROLE' doesn't exist
> > Table 'sakai.SAKAI_SESSION' doesn't exist
> > Table 'sakai.SAKAI_SITE_TOOL' doesn't exist
> > Table 'sakai.SAM_ASSESSMENTGRADING_T' doesn't exist
> >
> >
> > Thanks and regards
> > Am Khan
> >
> > _______________________________________________
> > 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"
>
>_______________________________________________
>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"


Kyong Kim
Instructional Multimedia/Web Programmer
Foothill College
12345 El Monte Rd
3601
Los Altos Hills, CA 94022
650-949-7091