Hi all,
I've installed otrs on Linux CentOS and Oracle as Database.
Everythings works well, but in logs I have
- Invalid Date '11-MAY-11'!
- ORA-01861: literal does not match format string (DBD ERROR: error
possibly near <*> indicator at char 252 in 'SELECT DISTINCT count(*)
FROM ticket st, queue sq , ticket_history th WHERE sq.id = st.queue_id
AND st.id = th.ticket_id AND sq.group_id IN (1, 2, 3, 26, 29, 61, 81)
AND th.history_type_id IN (1, 27) AND th.state_id IN (2, 3) AND
th.create_time <= <*>'2011-06-05 23:59:59' AND th.history_type_id IN (1,
27) AND th.state_id IN (2, 3) AND th.create_time >=
In all files where needed, I've setted these variables as well,
something like this :
ORACLE_HOME=/home/oracle/instantclient
NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
NLS_LANG="AMERICAN_AMERICA.al32utf8"
But, I always find these problems in logs.
Where I'm getting wrong?
Thanks
--
Emiliano Sgrano
---------------------------------------------------------------------
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
