Project

General

Profile

Actions
Copy link

Bug #25797

closed

Epic #65815: Improve Indexed search indexer

Column cHashParams of table index_phash should not be a BLOB

Added by Xavier Perseguers about 13 years ago. Updated over 4 years ago.

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
Copy link

Also available in: Atom PDF