Hey guys!
I'm quite new to this and I've been playing with Piwigo for the past couple of days. I absolutely love it!!! Any ideas though why this error is occurring when I use quicksearch?
Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list
SELECT * FROM piwigo_tags
WHERE (name REGEXP '[[:<:]]Amy[[:>:]]'
OR MATCH(name) AGAINST( 'Amies' IN BOOLEAN MODE)) in /homepages/3/d531441881/htdocs/woodfamilytree/include/dblayer/functions_mysqli.inc.php on line 864
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /homepages/3/d531441881/htdocs/woodfamilytree/include/dblayer/functions_mysqli.inc.php:228 Stack trace: #0 /homepages/3/d531441881/htdocs/woodfamilytree/include/functions_search.inc.php(1065): pwg_db_fetch_assoc(false) #1 /homepages/3/d531441881/htdocs/woodfamilytree/include/functions_search.inc.php(1409): qsearch_get_tags(Object(QExpression), Object(QResults)) #2 /homepages/3/d531441881/htdocs/woodfamilytree/include/functions_search.inc.php(1327): get_quick_search_results_no_cache('Amy', Array) #3 /homepages/3/d531441881/htdocs/woodfamilytree/include/functions_search.inc.php(1500): get_quick_search_results('Amy', Array) #4 /homepages/3/d531441881/htdocs/woodfamilytree/include/section_init.inc.php(364): get_search_results('9', NULL) #5 /homepages/3/d531441881/htdocs/woodfamilytree/index.php(12): include('/homepages/3/d5...') #6 {main} thrown in /homepages/3/d531441881/htdocs/woodfamilytree/include/dblayer/functions_mysqli.inc.php on line 228
Thanks so much
James
Offline
Searching the forum could help many times, for example for Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list.
See [Forum, topic 30893] disable search, Can't find FULLTEXT index matching the column list
Offline
Thanks so much! :) Sorry for not searching
Offline