Martin Edenhofer wrote:
Hi Graziano,
On Wed, Jul 23, 2003 at 03:20:30PM +0200, Ruffoni Graziano wrote:
I would like to install OTRS using Oracle DB and I've got some problems.
The first error has been during the generation of SQL script for schema
cration using Torque 3.0.2 due to an error in otrs-schema.sql with the
<app-data> TAG, I've solved removing it.
After this I've got errors creating tables because some tables names are
Oracle keywords:
comment
That means it's not possible to is a column named comment?
It's possible only if you use "comment" in creation, insert and so on
session
This is the session table, you can drop it (it's just used for the database
session backend. default is the IPC (RAM) session backend).
and some index names are too long:
index_customer_preferences_user_id
index_ticket_loop_protection_sent_to
index_ticket_loop_protection_sent_date
You can cut the index names... but what is the max. length?
The max is 32
PS: It would be better to move on the dev-mailing list to discuss this
kind of topic. :)
Thanks
graziano
-Martin
--
Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/
--
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
I've another problem, in Oracle don't exist the autoincrement function,
in all the tables there is an ID field of this type.
The conseguence of this is that all the insert into this kind of tables
without the ID field are wrong:
ORA-01400: impossibile inserire NULL in ("OTRS"."TICKET_HISTORY"."ID")
The solution may be the creation of a sequence and a trigger on all
these tables that use the sequence value, I'm trying to implement this
but it's a bit revolution on the creation schema script.
bye
graziano
|
