ignore my previous email, the problem was resolved, it was due to a bad LDAP config on my part. if anyone is interested in setting up LDAP access via Lotus Domino, you can find the config that worked for me here, http://tinyurl.com/5gz96l On Wed, Nov 19, 2008 at 3:54 PM, Sam Ami wrote:

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 ?