that's right, I've just upgraded from 2.0 to 2.1 and had to fix this. I sent a revised version of the database creation script to the Roller dev list a few days ago - should be in the archives. The script for 2.0 was, if I recall correctly, fine for Oracle, and the error is just in the 2.1 version, which looks like a copy of the MySql version.
The other mistyped field is BIT, which Oracle (9) doesn't have either. This needs to be replaced with NUMBER(1) as a single digit number, as Oracle also doesn't have boolean fields. I found another problem with the Oracle database creation script, a not null field for the template table, I think. which means an error is thrown when you try to create a new template through the web interface, as empty varchar fields are null. I'll confirm this from work tomorrow. -----Original Message----- From: Dave Johnson [mailto:[EMAIL PROTECTED] Sent: Mon 13/03/2006 19:55 To: [email protected]; [email protected] Subject: Oracle users: verify that we should use "clob" instead of "text" According to issue ROL-1077, we should use the CLOB instead of TEXT data type in the create database script for Oracle. Can any Oracle users verify that this change is needed? http://opensource2.atlassian.com/projects/roller/browse/ROL-1077 -Dave
