You have an error in your SQL syntax;

Moderator: crythias

Post Reply
RickyA
Znuny newbie
Posts: 15
Joined: 20 Apr 2010, 19:58
Znuny Version: 2.7.4

You have an error in your SQL syntax;

Post by RickyA »

Hi otrsgurus

in my syslog an error appeared.


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND sq.group_id IN (1, 2, 3, 4, 5) AND st.until_time >= 1272464117 ORDER BY ' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 2, 3, 4, 5) AND st.until_time >= 1272464117 ORDER BY st.until_time ASC LIMIT 25'

I don't know where it came from, but if someone encountered it before i sure would like to get some advise how to solve this one.

I'm running on OTRS 2.4.7 ITSM 2.0.2...

Thanks in advance..
Best regards,

Ricky
Post Reply