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