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 ------------------------------------------------------------------------------------------- "Cette communication (y compris les pieces jointes) est reservee a l'usage exclusif du destinataire (des destinataires) et peut contenir des informations privilegiees, confidentielles, exemptees de divulgation selon la loi ou protegees par les droits d'auteur. Si vous n'etes pas un destinataire, toute utilisation, divulgation, distribution, reproduction, examen ou copie (totale ou partielle) est non-autorisee et peut etre illegale. Tout message electronique est susceptible d'alteration et son integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur de l'erreur de distribution et de la destruction du message. Merci. This transmission (including any attachments) is intended solely for the use of the addressee(s) and may contain confidential information including trade secrets which are privileged, confidential, exempt from disclosure under applicable law and/or subject to copyright. If you are not an intended recipient, any use, disclosure, distribution, reproduction, review or copying (either whole or partial) is unauthorized and may be unlawful. E-mails are susceptible to alteration and their integrity cannot be guaranteed.Sanofi Pasteur shall not be liable for this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and the mail deletion. Thank you." **********************************************************************
