Loading...
 
Skip to main content

Missing fulltext index for trackers after upgrade 1.9.4 -> 1.9.5

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Missing fulltext index for trackers after upgrade 1.9.4 -> 1.9.5
Version
1.9.x
Category
  • Error
Feature
Trackers
Search
Installer (profiles, upgrades and server-related issues)
Resolution status
Works For Me
Submitted by
fumphco
Volunteered to solve
fumphco
Lastmod by
Marc Laporte
Rating
(0)
Description

After upgrading 1.9.4 to 1.9.5, a search entire site returns the following error. I looked in db/fulltext.sql and didn't see a create fulltext index statement for tracker. What tables/columns should be indexed? 

in /home/lampp/htdocs/kniki/lib/tikidblib.php on line 134

Context:
File	/kniki/tiki-searchresults.php
Url	///kniki/tiki-searchresults.php?highlight=draw&where=pages&search=go
Query:
SELECT ttif.`itemId` AS name, LEFT(tt.`name`, 240) AS data, tt.`trackerId` AS hits, 
tti.`lastModif` AS lastModif, tti.`itemId` AS pageName,tti.`itemId` AS id1,1 AS id2, 
MATCH(`value`) AGAINST ('draw') AS relevance FROM `tiki_tracker_item_fields` ttif LEFT 
JOIN `tiki_tracker_items` tti ON (ttif.`itemId`=tti.`itemId`) LEFT JOIN `tiki_trackers`
 tt ON (tti.`trackerId`= tt.`trackerId`) LEFT JOIN `tiki_tracker_fields` ttf ON 
(ttf.`fieldId`= ttif.`fieldId`) WHERE ttf.`isSearchable` = "y" AND MATCH(`value`) 
AGAINST ('draw') ORDER BY relevance desc, tt.`trackerId`

Values:
Message:
Error Message	Can't find FULLTEXT index matching the column list
Solution

I found it in CVS. I guess it didn't make it into the 1.9.5 tarball.

tiki/db fulltext.sql,1.4,1.5

CREATE FULLTEXT INDEX ft ON tiki_tracker_item_fields(value);

Importance
1 low
Priority
5
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
882
Created
Monday 11 September, 2006 00:26:26 UTC
by Unknown
LastModif
Monday 20 April, 2009 06:59:43 UTC


Show PHP error messages