Unknown storage engine ‘InnoDB’

  • Resolved edicolablack

    (@edicolablack)


    3 years, 3 months ago

    Hi,
    after updating your plugin to version 3.0.1, the following error report appeared in the Debug Events tab:

    `Debug Events are Not Installed Correctly

    The database table was not installed correctly. Please contact plugin support to diagnose and fix the issue. Provide them the error message below:

    Unknown storage engine ‘InnoDB’`

    Also, in the Site Health page the following “critical problem” warning shows up:

    WP Mail SMTP DB tables check has failed

    Missing table: avwp_wpmailsmtp_debug_events

    WP Mail SMTP is using custom database tables for some of its features. In order to work properly, the custom tables should be created, and it seems they are missing. Please try to re-install the WP Mail SMTP plugin. If this issue persists, please contact our support.

    I also tried to update to the newly released 3.0.2, but that didn’t fix the above problems.

    • This topic was modified 3 years, 3 months ago by edicolablack. Reason: Fixed some typos
    • This topic was modified 3 years, 3 months ago by edicolablack.

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Gregor Capuder

    (@capuderg)

    Hi @edicolablack,

    InnoDB is the default MySQL engine in the latest MySQL versions. Which version is your WP site using (you can check in the Site Health > Info tab > Database)?

    You can also contact your hosting company and ask them why the InnoDB is not available. They should be able to sort this out for you.

    Once they do, the DB table should create itself when you visit the WP dashboard.

    Take care!

    Thread Starter edicolablack

    (@edicolablack)

    Hi @capuderg,
    thank you for your fast reply.

    Checking Site Health > Info tab > Database, as you suggested, it reports that the Client version is

    mysqlnd 5.0.12-dev – 20150407 – $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

    , whilst the Server version is

    5.6.33-log

    .

    Did I report the right data? Is that the right version?

    Plugin Author Gregor Capuder

    (@capuderg)

    Hi @edicolablack,

    The MySQL 5.6 should have InnoDB engine available by default…

    I think you should contact your hosting company and they should be able to resolve this issue for you.

    Take care!

    Thread Starter edicolablack

    (@edicolablack)

    Hi @capuderg,
    did you implement the use of InnoDB only starting with the 3.0.1?

    Because before such release there was no warning about problems with the InnoDB; so, if the InnoDB was already used before, the problem shouldn’t be on the host side, unless they decided to “block” it coincidentaly at the same time I’ve updated the plugin.

    I’ll still try to report them such problems, but I still would like to make sure of when InnoDB use has been implemented in the plugin to better understand the origin of the problem.

    Plugin Author Gregor Capuder

    (@capuderg)

    Hi @edicolablack,

    this is the first custom DB table with InnoDB engine in the Lite version. However, we are using a couple of custom DB tables in our Pro version and we rarely see issues with it. They are usually WP sites with old MySQL versions with custom configs and the hosting can usually resolve them.

    Take care!

    Thread Starter edicolablack

    (@edicolablack)

    Hi @capuderg,
    Altervista, the host of my site, allow an easy creation of new sites, but quite limited to non-existent direct control of the database(except for the backup of it and a few other limited options), so I’ll need to report them the problem and hope they’ll be able to help me fix it.

    Plugin Author Gregor Capuder

    (@capuderg)

    Hi @edicolablack,

    any update from your hosting company?

    We haven’t heard from you in about a week, so I’m going to go ahead and mark this ticket resolved. If you still have questions, though, please feel welcome to continue the conversation.

    Thanks!

    Hi, for our client we installed your plugin and we get also the same error message. We use

    Server 5.6.45-86.1
    Client mysqlnd 7.4.13

    However, in their admin at the provider innodb is not being used, there is no table. The table being used is MySQL – MyISAM.

    Most likely both are activated but only MyISAM has active database and tables.

    So how to proceed?

    Thanks,
    Karel

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unknown storage engine ‘InnoDB’’ is closed to new replies.