“unable to create db tables” but db has permission and set to utf8 charset

  • Resolved vincentejc

    (@vincentejc)


    4 years, 10 months ago

    Hi this is new Topic but relates to an older issue,

    Yoast Message on WüP Dashboard:
    “Yoast SEO was unable to create the database tables required and as such will not function correctly. Please read this help article to find out how to resolve this problem.”

    I verified the db charset is utf8 and have tried using the Helper Tool as below, I don’t find a button to press on step iv below:

    “Once you verify you have a valid charset, if you use the Yoast Helper Tool does the issue resolve? Please try the steps below:
    – i. Install & activate the Yoast Test Helper plugin: https://www.ads-software.com/plugins/yoast-test-helper/
    – ii. Go to Tools -> Yoast Test
    – iii. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button
    – iv. Click the “Click here to speed up your site now” button in the SEO->Tools section.”

    Best regards

    Vincent Bevan

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support marcanor

    (@marcanor)

    Hi @vincentejc ,

    We’re sorry to hear that you are having issues with the 14.0 update. We apologize for any issues that this might be causing on your site.

    Can you please check the following?:
    1) Can you please make sure that your database user has the proper permissions? Yoast SEO requires the following permissions: ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, UPDATE and DROP.

    2)Can you please check your wp-config.php file and let us know what the DB_CHARSET and DB_COLLATE settings are?

    3) Can you please check your database and verify if the following tables were in fact created? : _yoast_indexable, _yoast_indexable_hierarchy, _yoast_migrations, _yoast_primary_term

    Please let us know if you have any further information.

    Thread Starter vincentejc

    (@vincentejc)

    Hi thanks for the feedback,

    answers below:

    1. DB User has all the required permissions excluding CREATE.
    2. define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);
    3. All tables exist.

    I added the CREATE permission and voila it worked. Also the update to 14.1 added the prompt to speed up the database which also worked fine.

    Many thanks for your support!

    Thread Starter vincentejc

    (@vincentejc)

    This topic is solved!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘“unable to create db tables” but db has permission and set to utf8 charset’ is closed to new replies.

Tags