CiviCRM 4.7.10 --- WordPress 4.6
The following warning message appeared in CiviCRM System Status:
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.
This message appeared 5 days after upgrading to 4.7.10 from 4.7.8. The table with the MyISAM engine was: civicrm_task_action_temp%. I corrected it in MySQL using:
ALTER TABLE civicrm_task_action_temp% ENGINE=InnoDB;
On inspecting the code, I found the following in civicrm\civicrm\CRM\Contact\Form\Task.php on line 145
$sql = "CREATE TABLE {$form->_componentTable} ( contact_id int primary key) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci";
and civicrm\civicrm\CRM\Export\BAO\Export.php on line 1494
CREATE TABLE {$exportTempTable} ( ... ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
All other MyISAM tables are defined as TEMPORARY.
Prior to performing the upgrade, I cleaned the caches using CiviCRM/System Settings/Cleanup Caches and Update Paths. Hence the reason civicrm_task_action_temp% was recreated.
Hopefully, this fix can be included in the next update.
