7 Dec
2005
7 Dec
'05
2:19 p.m.
Florent Guiliani a écrit :
I'm using Oracle 8.1.7.4 and current_timestamp or initial_insert.sql are not working :(
Another defect in otrs-schema-post.oracle.sql: ALTER TABLE valid ADD CONSTRAINT fk_valid_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id);
This statments failed because after initial_insert.sql, the table system_user contains the Admin user and his ID is 3 not 1.
Perhaps this failure is due to my many attemps to execute the script... never mind I will update system_user manuelly... But if OTRS is using current_timestamp so OTRS is not supporting Oracle 8 ? Florent,