Issue Bug Closed

#16131tools-> indexed search does not display external files

old_cbalisky 05/06/06, 19:58 updated 10/19/17, 21:59

Description

in file sysext/indexed_search/mod

// TYPO3 pages, unique
$res = $GLOBALS[‘TYPO3_DB’]->exec_SELECTquery(‘count() AS pcount,index_phash.’, ‘index_phash’, ‘item_type>0’, ‘phash_grouping,phash,cHashParams,data_filename,data_page_id,data_page_reg1,data_page_type,data_page_mp,gr_list,item_type,item_title,item_description,item_mtime,tstamp,item_size,contentHash,crdate,parsetime,sys_language_uid,item_crdate,externalUrl,recordUid,freeIndexUid’, ‘item_type’);

This request does not return any rows because of the item_type>0 condition.

My suggestion is to replace condition with ‘length(item_type)>1’ as follows. (;-) it’s only a suggestion …).

// TYPO3 pages, unique
$res = $GLOBALS[‘TYPO3_DB’]->exec_SELECTquery(‘count() AS pcount,index_phash.’, ‘index_phash’, ‘length(item_type)>1’, ‘phash_grouping,phash,cHashParams,data_filename,data_page_id,data_page_reg1,data_page_type,data_page_mp,gr_list,item_type,item_title,item_description,item_mtime,tstamp,item_size,contentHash,crdate,parsetime,sys_language_uid,item_crdate,externalUrl,recordUid,freeIndexUid’, ‘item_type’);

Blue Skies

(issue imported from #M3434)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.