Hi Florent,
Florent Guiliani schrieb:
I'm trying to install OTRS (cvs from today) with Oracle.
The script initial_insert.sql is invalid with Oracle
The instruction:
INSERT INTO valid
(name, create_by, create_time, change_by, change_time)
VALUES
('valid', 1, current_timestamp, 1, current_timestamp);
give an error:
14:20:58 ('valid', 1, current_timestamp, 1, current_timestamp);
14:20:58 *
14:20:58 ORA-00984: column not allowed here
current_timestamp doesn't exist, Oracle use instead sysdate.
It's working for me on Oracle 10.2.0 (I also used it in Oracle 9).
Starting from 2.0.4 who is not Oracle compatible, I'm using cvs and
again the installation failed.
I think that I will have much problems with OTRS and Oracle... It seems
like Oracle is not used with OTRS
and I should go with another database engine. What do you think about it?
It's working on Oracle. There are already users which use OTRS on Oracle
a long time. :-)
But you also can use other databases. :-)
Florent,
Martin
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769
http://www.otrs.com/ :: Communication with success!
_______________________________________________
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
