Project

General

Profile

Actions

Bug #67093

closed

Invalid SQL Query in BE UserSetup module

Added by Morton Jonuschat almost 9 years ago. Updated over 5 years ago.

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.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #66801: Hide CLI users in simluate user select box ClosedMarkus Klein2015-05-05

Actions
Actions #1

Updated by Markus Klein almost 9 years ago

shouldn't all strings in SQL be single quoted?

Actions #3

Updated by Gerrit Code Review almost 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

Actions #4

Updated by Gerrit Code Review almost 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

Actions #5

Updated by Morton Jonuschat almost 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF