Actions
Bug #84022
closedcObj->searchWhere is broken
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2018-02-23
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:
Description
hi,
The returned string of cObj->searchWhere has changed with TYPO3 8 and Doctrine, respectively.
before you got a string like this
(testTable.field LIKE '%test%'
OR testTable.field1 LIKE '%test%'
OR testTable.fiel2 LIKE '%test%'
OR testTable.field3 LIKE '%test%')
now with TYPO3 8 you got a string like this
`testTable`.`field ` LIKE :dcValue1)
OR (`testTable`.`field1` LIKE :dcValue2)
OR (`testTable`.`field2` LIKE :dcValue3)
OR (`testTable`.`field3` LIKE :dcValue4)
With the new String you got a SQL Error like this:
Value for :dcValue2 not found in params array. Params array key should be "dcValue2"
Updated by Georg Ringer over 6 years ago
- Related to Task #78437: Refactor use of queryBuilder to use prepared statements added
Updated by Georg Ringer over 6 years ago
- Category set to Database API (Doctrine DBAL)
- Is Regression set to Yes
Updated by Gerrit Code Review over 6 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 https://review.typo3.org/55914
Updated by Sven Juergens over 6 years ago
HI Georg,
many thanks for your work.
The bugfix works like a charm :)
Best Regards
Sven
Updated by Gerrit Code Review over 6 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/55957
Updated by Georg Ringer over 6 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset c882e1cab26698fd28ea1c7ea7e39d839115d9d2.
Actions