[Building Sakai] [DG: User Experience] convert 2.4.x db to 2.5
Michael Korcuska
mkorcuska at sakaifoundation.org
Mon Jul 27 07:22:25 PDT 2009
This should really go to sakai-dev. Can anyone help Patrick out?
Michael
On Jul 27, 2009, at 03:54, Patrick Coleman wrote:
>
> I've tried this before and got no where so I'm going to try again....
>
> I have sakai 2.4.x running under mysql 4.1.22 on OS X 10.4
>
> I'm trying to upgrade to sakai 2.5 running under mysql 5.0.83
> running on OS
> X 10.5
>
> I download sakai_2_4_0-2_5_0_mysql_conversion.sql to convert the DB.
>
> I first dumped the DB from sakai 2.4 and import it into sakai 2.5
>
> (one thing I'm not clear on. Should I run sakai 2.5 with
> auto.ddl=true and
> then import the
> DB dump or just import it?)
>
> After this I run the conversion script on mysql with the -f
> parameter and I
> get 63 errors like
>
> ERROR 1048 (23000) at line 567: Column 'REALM_KEY' cannot be null
>
> This is on lines that look like...
>
> INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from
> SAKAI_REALM
> where REALM_ID = '!group.template.portfolio'), (select ROLE_KEY from
> SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select
> FUNCTION_KEY
> from SAKAI_REALM_FUNCTION where FUNCTION_NAME =
> 'osp.style.globalPublish'));
>
>
> There is no REALM_ID = '!group.template.portfolio' in SAKAI_REALM?
>
> So null is returned and SAKAI_REALM_RL_FN has 3 fields that can't be
> null.
> So can anyone tell me how to upgrade Sakai?
>
> Thanks.
>
> Pat.
> --
> View this message in context: http://www.nabble.com/convert-2.4.x-db-to-2.5-tp24671750p24671750.html
> Sent from the Sakai - User Experience mailing list archive at
> Nabble.com.
>
> _______________________________________________
> sakai-ux mailing list
> sakai-ux at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-ux
>
> TO UNSUBSCRIBE: send email to sakai-ux-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
--
Michael Korcuska
Executive Director, Sakai Foundation
mkorcuska at sakaifoundation.org
phone: +1 510-931-6559
mobile (US): +1 510-599-2586
skype: mkorcuska
More information about the sakai-dev
mailing list