CiviCRM Community Forums (archive)

In my Administration console, a warning just popped up:

"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 will be a fatal error in CiviCRM v2.1."

PHPmyAdmin shows that my Drupal (6.20) install is MyISAM, and my CiviCRM (3.4.0) is InnoDB. In CiviCRM there are some rows that are MyISAM, and look to be temp data:

civicrm_task_action_temp_6e6ce36362a99be43afc7d2e510a1754_8280  Browse Structure Search Insert     Empty Drop  33  MyISAM  utf8_unicode_ci

At the bottom of the PHPmyAdmin list of tables it also says this:

civicrm_worldregion   Browse  Structure  Search  Insert  Empty  Drop 6  InnoDB     utf8_unicode_ci     16.0 KiB     -

151 table(s)    Sum    8,093    MyISAM    latin1_swedish_ci    17.2 MiB


Elsewhere in the forums I see that Kurund found a bug in an earlier version of CiviCRM, so I believe this was fixed.

This is a week old install, so at this point what do I need to do, please.

I see you posted 2 files in the Issues tracker. Are they to replace the ones in my current 3.40 code? Should I delete the rows of what appears tobe temp data that has the MyISAM type?

Thanks for rapid work.