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 <[EMAIL PROTECTED]> 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 ? > _______________________________________________ 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