[I'm not subscribing to this list, so this might not appear in the right
thread]
hi Eric,
yes, template creation is working fine in 3.0rc1 on Oracle 9, no errors
thrown.
Ben
~~
Hi Ben,
I've no time right now to check for the Oracle version, but i'm
interested by that :
Could you check that the template creation is now possible? (it was not
in 2.3 due to a not
nullable column in the webpages table).
Regards
Eric
-----Message d'origine-----
De : Ben Avery [mailto:[EMAIL PROTECTED]
Envoy� : vendredi 15 septembre 2006 14:01
� : [email protected]
Objet : Oracle db scripts for 3.0
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
