When trying to create a ticket in an OTRS system with a pgsql customer
backend I get the following error while trying to search for the
customer in the From field:
ERROR: syntax error at or near ")" at character 247, SQL:
'SELECT username , username, human_name, email FROM person WHERE (
LOWER(username) LIKE LOWER('someone%') OR LOWER(human_name) LIKE
LOWER('someone%') OR LOWER(email) LIKE LOWER('someone%') )AND id in ( )
LIMIT 250'
the problem appears to be the "AND id in ( )" does anyone know how I
can correct this error or at least remove the offending piece of SQL
without editing the source?
-Mike
_______________________________________________
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 oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
