Project

General

Profile

Actions

Bug #68667

closed

Indexed Serach: Experimental plugin produces invalid SQL-queries

Added by Felix Richter over 8 years ago. Updated over 8 years ago.

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.


Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #67843: Wrong queries in indexSearchRepositoryClosed2015-06-30

Actions
Actions #1

Updated by Wouter Wolters over 8 years ago

  • Status changed from New to Closed

Thanks for your report. There was already an report for this issue.
I will close this one as duplicate. Continue in #67843 please.

Actions

Also available in: Atom PDF