I've found another problem with the Oracle creation script - it is creating the webpage table with the template field as NOT NULL, which means you can't add new templates.

so, line 71, replace

    template        clob not null,

with

    template        clob,

IIRC, this has been a bug in the Oracle tables for a while. I fixed it by hand in my Roller installation that I upgraded, so didn't notice it in the migration file either. to fix this, the migration script should make this column nullable, so to append this line to the 240-to-300-migration.sql file:

alter table webpage modify( template null);

it won't break anything if the column is already nullable.

--


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