Database problem

  • Resolved qlm95

    (@qlm95)


    4 years, 10 months ago

    Yoast SEO had problems creating the database tables needed to speed up my site.

    Debug information :
    AddCollationToTables – Error executing ‘query’ with: ALTER TABLE wpca_yoast_migrations CONVERT TO CHARACTER SET utf8mb4_unicode_ci Reason: Unknown character set: ‘utf8mb4_unicode_ci’

    Here is the feedback of my host :
    The utf8mb4_unicode_ci collation is unavailable on the SQL server, you must use utf8mb4_general_ci

    What to do now ?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @qlm95,

    Thanks for reaching out.

    Yoast SEO was unable to create the new tables because you haven’t defined a CHARSET in your wp-config.php file. Please, refer to this report for more information.

    You may try the following steps:

    • Edit your wp-config.php file using the File Manager plugin and to add the following line: define(‘DB_CHARSET’, ‘utf8’); See this screenshot for reference
    • Deactivate Yoast SEO
    • Go to Tools > Yoast Test and click on the “Reset indexables tables and migrations” button
    • Activate Yoast SEO v14.1
    • Go to SEO > Tools and notice that the “Yoast SEO was unable to create the database tables” warning doesn’t appear anymore. Instead, there’s a button to “Start processing and speed up your site now”

      • You may try the aforementioned steps on your live site. Please, before doing so, for the health and safety of your site, we recommend creating a backup of your site and database. Learn more about the benefits of regular backups.

      It’d also be advisable to get confirmation from your hosting provider that this process won’t cause any damage or downtime to your website.

      Many thanks.

    Thread Starter qlm95

    (@qlm95)

    Hello @maybellynen, thank you for the tip.
    I can’t find the Tools > Yoast Test
    Where is that ? When I deactivate and activate again Yoast SEO without doing that step it still shows the error.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    You’ll need to install and activate the Yoast Test Helper plugin to find the Tools → Yoast Test option to reset the indexables tables and migrations.

    Hi @qlm95 ,

    We’re closing this thread because we haven’t heard back from you in a while. Should you have further questions, please open a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database problem’ is closed to new replies.