Error when optimizing Database

  • Resolved captred

    (@captred)


    3 years, 5 months ago

    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 to see the link]

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

    (@steponme)

    3 years, 5 months ago

    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

    (@anghelemanuel99)

    3 years, 5 months ago

    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

    (@captred)

    3 years, 4 months ago

    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.