OTRS : problem with date on Oracle

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
participants (1)
-
Emiliano Sgrano