MySQL 5.5.5 – potential phpMyFAQ installation and working problem – storage engine type
Dear Thorsten
Creating an efficient, user-friendly and simple thing (program, painting, whatever...) is difficult and implies hard work and expertise.
phpMyFAQ’s installation and update procedures fall in this category.
So, we’re almost sure that the potential problem described in this post was already identified – in this case, or if we are wrong about SQL statements, please ignore it and accept our apologies.
The default storage engine for tables created by MySQL versions prior to 5.5.5 is MyISAM. Now it is the InnoDB type [1].
phpMyFAQ uses (as far as we know) FULLTEXT indexes in one table. InnoDB "tables" don’t support it.
If the user creates a “default” MySQL 5.5.5 database for phpMyFAQ installation, there may be a potential problem when using the phpMyFAQ-driven site.
A possible solution is to use the explicit MyISAM storage engine type in the SQL table creation instruction (where applicable) – but we aren’t experts in this subject.
[1] MySQL :: MySQL 5.5 Reference Manual :: 13 Storage Engines. http://dev.mysql.com/doc/refman/5.5/en/ ... gines.html .
“InnoDB is the default storage engine as of MySQL 5.5.5.”
(…)
“MyISAM is supported in all MySQL configurations, and is the default storage engine prior to MySQL 5.5.5.”
Kind regards
2011-08-04
pt20100201
.