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.
Issues with new 2.9.4 on MySQL 5.6.31
Moderator: Thorsten
Re: Issues with new 2.9.4 on MySQL 5.6.31
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
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
amazon.de Wishlist
Re: Issues with new 2.9.4 on MySQL 5.6.31
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
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