Actions
Bug #68667
closedIndexed Serach: Experimental plugin produces invalid SQL-queries
Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2015-07-31
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
I use the experimental plugin of indexed_search without the mysql-driver. When I submit the searchform, an invalid SQL query gets produced:
WHERE () AND ....
The Problem can be found in IndexSearchRepository.php. In line 271 $wsel is set to an empty string. Nothing happens after this with this variable . The empty string gets then pushed into $this->wSelClauses.
In line 614 all the empty strings are put into the SQL query:
$wordSel = '(' . implode(' OR ', $this->wSelClauses) . ') AND ';
Because the imploded array is an empty string, the query is invalid and no results are shown in the result list, although there should be some.
When I remove this invalid part from the query, the search works just fine.
Actions