Bug #25797
closed
Epic #65815: Improve Indexed search indexer
Column cHashParams of table index_phash should not be a BLOB
0%
Description
Column cHashParams is configured as BLOB:
CREATE TABLE index_phash ( phash int(11) DEFAULT '0' NOT NULL, phash_grouping int(11) DEFAULT '0' NOT NULL, cHashParams blob, ...
When using DBAL with a MSSQL DBMS, the query in modfunc1 fails because it tries to GROUP BY this column and MSSQL does not allow a BLOB or IMAGE field to be used in GROUP BY.
Changing it to varchar(4000) solves the issue:
CREATE TABLE index_phash ( phash int(11) DEFAULT '0' NOT NULL, phash_grouping int(11) DEFAULT '0' NOT NULL, cHashParams varchar(4000), ...
Updated by Dmitry Dulepov over 12 years ago
I do not think it should be a column type change. Rather the whole algorithm should be changed. Now it groups by "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,freeIndexSetId", which is too much.
Updated by Alexander Opitz over 9 years ago
- Status changed from New to Needs Feedback
- Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (6.2.9)?
Updated by
Updated by Xavier Perseguers almost 9 years ago
DId not try again but if the column is still a blob and the group by has been kept (which is certainly the case) then yes, the problem still exists :)
Updated by Alexander Opitz almost 9 years ago
- Status changed from Needs Feedback to New
Updated by Susanne Moog over 4 years ago
- Status changed from New to Closed
The field does not exist anymore in newer TYPO3 versions.