[BUGFIX] Fix SQL error in IndexSearchRepository 52/40752/3
authorTim Schreiner <schreiner.tim@gmail.com>
Tue, 30 Jun 2015 08:11:19 +0000 (10:11 +0200)
committerChristian Kuhn <lolli@schwarzbu.ch>
Tue, 30 Jun 2015 09:40:08 +0000 (11:40 +0200)
Add a missing "AND" concatenation to fix a SQL error.

Resolves: #67834
Releases: master, 6.2
Change-Id: I557ee19754462200a6baf52fd5b590c9b21eb21c
Reviewed-on: http://review.typo3.org/40752
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
Reviewed-by: Andreas Fernandez <typo3@scripting-base.de>
Tested-by: Andreas Fernandez <typo3@scripting-base.de>
typo3/sysext/indexed_search/Classes/Domain/Repository/IndexSearchRepository.php

index a114387..fc763de 100644 (file)
@@ -644,7 +644,7 @@ class IndexSearchRepository {
                                        break;
                        }
                        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('ISEC.*, IP.*', 'index_phash IP,index_section ISEC' . $page_join, 'IP.phash IN (' . $list . ') ' . $this->mediaTypeWhere() . $this->languageWhere() . $freeIndexUidClause . '
-                                                       AND IP.phash = ISEC.phash' . $page_where, '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', $orderBy);
+                                                       AND IP.phash = ISEC.phash AND ' . $page_where, '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', $orderBy);
                }
                return $res;
        }
@@ -816,4 +816,4 @@ class IndexSearchRepository {
        public function getJoinPagesForQuery() {
                return $this->joinPagesForQuery;
        }
-}
+}
\ No newline at end of file