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,

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Reply via email to