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
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.
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.
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
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.
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.
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é 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.
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.
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