ok, I've found the fix, its here:
http://opensource.atlassian.com/projects/roller/browse/ROL-1363
From: "Jerry Bate" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
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/
