Title: Update and error
Last modified: May 30, 2020

---

# Update and error

 *  Resolved [almendron](https://wordpress.org/support/users/almendron/)
 * (@almendron)
 * [6 years ago](https://wordpress.org/support/topic/update-and-error/)
 * 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 6 years ago by [almendron](https://wordpress.org/support/users/almendron/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Biplav](https://wordpress.org/support/users/bplv/)
 * (@bplv)
 * [6 years ago](https://wordpress.org/support/topic/update-and-error/#post-12916586)
 * Hello [@almendron](https://wordpress.org/support/users/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](https://wordpress.org/support/users/almendron/)
 * (@almendron)
 * [6 years ago](https://wordpress.org/support/topic/update-and-error/#post-12917073)
 * [@bplv](https://wordpress.org/support/users/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.

 * ![](https://ps.w.org/broken-link-checker/assets/icon-256x256.png?rev=2900468)
 * [Broken Link Checker](https://wordpress.org/plugins/broken-link-checker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/broken-link-checker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/broken-link-checker/)
 * [Active Topics](https://wordpress.org/support/plugin/broken-link-checker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/broken-link-checker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/broken-link-checker/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [almendron](https://wordpress.org/support/users/almendron/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/update-and-error/#post-12917073)
 * Status: resolved