Hi, 1. Beim Update von OTRS 2.2.6 auf OTRS 2.3.1 auf RHEL4 mit einer Oracle 10g Datenbank musste ich folgende Änderung im Skript DBUpdate-to-2.3.oracle.sql durchführen. -- ---------------------------------------------------------- -- alter table ticket -- ---------------------------------------------------------- ALTER TABLE ticket RENAME COLUMN escalation_start_time TO escalation_update_time; --- If column has data this alter statement is not possible!!! --- ALTER TABLE ticket MODIFY escalation_update_time NUMBER (12, 0) DEFAULT NULL; ALTER TABLE ticket ADD (escalation_update_time_tmp NUMBER(12, 0) NULL); UPDATE ticket SET escalation_update_time_tmp = escalation_update_time; COMMIT; ALTER TABLE ticket RENAME COLUMN escalation_update_time TO escalation_update_time_old; ALTER TABLE ticket RENAME COLUMN escalation_update_time_tmp TO escalation_update_time; ALTER TABLE ticket DROP COLUMN escalation_update_time_old; UPDATE ticket SET escalation_update_time = 0 WHERE escalation_update_time IS NULL; ALTER TABLE ticket MODIFY escalation_update_time NUMBER (12, 0) NOT NULL; 2. Ausserdem verstehe ich folgende 2 sql Statements nicht: ALTER TABLE article MODIFY a_body CLOB DEFAULT NULL; ALTER TABLE xml_storage MODIFY xml_content_value CLOB DEFAULT NULL; 3. Wenn jemand Probleme mit dem Skript DBUpdate-to-2.3.pl hat ein Tipp: Cache (/opt/otrs/var/tmp/) löschen hilft!!!! With best regards / Mit freundlichen Grüßen Otto Wehofer This message and any attachment ("the Message") are confidential. If you have received the Message in error, please notify the sender immediately and delete the Message from your system, any use of the Message is forbidden. Correspondence via e-mail is primarily for information purposes. Raiffeisen International neither makes nor accepts legally binding statements via e-mail unless otherwise agreed to the contrary. Information pursuant to § 14 Austrian Companies Code: Raiffeisen International Bank-Holding AG; Registered Office: Am Stadtpark 9, A-1030 Vienna; Company Register Number: FN 122.119 at the Commercial Court of Vienna