I agree with that point. It's strange because i asked to "i can't remember who" if he had tested it, and he said yes. And i've just seen that it's not working.
Eric -----Message d'origine----- De : Ben Avery [mailto:[EMAIL PROTECTED] Envoyé : lundi 25 septembre 2006 15:59 À : [email protected] Objet : Oracle db creation script 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 ------------------------------------------------------------------------------------------- "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." **********************************************************************
