Project

General

Profile

Actions

Bug #16931

closed

Table index_phash field phash_grouping

Added by Stefan Bothner almost 18 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2007-02-01
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I finished a product database which creates a category-navigation. I configured postVarSets in RealURL to become readable Links. My prefixId of the Ext. ist a longer one. I wondered why only short urls with less lenght of chars in the url was indexed and cached for indexed search, pages/links with longer URL was also cached, but without url-parameters. So after hours of debugging i find out that the serialized array of get-vars was too long for the field tinyblob. So i set to blob and it works fine. Maybe its better to set the field to blob in next version.

kr

stefan

This was on of mine URL's - wich is not parsed through postVarSet

produkte/produktuebersicht.html?tx_mzleutronview_pi2[pID]=89&tx_mzleutronview_pi2[catID]=2&tx_mzleutronview_pi2[subCatID]=10&tx_mzleutronview_pi2[subSubCatID]=14&tx_mzleutronview_pi2[cattitle]=Energietechnik&tx_mzleutronview_pi2[subcattitle]=Ueberspannungsableiter-Typ2--steckbar&tx_mzleutronview_pi2[subsubcattitle]=EnerPro-C-S-TNC-TNS-TT--Fehleranzeige&tx_mzleutronview_pi2[prodtitle]=EnerPro-C-S-TN-275&cHash=7a14667473

The same URL parsed by RealURL gives following URL which is less than 255 chars.

/produkte/produktuebersicht/chash/7a14667473/cat/2/10/14/prod/89/leutron/Energietechnik/Ueberspannungsableiter-Typ2--steckbar/EnerPro-C-S-TNC-TNS-TT--Fehleranzeige/EnerPro-C-S-TN-275.html
(issue imported from #M4906)

Actions #1

Updated by Chris topher about 14 years ago

Is the problerm that the field phash_grouping in the table index_phash is too short? A field of the type tinyblob can take up to 255 bytes. Currently the field is defined as int(11).

Actions #2

Updated by Alexander Opitz over 11 years ago

  • Status changed from New to Closed
  • Target version deleted (0)
  • TYPO3 Version set to 4.1

No response in over one year => closed.

Actions

Also available in: Atom PDF