Issue Bug Closed

#67093Invalid SQL Query in BE UserSetup module

Morton Jonuschat 05/21/15, 19:49 updated 10/02/18, 11:44

Description

Error raised by DBAL/ADOdb:

ADOdb could not run this query: SELECT * FROM "be_users" WHERE 1 = 1 AND "pid" = 0 AND "username" NOT ILIKE "_cli_%" AND "uid" <> 1 AND "be_users"."disable" = 0 AND ("be_users"."starttime" <= 1432230180) AND ("be_users"."endtime" = 0 OR "be_users"."endtime" > 1432230180) AND "be_users"."deleted" = 0

Environment: TYPO3 7.3-dev, PostgreSQL 9.4 Database

Reason: The query param for ILIKE needs to be single quoted.

Reviews 1