Announcement

#1 2021-01-20 13:36:24

tomasz
Member
New Jersey, US
2021-01-19
7

[resolved] disable search, Can't find FULLTEXT index matching the column list

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

 

#2 2021-01-20 14:42:45

tomasz
Member
New Jersey, US
2021-01-19
7

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

Never mind.
I created FULLTEXT indices on piwigo_tags and piwigo_images.
Everything work fine now.

Offline

 

#3 2021-01-20 14:44:14

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

Thank you for this feedback and this solution. Piwigo clearly relies on MyIsam behavior, not on InnoDB.

Offline

 

#4 2021-07-09 23:00:14

kleiner_Hobbit
Member
Berlin
2017-08-22
67

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

"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

 

#5 2021-07-09 23:34:43

tomasz
Member
New Jersey, US
2021-01-19
7

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

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

 

#6 2021-07-10 00:08:21

kleiner_Hobbit
Member
Berlin
2017-08-22
67

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

Thanks for your quick response, I will try this.

Offline

 

#7 2021-07-10 10:28:54

kleiner_Hobbit
Member
Berlin
2017-08-22
67

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

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

 

#8 2021-07-11 16:34:14

tomasz
Member
New Jersey, US
2021-01-19
7

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

Can you post the whole query?

Offline

 

#9 2021-07-12 01:28:40

kleiner_Hobbit
Member
Berlin
2017-08-22
67

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

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

 

#10 2021-07-12 04:03:26

tomasz
Member
New Jersey, US
2021-01-19
7

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

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

 

#11 2021-07-12 09:30:55

kleiner_Hobbit
Member
Berlin
2017-08-22
67

Re: [resolved] disable search, Can't find FULLTEXT index matching the column list

I could solve the problem with creating fulltext-indexes for:

mc_piwigo_categories (name, comment)
mc_piwigo_images (name, comment)

:-)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact