I get this when adding a Agent/User to OTRS 2.2.25 : 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/
