Loading...
 
Skip to main content

Add all relevant Manticore configurations to Tiki (including Allow configuring Manticore min_word_len when creating search index)

Status
Open
Subject
Add all relevant Manticore configurations to Tiki (including Allow configuring Manticore min_word_len when creating search index)
Version
30.x
Category
  • Feature request
Feature
Search
Resolution status
Accepted
Submitted by
Volker Wysk
Volunteered to solve
Adrien, Josaphat Imani Nathan
Lastmod by
Marc Laporte
Rating
(0)
Description

The Manticore server doesn't find words of length 2, when used by Tiki. It looks very much like only words of length 3 (or even 4) are indexed.

This depends on the configuration used when the tables are created inside of Manticore. It looks like Tiki specifies the "min_word_len" setting to be 3 (or even 4) when creating the "tiki_main_..." table inside Manticore. The SQL command in question is "CREATE TABLE tiki_main_... (...) min_word_len='3';"

I've searched the Tiki settings in the "Search" Control panel and couldn't find a setting for the minimum word length of Manticore.

The minimum can't be configured in manticore.conf, because it is set (so it seems) at table creation time, which is the time when Tiki rebuilds the search index.

This isn't about stopwords. I've tried with 2-letter-word which aren't.

When performing a search which only includes one 2-letter-word, I get the following error message:

  • Malformed search query: SQLSTATE42000: Syntax error or access violation: 1064 table tiki_main_69a052d856213: P08: syntax error, unexpected ')' near ' ) | (@title )'
Solution
Workaround
Importance
3
Easy to solve?
5
Priority
15
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
8954
Created
Saturday 14 March, 2026 11:45:10 UTC
by Volker Wysk
LastModif
Friday 04 September, 2026 15:09:39 UTC


Show PHP error messages