Dave wrote:
On 9/15/06, Ben Avery <[EMAIL PROTECTED]> wrote:
sorry if this has already been covered, or sent to the wrong place, just
trying to help.
Thanks! We're flying blind with respect to Oracle since none of the
Roller committers actually use that database.
no probs, I need it to work on Oracle, so happy to help this part along.
the following changes need to be made:
- change datatype BIT to NUMBER(1)
- change syntax 'ADD COLUMN' to 'ADD'
Why the change from BIT to NUMBER(1) -- we use BIT in the database
creation script too, do we need to change that too?
you actually use NUMBER(1) in the database creation script, not BIT.
Oracle doesn't have a BIT datatype.
and in the 240-to-300-migration.sql, the line
alter table weblogentry add locale varchar(20) default null;
is unnecessary, the column already exists, from Roller 2.10 at least.
Does that cause an error or does Oracle ignore it and continue to
process the migration script?
It does give you an error, but doesn't do any harm, and carries on with
the rest of the migration script.
- Dave
this is tested on Oracle 9.2.10, although I believe it's also true of
Oracle 10.
--
Ben Avery
Software Developer
Youthnet UK
email: [EMAIL PROTECTED]
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
