sorry if this has already been covered, or sent to the wrong place, just trying to help.

the migration scripts need alteration to work, although the createdb.sql script is fine.

the following changes need to be made:

- change datatype BIT to NUMBER(1)
- change syntax 'ADD COLUMN' to 'ADD'

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.

this is tested on Oracle 9.2.10, although I believe it's also true of Oracle 10.

otherwise looks great so far, good work :)

HTH
        
--


Ben Avery
Software Developer
Youthnet UK

email: [EMAIL PROTECTED]
phone: 020 7288 7333
snail: 2-3 Upper Street
       London N1 0PQ

Reply via email to