Project

General

Profile

Actions

Bug #84022

closed

cObj->searchWhere is broken

Added by Sven Juergens over 6 years ago. Updated about 6 years ago.

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" 

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #78437: Refactor use of queryBuilder to use prepared statementsClosed2016-10-26

Actions
Actions

Also available in: Atom PDF