Loading...
 
Skip to main content

indexing fails due to Data too long for column 'tracker_field_wikipage_raw' at row 1

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
indexing fails due to Data too long for column 'tracker_field_wikipage_raw' at row 1
Version
21.x
21.x Regression
22.x
Category
  • Error
  • Regression
Feature
Search
Resolution status
Fixed or Solved
Submitted by
Xavier de Pedro
Volunteered to solve
Jonny Bradley
Lastmod by
Xavier de Pedro
Rating
(0)
Description

We have noticed at work that our production tiki (using Tiki 21) doesn't seem to find pages through the search feature, since months ago.

In these last months (since feb 2020) we've migrated our tiki site between servers, and upgraded our old tiki20 to tiki21 a few months ago.

I've tried to run the search index through the console.php command index:rebuild, and I seem to hit this type of errors:

Copy to clipboard
...
error: Indexing failed while processing "Wiki Help" (type wiki page) with the error "Could not perform index modification: Data too long for column 'tracker_field_petDocWikiNova_raw' at row 1"
error: Indexing failed while processing "1" (type category) with the error "Could not perform index modification: Data too long for column 'tracker_field_petDocWikiNova_raw' at row 1"
...

Indexed
Undefined index: counts on line 162 of /path/lib/core/Tiki/Command/IndexRebuildCommand.php
Invalid argument supplied for foreach() on line 162 of /path/lib/core/Tiki/Command/IndexRebuildCommand.php
Rebuilding index done
Index: index_5f8f52c635dcb
Execution time: 3 mins
Current Memory usage: 171.6 MiB
Memory peak usage before indexing: 16.9 MiB
Memory peak usage after indexing: 188.4 MiB
Number of queries: 253406

PDO::query(): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'tracker_field_petDocWikiNova_raw' at row 1 on line 104 of /path/lib/core/TikiDb/Pdo.php
root@server:/path#


This tracker field with permanentName petDocWikiNova is a wiki page type of field. And it hold data from long wiki pages (documentation related to projects in a project management scenario based on trackers)

We need help to get this regression fixed (search feature worked fine for us in Tiki 19 and Tiki20).

Solution

Hopefully {glitlab id=043aab98} in 22.x

Importance
8
Easy to solve?
5
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7582
Created
Tuesday 20 October, 2020 21:32:08 UTC
by Xavier de Pedro
LastModif
Saturday 31 October, 2020 20:21:51 UTC


Show PHP error messages