Bug #45575
closedEpic #65814: Make Indexed search extbase plugin shine
indexed_search_mysql ignores "sections" settings
100%
Description
If you use the extension indexed_search_mysql with V 6.0.x and want to use "sections" you will find that this will not work.
The reason is simple: the method (sectionTableWhere) in parent class is not use in the hook
Solution:
Change in typo3/sysext/indexed_search/MysqlFulltextIndexHook.php
in Function execFinalQuery_fulltext() :
$resource = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
'index_fulltext.*, ISEC.*, IP.*',
'index_fulltext, index_section ISEC, index_phash IP' . $pageJoin,
'MATCH (' . $searchData['fulltextIndex'] . ') AGAINST (' . $GLOBALS['TYPO3_DB']->fullQuoteStr($searchData['searchString'], 'index_fulltext') . $searchBoolean . ') ' .
$this->pObj->mediaTypeWhere() . ' ' .
$this->pObj->languageWhere() .
$freeIndexUidClause . '
AND index_fulltext.phash = IP.phash
AND ISEC.phash = IP.phash
AND ' . $pageWhere,
'IP.phash,ISEC.phash,ISEC.phash_t3,ISEC.rl0,ISEC.rl1,ISEC.rl2,ISEC.page_id,ISEC.uniqid,IP.phash_grouping,IP.data_filename ,IP.data_page_id ,IP.data_page_reg1,IP.data_page_type,IP.data_page_mp,IP.gr_list,IP.item_type,IP.item_title,IP.item_description,IP.item_mtime,IP.tstamp,IP.item_size,IP.contentHash,IP.crdate,IP.parsetime,IP.sys_language_uid,IP.item_crdate,IP.cHashParams,IP.externalUrl,IP.recordUid,IP.freeIndexUid,IP.freeIndexSetId'
);
to
$resource = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
'index_fulltext.*, ISEC.*, IP.*',
'index_fulltext, index_section ISEC, index_phash IP' . $pageJoin,
'MATCH (' . $searchData['fulltextIndex'] . ') AGAINST (' . $GLOBALS['TYPO3_DB']->fullQuoteStr($searchData['searchString'], 'index_fulltext') . $searchBoolean . ') ' .
$this->pObj->mediaTypeWhere() . ' ' .
$this->pObj->languageWhere() .
$freeIndexUidClause . '
AND index_fulltext.phash = IP.phash
AND ISEC.phash = IP.phash
AND ' . $pageWhere . $this->pObj->sectionTableWhere(),
'IP.phash,ISEC.phash,ISEC.phash_t3,ISEC.rl0,ISEC.rl1,ISEC.rl2,ISEC.page_id,ISEC.uniqid,IP.phash_grouping,IP.data_filename ,IP.data_page_id ,IP.data_page_reg1,IP.data_page_type,IP.data_page_mp,IP.gr_list,IP.item_type,IP.item_title,IP.item_description,IP.item_mtime,IP.tstamp,IP.item_size,IP.contentHash,IP.crdate,IP.parsetime,IP.sys_language_uid,IP.item_crdate,IP.cHashParams,IP.externalUrl,IP.recordUid,IP.freeIndexUid,IP.freeIndexSetId'
);
Files
Updated by Steffen Gebert over 11 years ago
- Project changed from 9 to TYPO3 Core
- Assignee deleted (
Michael Stucki) - Target version deleted (
0.3)
Dear Quic-Viet,
I've moved this issue to the correct project. Thanks for reporting!
Updated by Quoc-Viet Phan over 11 years ago
Hi Steffen,
Thank you for moving the ticket in the right place.
Do you know what the process is for the ticket moves into the next release?
And how long will it take?
Sincerely,
Quoc-Viet.
Updated by Quoc-Viet Phan over 11 years ago
The file is : typo3/sysext/indexed_search/Classes/Hook/MysqlFulltextIndexHook.php
Not : typo3/sysext/indexed_search/MysqlFulltextIndexHook.php
Updated by Alexander Opitz over 10 years ago
- Category set to Indexed Search
- TYPO3 Version set to 6.0
- Is Regression set to No
Updated by Lorenz Ulrich over 9 years ago
I can confirm that this issue is still present in TYPO3 6.2
Updated by Tymoteusz Motylewski over 9 years ago
- Assignee set to Tymoteusz Motylewski
- Parent task set to #65814
Updated by Gerrit Code Review over 8 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/45976
Updated by Gerrit Code Review over 8 years ago
Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/46042
Updated by Tymoteusz Motylewski over 8 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 97d1ce3dbdc92d253913387af546e409b4f68472.
Updated by Benni Mack almost 6 years ago
- Status changed from Resolved to Closed