Project

General

Profile

Actions

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 about 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 #1

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.

Actions #2

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)?

Actions #3

Updated by Tymoteusz Motylewski about 9 years ago

  • Parent task set to #65815
Actions #4

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 :)

Actions #5

Updated by Alexander Opitz almost 9 years ago

  • Status changed from Needs Feedback to New
Actions #6

Updated by Susanne Moog about 4 years ago

  • Status changed from New to Closed

The field does not exist anymore in newer TYPO3 versions.

Actions

Also available in: Atom PDF