Pages: 1
Is there a way to disable search functionality in Piwigo?
My hosting provider allows me to use MySQL with InnoDB as a DB engine on Linux.
When I attempt to perform search, I get:
Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list
SELECT * FROM piwigo_tags
WHERE (MATCH(name) AGAINST( 'znaki znakis' IN BOOLEAN MODE)) in /homepages/{redacted}/piwigo.odkrywcy.com/include/dblayer/functions_mysqli.inc.php on line 864
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /homepages/{redacted}/piwigo.odkrywcy.com/include/dblayer/functions_mysqli.inc.php:228 Stack trace: #0 /homepages/{redacted}/piwigo.odkrywcy.com/include/functions_search.inc.php(1051): pwg_db_fetch_assoc(false) #1 /homepages/{redacted}/piwigo.odkrywcy.com/include/functions_search.inc.php(1395): qsearch_get_tags(Object(QExpression), Object(QResults)) #2 /homepages/{redacted}/piwigo.odkrywcy.com/include/functions_search.inc.php(1313): get_quick_search_results_no_cache('znaki', Array) #3 /homepages/{redacted}/piwigo.odkrywcy.com/include/functions_search.inc.php(1486): get_quick_search_results('znaki', Array) #4 /homepages/{redacted}/piwigo.odkrywcy.com/include/section_init.inc.php(364): get_search_results('7', NULL) #5 /homepages/{redacted}/piwigo.odkrywcy.com/index.php(12): include('/homepages/16/d...') #6 {main} thrown in /homepages/{redacted}/piwigo.odkrywcy.com/include/dblayer/functions_mysqli.inc.php on line 228
It must be a DB engine setup issue.
When I change DB engine to MyISAM, everything works fine. Unfortunately, my hosting provider automatically switches back to InnoDB after a day or so.
With another hosting provider I do not have issue with InnoDB and search.
The issue shows both in Piwigo 10.2 and 11.
The messages above are from Piwigo 11 version.
Last edited by tomasz (2021-01-20 13:40:01)
Offline
Never mind.
I created FULLTEXT indices on piwigo_tags and piwigo_images.
Everything work fine now.
Offline
Thank you for this feedback and this solution. Piwigo clearly relies on MyIsam behavior, not on InnoDB.
Offline
"I created FULLTEXT indices on piwigo_tags and piwigo_images.
Everything work fine now."
Please help me ... how can I do this?
I have the same problem with the search function.
Offline
I logged on to MySQL administration are where I have my website hosted and issued the following commands:
create fulltext index piwigo_tags_idx on piwigo_tags(name);
create fulltext index piwigo_categories_idx on piwigo_categories(name,comment);
create fulltext index piwigo_images_idx on piwigo_images(name,comment);
This worked for me.
Offline
Thanks for your quick response, I will try this.
Offline
Thanks, it worked fine for two of my websites.
On the third website it doesn´t work. I get the following error-code:
Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list
SELECT
*
FROM mc_piwigo_categories
INNER JOIN mc_piwigo_user_cache_categories ON id = cat_id and user_id = 1
WHERE (MATCH(name, comment) AGAINST( 'fenster' IN BOOLEAN MODE)) in ...
I created an fulltext index for mc_piwigo_categories, but what to do do eleminate the error regarding the "inner join"?
Do you have an idea what to do?
Offline
Can you post the whole query?
Offline
Here ist the complete error-message:
Warning: [mysql error 1191] Can't find FULLTEXT index matching the column list
SELECT
*
FROM mc_piwigo_categories
INNER JOIN mc_piwigo_user_cache_categories ON id = cat_id and user_id = 1
WHERE (MATCH(name, comment) AGAINST( 'beelitz' IN BOOLEAN MODE)) in /.../include/dblayer/functions_mysqli.inc.php on line 864
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /.../include/dblayer/functions_mysqli.inc.php:228 Stack trace:
#0 /.../include/functions_search.inc.php(1157): pwg_db_fetch_assoc(false)
#1 /.../include/functions_search.inc.php(1410): qsearch_get_categories(Object(QExpression), Object(QResults))
#2 /.../include/functions_search.inc.php(1327): get_quick_search_results_no_cache('beelitz', Array)
#3 /.../include/functions_search.inc.php(1500): get_quick_search_results('beelitz', Array)
#4 /.../include/section_init.inc.php(364): get_search_results('31', NULL)
#5 /.../index.php(12): include('/.../web116/d2/...')
#6 {main} thrown in .../include/dblayer/functions_mysqli.inc.php on line 228
Offline
I don't know. The message would indicate to me that
create fulltext index mc_piwigo_categories_idx on mc_piwigo_categories(name,comment);
was not successfully executed
Last edited by tomasz (2021-07-12 04:04:06)
Offline
I could solve the problem with creating fulltext-indexes for:
mc_piwigo_categories (name, comment)
mc_piwigo_images (name, comment)
:-)
Offline
Pages: 1