roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jerry Bate" <jerryb...@hotmail.com>
Subject RE: Problem running @300-to-310-migration.sql under Oracle 9
Date Wed, 16 May 2007 11:26:26 GMT
ok, I've found the fix, its here:

http://opensource.atlassian.com/projects/roller/browse/ROL-1363


>From: "Jerry Bate" <jerrybate@hotmail.com>
>Reply-To: user@roller.apache.org
>To: user@roller.apache.org
>Subject: Problem running @300-to-310-migration.sql under Oracle 9
>Date: Tue, 15 May 2007 17:15:27 +0000
>
>In /apache-roller-3.1/webapp/roller/WEB-INF/dbscripts/oracle I ran the 
>above script to migrate from 3 to 3.1, and got this error:
>
>SQL> alter table rag_group_subscription drop id not null;
>alter table rag_group_subscription drop id not null
>                                        *
>ERROR at line 1:
>ORA-00905: missing keyword
>
>
>
>I tried to guess the right syntax, and ran this, and got the following 
>response:
>
>SQL> alter table rag_group_subscription modify id null;
>alter table rag_group_subscription modify id null
>                                          *
>ERROR at line 1:
>ORA-01451: column to be modified to NULL cannot be modified to NULL
>
>
>
>Presumably I violated a primary key constraint.
>
>I'm new to this list (and new to upgrading Roller), so I apologise if I'm 
>not posting to the right place, or if I've missed the documentation.
>
>Jerry
>
>_________________________________________________________________
>Reserve your place in history - Email Britain! 
>http://www.emailbritain.co.uk/
>

_________________________________________________________________
Txt a lot? Get Messenger FREE on your mobile. 
https://livemessenger.mobile.uk.msn.com/


Mime
View raw message