hi all i'm getting the below error with my OTRS installation v2.1.5 after setting up LDAP authentication against our Lotus Domino LDAP directory. authentication is successful and i can get access to the web interface, however i can't see any company tickets even though the CustomwerID is the correct/same.
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 ') OR st.customer_user_id = 'johnsmith') AND sq.group_id IN (1, 1) AND LOWER(s' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( 1, 4, 6, 7, 8 ) AND (LOWER(st.customer_id) IN () OR st.customer_user_id = 'johnsmith') AND sq.group_id IN (1, 1) AND LOWER(st.customer_id) IN ( ) ORDER BY st.create_time_unix DESC LIMIT 10000' any suggestions ? _______________________________________________ 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