Update and error

  • Resolved almendron

    (@almendron)


    4 years ago

    After updating to version 1.11.13: error message in admin

    Error en la base de datos de WordPress: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
UPDATE wp_blc_synch AS synch JOIN wp_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) SET synched = 0 WHERE synch.last_synch < posts.post_modified

Error en la base de datos de WordPress: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
INSERT INTO wp_blc_synch(container_id, container_type, synched) SELECT posts.id, posts.post_type, 0 FROM wp_posts AS posts LEFT JOIN wp_blc_synch AS synch ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) WHERE posts.post_status IN ('publish') AND posts.post_type IN ('post', 'page') AND synch.container_id IS NULL
    • This topic was modified 4 years ago by almendron.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Biplav

    (@bplv)

    4 years ago

    Hello @almendron ,
    Thank you for reporting this, we’ve seen this issue with GoDaddy hosting where WordPress installations there have mixed collations of database. They don’t respect the default collations and use their own set collations while creating default tables ( in this case utf8mb4_unicode_ci ) and when creating the custom tables they use WP’s collation ( in this case utf8mb4_unicode_520_ci ) which is causing this error.
    We have tried to fix this from the plugin but unfortunately we couldn’t.
    Furthermore, this may also be causing errors with other plugins that rely on the post table or make changes to it.
    You’ll probably have to check in with your hosting about this and see if they could use the standard charset for this?

    Best regards,
    Biplav.

    Thread Starter almendron

    (@almendron)

    4 years ago

    @bplv, thank you very much for the information you have given me.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Update and error’ is closed to new replies.