Missing database tables error

  • Resolved mattpont

    (@mattpont)


    5 months, 3 weeks ago

    When installing the plugin on a site I’m getting the following error in the plugin dashboard:

    “Missing database tables: Some features may be disabled or not work as expected since one or more required tables are missing from the database.“

    Any ideas, I can’t find anything useful on Google? I’ve uninstalled and reinstalled a few times, and I get the same error each time.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support CookieYes Team

    (@cookieyesteam)

    Hi @mattpont

    Greetings from CookieYes!

    Please click the “Check again” button in this error notice and let us know the status.

    Thread Starter mattpont

    (@mattpont)

    The button changes to “Checking” with an Ajax loading icon for a second or two, and then the same message reappears.

    Plugin Support CookieYes Team

    (@cookieyesteam)

    Hi @mattpont

    Please check whether there is any conflict with the active theme or plugins on your site.
    Try the “Check again” option after switching to a default theme and deactivating all other plugins. You may try this on your staging site.

    Thread Starter mattpont

    (@mattpont)

    Hmm, I’ve deactivated all plugins with the exception of CookieYes, and also switched to the Twenty Twenty-Four theme, and I’m getting the same error.

    I’ll look at the database to see if I can see any issues, and it must be something to do with that. Do you have any other ideas that I could try?

    Plugin Support CookieYes Team

    (@cookieyesteam)

    Hi @mattpont

    We need your site health information to replicate this issue in our test environment. Please share it privately via this link.

    Thread Starter mattpont

    (@mattpont)

    Ah, fixed it. The wp-config.php had this line in it which was invalid:
    define( ‘DB_COLLATE’, ‘utf8’);

    I changed that to:
    define( ‘DB_COLLATE’, ”);

    and now WP can create tables without issue – thanks for your help, I’ve marked this as resolved.

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.