I get this when adding a Agent/User to OTRS 2.2.25

 

Important: 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 ti.user_id = 1 AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id' at line 1, SQL: 'SELECT ar.id, ar.article_sender_type_id, ti.id, ar.create_by, ti.create_time_unix, ti.until_time, tst.name, ar.article_type_id FROM ticket ti, article ar, ticket_state ts, ticket_state_type tst WHERE ti.ticket_lock_id NOT IN ( ) AND ti.user_id = 1 AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id AND ts.type_id = tst.id ORDER BY ar.create_time DESC'

 

Andrew Meyer

Unix Systems Administrator

314-787-0681  x39

314-565-0868 (cell)

1300 Hampton Ave.

Ste. 200

Saint Louis, MO 63139

 

http://www.precisionpractice.com/