[BUGFIX] Remove quoting of search value in recycler 45/56645/2
authorAndreas Fernandez <a.fernandez@scripting-base.de>
Fri, 13 Apr 2018 06:46:11 +0000 (08:46 +0200)
committerJigal van Hemert <jigal.van.hemert@typo3.org>
Sun, 15 Apr 2018 17:44:08 +0000 (19:44 +0200)
This patch removes a wrong call of `$queryBuilder->quote()` which causes
a wrong SQL statement, as the search filter text gets passed as a named
parameter later on.

Resolves: #84710
Releases: master, 8.7
Change-Id: If9bd45687827e20142558f12acefea6b70290372
Reviewed-on: https://review.typo3.org/56645
Reviewed-by: Mathias Brodala <mbrodala@pagemachine.de>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Guido Schmechel <littlegee@web.de>
Reviewed-by: Susanne Moog <susanne.moog@typo3.org>
Reviewed-by: Daniel Haupt <dh@schiffel.it>
Tested-by: Daniel Haupt <dh@schiffel.it>
Reviewed-by: Jigal van Hemert <jigal.van.hemert@typo3.org>
Tested-by: Jigal van Hemert <jigal.van.hemert@typo3.org>
typo3/sysext/recycler/Classes/Domain/Model/DeletedRecords.php

index 59c8777..d543913 100644 (file)
@@ -274,7 +274,7 @@ class DeletedRecords
             $filterConstraint = $queryBuilder->expr()->like(
                 $GLOBALS['TCA'][$table]['ctrl']['label'],
                 $queryBuilder->createNamedParameter(
-                    $queryBuilder->quote('%' . $queryBuilder->escapeLikeWildcards($filter) . '%'),
+                    '%' . $queryBuilder->escapeLikeWildcards($filter) . '%',
                     \PDO::PARAM_STR
                 )
             );