Title: Error when optimizing Database
Last modified: December 26, 2022

---

# Error when optimizing Database

 *  Resolved [captred](https://wordpress.org/support/users/captred/)
 * (@captred)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/error-when-optimizing-database/)
 * **WordPress database error:** [Illegal mix of collations (utf8mb4_unicode_520_ci,
   IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’]
   `INSERT INTO ``
   wp_trp_original_strings` (original) SELECT DISTINCT ( BINARY t1.original ) FROM`
   wp_trp_dictionary_en_us_ko_kr` t1 LEFT JOIN `wp_trp_original_strings` t2 ON (
   t2.original = t1.original AND t2.original = BINARY t1.original ) WHERE t2.original
   IS NULL AND t1.id > 0 AND t1.id <= 1000 AND LENGTH(t1.original) < 20000{“action”:”
   trp_update_database”,”trp_updb_action”:””,”trp_updb_lang”:””,”trp_updb_batch”:
   0,”trp_updb_nonce”:”74d4043453″,”trp_update_completed”:”no”,”progress_message”:”
   done.<\/br>”}
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ferror-when-optimizing-database%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [steponme](https://wordpress.org/support/users/steponme/)
 * (@steponme)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/error-when-optimizing-database/#post-16323012)
 * Same exact error here. This led me to huge problems in translations, even in “
   standard” language, and right now i have no choice but to deactivate the plugin.
   
   Hello team?
 *  Plugin Support [Anghel Emanuel](https://wordpress.org/support/users/anghelemanuel99/)
 * (@anghelemanuel99)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/error-when-optimizing-database/#post-16327548)
 * Hello there,
 * Thank you for letting us know about this!
 * Does this problem happen if you deactivate all the plugins and let TranslatePress
   be enabled and run the optimization tool?
 * Can you explain to me the problem with more details and what I need to do to 
   replicate it?
 * Thank you for this!
 * Kind Regards,
 *  Thread Starter [captred](https://wordpress.org/support/users/captred/)
 * (@captred)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/error-when-optimizing-database/#post-16353957)
 * Actually no, this happens when I optimize my database. like removing all duplicate
   translations and the like.

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

The topic ‘Error when optimizing Database’ is closed to new replies.

 * ![](https://ps.w.org/translatepress-multilingual/assets/icon.svg?rev=3166541)
 * [TranslatePress - Translate Multilingual sites with AI Translation](https://wordpress.org/plugins/translatepress-multilingual/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/translatepress-multilingual/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/translatepress-multilingual/)
 * [Active Topics](https://wordpress.org/support/plugin/translatepress-multilingual/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/translatepress-multilingual/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [captred](https://wordpress.org/support/users/captred/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/error-when-optimizing-database/#post-16353957)
 * Status: resolved