Actions
Bug #67093
closed
Invalid SQL Query in BE UserSetup module
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-05-21
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
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.
Updated by 
Updated by 
Updated by 
Updated by
Actions