Actions
Bug #25797
closedEpic #65815: Improve Indexed search indexer
Column cHashParams of table index_phash should not be a BLOB
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2011-04-06
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
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), ...
Actions