
25 May
2006
25 May
'06
8:01 p.m.
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