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=XXDUkX5ahrUXW+taU8CFx+6mjCX4QlPg5UvUzhTYl14iPAMfPLAQ2bb8oi8HZu5gm6PLLen0TEKz5yiCuESNOD/BgxEE421bYPpB4+bcnaUnwIcjtowPSwAZ/f/Uexxmi/vn6OKeMAMG9IXkbE9K8WuYLg93k8LXlTckNaBdKLw=
Message-ID: <8fb9ac720705160646w59b74517qae61eb35e3364dca@mail.gmail.com>
Date: Wed, 16 May 2007 09:46:02 -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: <BAY105-F3739540B8ACBE450A7DDDCAB3C0@phx.gbl>
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>

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/
>
>