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 Markus Klein over 9 years ago
shouldn't all strings in SQL be single quoted?
Updated by Gerrit Code Review over 9 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39754
Updated by Gerrit Code Review over 9 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39754
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset c93af24119b4af061e30e755afde78dc79eade52.
Updated by
Actions