Fixed bug #12903: ORA-00918: column ambiguously defined [indexed_search]
authorXavier Perseguers <typo3@perseguers.ch>
Tue, 2 Feb 2010 13:52:57 +0000 (13:52 +0000)
committerXavier Perseguers <typo3@perseguers.ch>
Tue, 2 Feb 2010 13:52:57 +0000 (13:52 +0000)
git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@6837 709f56b5-9817-0410-a4d7-c38de5d9e867

ChangeLog
typo3/sysext/indexed_search/modfunc1/class.tx_indexedsearch_modfunc1.php

index 4137eeb..5db35c7 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2010-02-02  Xavier Perseguers  <typo3@perseguers.ch>
+
+       * Fixed bug #12903: ORA-00918: column ambiguously defined [indexed_search]
+
 2010-02-02  Steffen Kamper  <info@sk-typo3.de>
 
        * Follow-up to #13313: ExtDirect API
index 728a60b..b98fb68 100755 (executable)
@@ -295,7 +295,12 @@ class tx_indexedsearch_modfunc1 extends t3lib_extobjbase {
 
                        // Query:
                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
-                                       'ISEC.*, IP.*, count(*) AS count_val',
+                                       'ISEC.phash_t3, ISEC.rl0, ISEC.rl1, ISEC.rl2, ISEC.page_id, ISEC.uniqid, ' .
+                                       'IP.phash, IP.phash_grouping, IP.cHashParams, 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.externalUrl, IP.recordUid, IP.freeIndexUid, IP.freeIndexSetId, count(*) AS count_val',
                                        'index_phash IP, index_section ISEC',
                                        'IP.phash = ISEC.phash AND ISEC.page_id = '.intval($data['uid']),
                                        'IP.phash,IP.phash_grouping,IP.cHashParams,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,ISEC.phash,ISEC.phash_t3,ISEC.rl0,ISEC.rl1,ISEC.rl2,ISEC.page_id,ISEC.uniqid,IP.externalUrl,IP.recordUid,IP.freeIndexUid,IP.freeIndexSetId',