Issues with new 2.9.4 on MySQL 5.6.31

Please report bugs here!

Moderator: Thorsten

Post Reply
babutz
Posts: 3
Joined: Sun Aug 14, 2016 6:51 pm

Issues with new 2.9.4 on MySQL 5.6.31

Post by babutz »

My Webhoster recently upgraded the MySQL-Version from 5.5.48 to 5.6.31. The webpage looked normal but when I pressed a link to an FAQ, I got a blank (white) page.

I did enbale DEBUG mode and get the error message below (instead of the blank (white) page:
Fatal error: Uncaught Exception: Error while fetching result: Can't find FULLTEXT index matching the column list in /.../inc/PMF/DB/Mysqli.php:183 Stack trace: #0 /.../inc/PMF/Relation.php(106): PMF_DB_Mysqli->fetchAll(false) #1 /.../artikel.php(174): PMF_Relation->getAllRelatedById('1', 'Wof\xC3\xBCr steht FA...', '') #2 /.../index.php(766): require('/mnt/webq/e2/99...') #3 {main} thrown in /.../inc/PMF/DB/Mysqli.php on line 1

To verify I did setup a "virgin" phpMyFAQ webpage on MySQL 5.6.31 with the same result - but it works fine when I use an MySQL 5.5.48.
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Issues with new 2.9.4 on MySQL 5.6.31

Post by Thorsten »

Hi,

I'm running 5.6.27 and I do not get the error. Will try to update my MySQL version to check your issue.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
babutz
Posts: 3
Joined: Sun Aug 14, 2016 6:51 pm

Re: Issues with new 2.9.4 on MySQL 5.6.31

Post by babutz »

The problem is because the webhoster migrated the table type from MyISAM to InnoDB.

To solve the issue, just do a "alter table ... engine=MyISAM;" for all tables of your phpMYFAQ installation and it should hopefully work again.

Marc
Post Reply