Advanced search feature does not work in 3.17

[ton-helmerhorst]

Dear all,

After updating phpmyfaq from version 3.12 to 3.17 the advanced search feture does not work. Acivating the feature advande search result in

Deze pagina werkt niettest.mijn-faq.nl kan dit verzoek momenteel niet verwerken.
HTTP ERROR 500

[thorsten]

Thanks for the hint!

[ton-helmerhorst]

Thanks for yor prompt reply.

I performed the modifications, but I don't get repsonse on the search question

I entered the system in debug mode and get the following error:

phpMyFAQ Fatal error
Uncaught exception: 'phpMyFAQ\Core\Exception'

Message: 'Error while fetching result: Can't find FULLTEXT index matching the column list'

Stack trace:

#0 /mnt/web109/e2/67/54355767/htdocs/faq10102022/src/phpMyFAQ/Relation.php(91): phpMyFAQ\Database\Mysqli->fetchAll()
#1 /mnt/web109/e2/67/54355767/htdocs/faq10102022/faq.php(184): phpMyFAQ\Relation->getAllRelatedByQuestion()
#2 /mnt/web109/e2/67/54355767/htdocs/faq10102022/index.php(759): require('...')
#3 {main}
Thrown in '/mnt/web109/e2/67/54355767/htdocs/faq10102022/src/phpMyFAQ/Database/Mysqli.php' on line 163

[thorsten]

I'll check that, thanks for the additional hint.

[thorsten]

I cannot reproduce this. Did you remove the FULLTEXT index on the table "faqdata"?

[ton-helmerhorst]

Hello,Can i check or repair the index?Verzonden vanuit Outlook voor iOS  Van: Thorsten Rinne ***@***.***>Verzonden: dinsdag, oktober 11, 2022 8:35 PMAan: thorsten/phpMyFAQ ***@***.***>CC: ton-helmerhorst ***@***.***>; Author ***@***.***>Onderwerp: Re: [thorsten/phpMyFAQ] Advanced search feature does not work in 3.17 (Issue #2228)  I cannot reproduce this. Did you remove the FULLTEXT index on the table "faqdata"? —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[thorsten]

ha, I found the issue now!

[ton-helmerhorst]

Hi<

I performed a new installation with 3.17 and a new database but I observe the same issue with this new installation

[thorsten]

Yes, I'm on it.

[ton-helmerhorst]

Many thanks for your great support!!! The search facility is restored!!!!