Mailing-List: contact user-help@roller.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@roller.apache.org
Received-SPF: pass (herse.apache.org: domain of snoopdave@gmail.com designates
 64.233.166.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=p7iD/sgqumCPu3PumJE4uyU2Khhs2PpdwLq+dnDRaLlucgNKT3FQs2t/mPi+FsDs5jAFTiWqWTbsVMz9QJM7JiKUcPnJOEjDI61Hz+nIIDMrtR9hkEDRQbAfMvDYuG5foCZKnsL5l9ITI/rJTWmkyJVlra1h7sb4zFClgj/Cu0g=
Message-ID: <8fb9ac720705181235v7a572e4bq79c41fd4863b63ae@mail.gmail.com>
Date: Fri, 18 May 2007 15:35:14 -0400
From: Dave <snoopdave@gmail.com>
To: user@roller.apache.org
Subject: Re: Problem running @300-to-310-migration.sql under Oracle 9
In-Reply-To: <8fb9ac720705160646w59b74517qae61eb35e3364dca@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <BAY105-F1363DA0BCD8FB276FB22D4AB3D0@phx.gbl>
	 <BAY105-F3739540B8ACBE450A7DDDCAB3C0@phx.gbl>
	 <8fb9ac720705160646w59b74517qae61eb35e3364dca@mail.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 <snoopdave@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 <jerrybate@hotmail.com> wrote:
> > 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/
> >
> >
>