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 <[EMAIL PROTECTED]> wrote:
Thanks, I'll take a look at fixing that in the 3.1.1 fix release. - Dave On 5/16/07, Jerry Bate <[EMAIL PROTECTED]> wrote: > 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/ > >
