7 Dec 2005 15:19
Re: inital_insert.sql and Oracle
Florent Guiliani <fguiliani <at> perinfo.com>
2005-12-07 14:19:43 GMT
2005-12-07 14:19:43 GMT
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
RSS Feed