Answers.Body: <p>This issue was fixed in CiviCRM 4.7.12 with this commit: <a href="https://github.com/civicrm/civicrm-core/commit/2475b5509e9638fa2e9863256348c5415f362b72" rel="nofollow">https://github.com/civicrm/civicrm-core/commit/2475b5509e9638fa2e9863256348c5415f362b72</a></p>
  
  <p>Cheers,
  Olivier;</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-13T06:01:34.967Z
Answers.LastActivityDate: 2016-10-13T06:01:34.967Z
Answers.UserDisplayName: Olivier Tétard
Answers.Body: <p>I've seen this warning pop up a couple of times in the last month. My CiviCRM database is InnoDB but I notice Wordpress is MyISAM. Clearing Civi's cache clears the message. I believe Wordpress can be converted to InnoDB, so I will investigate that.</p>
  
  <p>Wordpress 4.9.8, CiviCRM 5.6.0, MySQL 5.7.23, PHP 7.1.22</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-23T04:12:51.167Z
Answers.Text: I did convert Wordpress to InnoDB with no effect on the error, but I did trace the issue in CiviCRM to the Contribution Details report. When I run the report, I get a "civicrm_tmp_d_dflt_..." table for each page of output. Those tables are MyISAM, which is the default_storage_engine on my host (I can't change it). The error then appears, although it doesn't seem to hurt anything. It, and the tmp tables, go away when I clear cache.
Answers.UserDisplayName: Mark Westergaard
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-23T04:17:26.597Z
Answers.Text: I found a similar issue mention on Jira: https://issues.civicrm.org/jira/browse/CRM-8225
Answers.UserDisplayName: Mark Westergaard
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-12T18:30:42.953Z
Answers.LastActivityDate: 2018-10-12T18:35:44.390Z
Answers.LastEditDate: 2018-10-12T18:35:44.390Z
Answers.UserDisplayName: Mark Westergaard
Body: <p>On my install CiviCRM runs in a separate database that is entirely InnoDB, but Civi throws up the MyISAM engine error anyway.  The rest of wordpress lives in a DB that is InnoDB by default, although the tables are a mix of the two types, but I don't see why that matters. So why am I getting the MyISAM Engine error in Civi?  </p>
  
  <p>Versions: CiviCRM 4.7.11, wordpress 4.6.1, PHP 5.6.24, MySQL 5.0.11</p>
  
Tags: <wordpress><database>
Title: MyISAM engine error but the DB is all InnoDB
ThreadText: # MyISAM engine error but the DB is all InnoDB
  
  (Asked by: username_0 on 2016-10-13)
  
  On my install CiviCRM runs in a separate database that is entirely InnoDB, but Civi throws up the MyISAM engine error anyway. The rest of wordpress lives in a DB that is InnoDB by default, although the tables are a mix of the two types, but I don't see why that matters. So why am I getting the MyISAM Engine error in Civi?
  
  Versions: CiviCRM 4.7.11, wordpress 4.6.1, PHP 5.6.24, MySQL 5.0.11
  
  **Tags:** wordpress, database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-10-13. Score: 1
  
  This issue was fixed in CiviCRM 4.7.12 with this commit: <https://github.com/civicrm/civicrm-core/commit/2475b5509e9638fa2e9863256348c5415f362b72>
  
  Cheers,
  Olivier;
  
  
  ---
  
  ### Answer by username_2 on 2018-10-12. Score: 0
  
  I've seen this warning pop up a couple of times in the last month. My CiviCRM database is InnoDB but I notice Wordpress is MyISAM. Clearing Civi's cache clears the message. I believe Wordpress can be converted to InnoDB, so I will investigate that.
  
  Wordpress 4.9.8, CiviCRM 5.6.0, MySQL 5.7.23, PHP 7.1.22
  
  > **Comments:**
  > **username_2**: I did convert Wordpress to InnoDB with no effect on the error, but I did trace the issue in CiviCRM to the Contribution Details report. When I run the report, I get a "civicrm_tmp_d_dflt_..." table for each page of output. Those tables are MyISAM, which is the default_storage_engine on my host (I can't change it). The error then appears, although it doesn't seem to hurt anything. It, and the tmp tables, go away when I clear cache.  
  > **username_2**: I found a similar issue mention on Jira: https://issues.civicrm.org/jira/browse/CRM-8225  
  
  ---
  
  