Warning to convert MySQL Tables From MyISAM to InnoDB

  • Resolved heretiq

    (@heretiq)


    4 years, 3 months ago

    Hello, Thanks for creating and making this excellent plugin available to the WP community! I’m building a site that is hosted on Pantheon — which uses InnoDB instead of MYyISAM for MySQL, and .. I am receiving the following warning and guidance to convert the three identified WPForo tables from MyISAM to InnoDB:

    The following tables are not InnoDB: wp_wpforo_phrases, wp_wpforo_posts, wp_wpforo_topics. To fix, please see documentation: https://pantheon.io/docs/articles/sites/database/myisam-to-innodb/

    I can follow the guidance provided in the referenced documentation to convert the tables, but wanted to (a) alert you to this warning, (b) confirm with you whether doing this will result in any issues with future WPForo updates, and (c) see if this is something you might address in a plugin update instead of relying on users to perform this potentially dangerous modification.

    Thoughts?

    Donovan

    • This topic was modified 4 years, 3 months ago by heretiq.
Viewing 1 replies (of 1 total)
  • Plugin Support gVectors Support

    (@gvectorssupport)

    Hi @heretiq,

    Everything is correct you’ll need to use InnoDB instead of MyISAM. Please contact the hosting support and ask them to replace all InnoDB to MyISAM.

    Just make sure the MySQL version is higher than 5.6.

    confirm with you whether doing this will result in any issues with future WPForo updates,

    wpForo tries to create InnoDB database tables on installation, but sometimes it’s not allowed or the version of MySQL is lower than 5.6 and tables become MyISAM. So if you update the MySQL version you’ll not face the issue anymore.

Viewing 1 replies (of 1 total)
  • The topic ‘Warning to convert MySQL Tables From MyISAM to InnoDB’ is closed to new replies.

Tags