Hello/Hi/Greetings,

I receive an error in the quick search query:

Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list
SELECT * FROM ve_tags
WHERE (MATCH(name) AGAINST( 'Bahn' IN BOOLEAN MODE)) in /mnt/web017/b2/07/51477207/htdocs/ve-katalog/include/dblayer/functions_mysqli.inc.php on line 845

Fatal error: Call to a member function fetch_assoc() on a non-object in /mnt/web017/b2/07/51477207/htdocs/ve-katalog/include/dblayer/functions_mysqli.inc.php on line 226

Piwigo version: 2.8.6
PHP version: 5.3.29
MySQL version: 5.6.35
Piwigo URL: http://www.ve-katalog.de

Update: I found out that the quick search query has problems with InnoDB and its way of indexing. But my provider, Strato, does not allow to change the default mySQL engine from InnoDB to MyISAM as it was used in older mySQL versions. Every attempt is rejected. But changing the engine would only be a workaround because InnoDB is already the current engine and perhaps MyISAM will disappear one day. So please make your search routine handle both engines.

Update 2: I have added manually fulltext indices to the columns concerned in the "tags" and "images" tables with php admin. This is what the programmers should already do in future when creating tables using InnoDB. But also I had to patch line 972 in "functions_search.inc.php" to following:

$clauses = array_merge($clauses, qsearch_get_text_token_search_sql($token, array('name')), qsearch_get_text_token_search_sql($token, array('comment')));

Now the quick search works fine. I think that for the complex search some more things have to be changed.

Last edited by wernerk (2017-02-09 00:25:37)