You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Jerry Bate <je...@hotmail.com> on 2007/05/15 19:15:27 UTC
Problem running @300-to-310-migration.sql under Oracle 9
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/
Re: Problem running @300-to-310-migration.sql under Oracle 9
Posted by Dave <sn...@gmail.com>.
re: http://opensource.atlassian.com/projects/roller/browse/ROL-1363
You sure that's the right fix? We want to drop the "not null"
requirement, but keep the id column in place. We do that now with
this:
alter table rag_group_subscription drop id not null
Your suggestion for Oracle is this:
alter table rag_group_subscription drop primary key;
Which looks like it drops the primary key column entirely.
- Dave
On 5/16/07, Dave <sn...@gmail.com> wrote:
> Thanks, I'll take a look at fixing that in the 3.1.1 fix release.
>
> - Dave
>
>
> On 5/16/07, Jerry Bate <je...@hotmail.com> wrote:
> > ok, I've found the fix, its here:
> >
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1363
> >
> >
> > >From: "Jerry Bate" <je...@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/
> >
> >
>
Re: Problem running @300-to-310-migration.sql under Oracle 9
Posted by Dave <sn...@gmail.com>.
Thanks, I'll take a look at fixing that in the 3.1.1 fix release.
- Dave
On 5/16/07, Jerry Bate <je...@hotmail.com> wrote:
> ok, I've found the fix, its here:
>
> http://opensource.atlassian.com/projects/roller/browse/ROL-1363
>
>
> >From: "Jerry Bate" <je...@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/
>
>
RE: Problem running @300-to-310-migration.sql under Oracle 9
Posted by Jerry Bate <je...@hotmail.com>.
ok, I've found the fix, its here:
http://opensource.atlassian.com/projects/roller/browse/ROL-1363
>From: "Jerry Bate" <je...@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/