Search index

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Search index

Post by Hervé »

Hi,
I'm using MySQL Fulltext search engine which works fine, but my PCA main page says (translated from french)
Warning
The selected search engine does not have a search index.
Please create the search index for "MySQL Fulltext" from the Search Index page.

Creating a search index takes less than one second after which I get the message
Information
All forum posts have been indexed.

But I still get the Warning while the search still works fine !
What can I do ?
I'm in 3.3.9
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Search index

Post by warmweer »

Can you show a printscreen of the ACP >tab Maintenance > Database > search index
and also of the search settings.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

This is your first request, I don't understand the second

Image
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Search index

Post by warmweer »

Your printscreen shows php Native Fulltext index populated, but MySQL Fulltext not poplulated.

If search works just fine you probably selected phpBB Native Fulltext in ACP - General - Server Configuration - Search Settings.
Strange though as MySQL Fulltext is marked Active so logically it should be used.
I suspect there's an automatic fallback on Native Fulltext if it's populated (but that's a guess - not fact).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

ACP - General - Server Configuration - Search Settings is set to MySQL Fulltext.
Should I delete phpBB Native Fulltext index ?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Search index

Post by Brf »

MySQL Fulltext, by default, does not have a search index. It lets MySql handle the searching.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

Well, I did : phpBB Native Fulltext index deleted.
Creating MySQL Fulltext index takes one second after which it is still not populated.
Search continues working fine Image

The Warning is still present as MySQL Fulltext does not need a search index.
I think the problem is just the warning which should not appear in case of MySQL Search.
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Search index

Post by warmweer »

Hervé wrote: Wed Dec 07, 2022 3:58 pm ACP - General - Server Configuration - Search Settings is set to MySQL Fulltext.
Should I delete phpBB Native Fulltext index ?
NO, unless it's taking up too much space.

If MySQL FullText index is empty and I use search I get the following error
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 423: mysqli_query(): (HY000/1191): Can't find FULLTEXT index matching the column list
This also happens on phpBB 3.3.8

After populating the MySQL Fulltext index it can be used as normal.

This is using PHP 8.0.7 (for 338 and 339) so I'll have to investigate further.

What's your PHP version?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

PHP 8.0.26
phpBB 3.3.9

None of the possible search indexes are populated.
Search method is MySQL Fulltext.
The Warning says "The selected search engine does not have a search index."
Search function works fine.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

No idea of the reason for the warning ?
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Search index

Post by warmweer »

Hervé wrote: Thu Dec 08, 2022 11:25 am No idea of the reason for the warning ?
You posted the reason yourself.
Hervé wrote: Wed Dec 07, 2022 4:43 pm None of the possible search indexes are populated.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

Hi,
This is true but I also wrote
Hervé wrote: Wed Dec 07, 2022 4:19 pmCreating MySQL Fulltext index takes one second after which it is still not populated.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Search index

Post by Brf »

Brf wrote: Wed Dec 07, 2022 4:16 pm MySQL Fulltext, by default, does not have a search index. It lets MySql handle the searching.
Hervé
Registered User
Posts: 414
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

Re: Search index

Post by Hervé »

If MySQL Fulltext does not have a search index why the Warning ?

I can only repeat my first message
I'm using MySQL Fulltext search engine, it works fine
but my PCA main page displays a Warning "The selected search engine does not have a search index. Please create the search index ..."
Creating a search index does not remove the warning.

I think the error is the warning.
User avatar
P_I
Community Team Member
Community Team Member
Posts: 2353
Joined: Tue Mar 01, 2011 8:35 pm
Location: Western Canada 🇨🇦
Contact:

Re: Search index

Post by P_I »

Have your tried clearing the phpBB cache via the ACP?

IIRC there are a number of configuration settings that get cached so perhaps there is a mismatch between cached values and ACP settings.
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
Post Reply

Return to “[3.3.x] Support Forum”