Answers.Body: <ol>
  <li>Go to your CiviHosting control panel and start 'phpMyAdmin'.</li>
  <li>Click on your CiviCRM database (left panel)</li>
  <li>In the list of tables click on the 'Type' column header to sort by it (easier to see all your MyISAM ones)</li>
  <li>Click one of the table names that shows as MyISAM</li>
  <li>Click 'Operations' tab at the top</li>
  <li>In the 'Table Options' section, change 'Storage Engine' to InnoDB</li>
  <li>Click Go</li>
  <li>Repeat as needed</li>
  </ol>
  <p>Re: &quot;Do I even need to bother?&quot;  CiviCRM goes to some effort to detect and warn you about this. If you know what the data integrity issues are and that they won't affect your db, then don't change it.   I don't know those details but it's a quick and easy fix so I follow the advice and change it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-15T15:25:10.983Z
Answers.Text: Great followed instructions above and now status is all good. Thanks!
Answers.UserDisplayName: emptyhometax
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-14T08:23:07.403Z
Answers.LastActivityDate: 2021-10-14T08:23:07.403Z
Answers.UserDisplayName: Aidan
Body: <p>I am getting this error when I use the CiviVoluteer extension on Worpress with CiviCRM version 5.39.0. I am hosted with CiviHosting.</p>
  <blockquote>
  <p>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.</p>
  </blockquote>
  <p>Everything still seems to be working in CiviCRM. I only get this message with CiviVolunteer enabled. There is a fix that seemed to work for folks
  <a href="https://civicrm.stackexchange.com/questions/9177/myisam-database-but-all-civicrm-tables-are-innodb-is-this-a-problem">MyISAM database but all civicrm_ tables are INNODB... is this a problem?</a></p>
  <p>but I am wondering to I even need to bother?</p>
  
Tags: <civivolunteer>
Title: CiviVolunteer gives MyISAM vs InnoDB error
ThreadText: # CiviVolunteer gives MyISAM vs InnoDB error
  
  (Asked by: username_0 on 2021-10-13)
  
  I am getting this error when I use the CiviVoluteer extension on Worpress with CiviCRM version 5.39.0. I am hosted with CiviHosting.
  
  > 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.
  
  Everything still seems to be working in CiviCRM. I only get this message with CiviVolunteer enabled. There is a fix that seemed to work for folks
  [MyISAM database but all civicrm\_ tables are INNODB... is this a problem?](https://civicrm.stackexchange.com/questions/9177/myisam-database-but-all-civicrm-tables-are-innodb-is-this-a-problem)
  
  but I am wondering to I even need to bother?
  
  **Tags:** civivolunteer
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-10-14. Score: 2
  
  1. Go to your CiviHosting control panel and start 'phpMyAdmin'.
  2. Click on your CiviCRM database (left panel)
  3. In the list of tables click on the 'Type' column header to sort by it (easier to see all your MyISAM ones)
  4. Click one of the table names that shows as MyISAM
  5. Click 'Operations' tab at the top
  6. In the 'Table Options' section, change 'Storage Engine' to InnoDB
  7. Click Go
  8. Repeat as needed
  
  Re: "Do I even need to bother?" CiviCRM goes to some effort to detect and warn you about this. If you know what the data integrity issues are and that they won't affect your db, then don't change it. I don't know those details but it's a quick and easy fix so I follow the advice and change it.
  
  > **Comments:**
  > **username_0**: Great followed instructions above and now status is all good. Thanks!  
  
  ---
  
  