[Building Sakai] upgrade from 2.4 to 2.5
Firdyiwek, Yitna (ybf2u)
ybf2u at eservices.virginia.edu
Wed Jul 29 15:37:18 PDT 2009
Sorry. Meant to send this to all:
...by the way, how many flipcams does Clemons have? Is there a need to plan borrowing one well in advance?
.y
-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Patrick Coleman
Sent: Wednesday, July 29, 2009 4:17 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] upgrade from 2.4 to 2.5
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/upgrade-from-2.4-to-2.5-tp24684670p24684670.html
Sent from the Sakai - Development mailing list archive at Nabble.com.
_______________________________________________
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"
More information about the sakai-dev
mailing list