Update 14.1 – Error alter table

  • Resolved mychy

    (@mychy)


    4 years, 10 months ago

    After 14.1 update, Yoast throws an error as it was a:

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

    thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support devnihil

    (@devnihil)

    @mychy We’re sorry you’re experiencing an error when updating the plugin to the 14.1 version.

    Can you please check your wp-config.php file to see whether you have the DB_COLLATION constant set, and also what the Database Charset is set to in wp-config.php?

    Also, would you be able to provide us with your site’s error log for this?

    Thread Starter mychy

    (@mychy)

    @devnihil thanks

    Can you please check your wp-config.php file to see whether you have the DB_COLLATION constant set, and also what the Database Charset is set to in wp-config.php?

    define('DB_CHARSET', 'utf8mb4_unicode_ci')
define('DB_COLLATE', '');

    Also, would you be able to provide us with your site’s error log for this?

    I’m sorry I don’t know how

    Hi @mychy,

    Thank you for your reply.

    The CHARSET being utf8mb4_unicode_ci is incorrect, as that is a collation and not a CHARSET. Can you change the CHARSET to be utf8mb4 instead of utf8mb4_unicode_ci and see if that helps?

    • This reply was modified 4 years, 10 months ago by Jeroen Rotty.
    Thread Starter mychy

    (@mychy)

    GREAT @jeroenrotty

    thank you for solution

    @jeroenrotty Wow! Thank you. Worked.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Update 14.1 – Error alter table’ is closed to new replies.