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

[rudy pereda]

Am,

this problem is definitely a case sensitivity issue. This happens when
moving from a windows environment to a *nix environment.
Last time I encountered this problem, I exported the database, identified
all those table names that needed to be uppercase, and wrote a script to
change the table names in the exported file.
Once the exported file was modified, I imported it into MySQL and ran all
appropriate scripts.

HTHs,

-Rudy

On Wed, May 27, 2009 at 9:30 PM, Kyong Kim <kimkyong at fhda.edu> wrote:

> 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
>
> _______________________________________________
> 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/20090527/aa05f140/attachment.html