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/

 

<<image001.png>>

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

Reply via email to