Database migration script gives errors?

Description

I'm upgrading from Sakai 2.4.1 to 2.5.3

I'm try to migrate the database. I've download scripts for
sakai_2_4_0-2_5_0
sakai_2_5_0-2_5_1
sakai_2_5_0-2_5_2

When I try and run the first I get errors? First it complains that at line 57 "gb_category_t" is unknown. It tried to drop it before it creates it.
So I commented out the "DROP" statement. Then ran it again. It then gets another error that said

Column "REALM_KEY" cannot be null.

I gave up there. Anyone know why I'm getting these errors? The last time I upgraded a few years ago I remember having a lot of problems
with the DB migration. Any help appreciated.

Thanks.

Pat.

Activity

Show:

David Horwitz January 26, 2010 at 6:37 AM

Issues like this should be raised on the mailing lists

Ian Boston March 4, 2009 at 2:15 AM

I am unable to work on these issues at this time, sorry.

Patrick Patrick February 6, 2009 at 5:20 AM

I've noticed that in the table "SAKAI_REALM" the conversion script is trying to select a "REALM_ID" that does not exist in the table?

'group.template.portfolio'

There is 'group.template' & 'group.template.course' but no portfolio?

Pat.

Won't Fix

Details

Priority

Affects versions

Components

Assignee

Reporter

Environment

OS X 10.4.11
Created February 5, 2009 at 7:05 PM
Updated January 26, 2010 at 6:37 AM
Resolved January 26, 2010 at 6:37 AM