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 13 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 10 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 10 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 10 years ago
- Status changed from Needs Feedback to New
Updated by Susanne Moog over 5 years ago
- Status changed from New to Closed
The field does not exist anymore in newer TYPO3 versions.