Hi fellow OTRS users and devs,

Since we added a new pending auto state called "pending auto open" we get allot of errors in our log as below. Does any of you have an idea what is causing this and what a possible solution could be? Thanks in advance.

[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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 st.ticket_lock_id IN (2) AND st.user_id IN (4) AND sq.group_id IN (1, 2, ' 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 st.ticket_lock_id IN (2) AND st.user_id IN (4) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 ORDER BY st.until_time DESC LIMIT 10'
[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_sta' at line 1, SQL: 'SELECT DISTINCT count(*) 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, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 LIMIT 10000'
[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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 st.ticket_lock_id IN (2) AND st.user_id IN (4) AND sq.group_id IN (1, 2, ' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id = st.queue_id AND st.ticket_state_id IN (  )  AND st.ticket_lock_id IN (2) AND st.user_id IN (4) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 LIMIT 10000'
[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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 st.queue_id IN (999999) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id = st.queue_id AND st.ticket_state_id IN (  )  AND st.queue_id IN (999999) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 LIMIT 10000'
[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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 st.responsible_user_id IN (4) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8,' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id = st.queue_id AND st.ticket_state_id IN (  )  AND st.responsible_user_id IN (4) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 LIMIT 10000'
[Tue Mar 23 14:10:50 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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, 6, 7, 8, 9, 10, 11, 12)  AND tw.user_id IN' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw  WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN (  )  AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)  AND tw.user_id IN (4) AND st.ticket_state_id IN (10)  AND st.until_time <= 1269349790 LIMIT 10000'
[Tue Mar 23 14:10:51 2010][Error][Kernel::System::Ticket::TicketSearch][4761] 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, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_sta' 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, 6, 7, 8, 9, 10, 11, 12)  AND st.ticket_state_id IN (10)  AND st.until_time >= 1269348951 ORDER BY st.until_time ASC LIMIT 25'

Holly Avramovic Customer Service Checkpoint Systems Akkermansbeekweg 12 7061 ZA, Terborg The Netherlands Tel: +31 (0)315 39 5928 holly.avramovic@eur.checkpt.com www.checkpointsystems.com P Please consider the environment before printing this message