[FOLLOWUP][BUGFIX] Fix SQL error in IndexSearchRepository 60/40760/2
authorWouter Wolters <typo3@wouterwolters.nl>
Tue, 30 Jun 2015 09:27:28 +0000 (11:27 +0200)
committerWouter Wolters <typo3@wouterwolters.nl>
Tue, 30 Jun 2015 09:38:43 +0000 (11:38 +0200)
Add a missing "AND" concatenation to fix a SQL error.

Resolves: #67834
Releases: master
Change-Id: Ide173f13d9142b05db625648bf1ce995749ff233
Reviewed-on: http://review.typo3.org/40760
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 d11c8a8..b653aca 100644 (file)
@@ -645,7 +645,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 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);
+                                                       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;
        }