Getting SQL COLLATION error

  • Resolved Marco Almeida | Webdados

    (@webdados)


    4 years ago

    I’m getting this error while updating the TranslatePress database after last update:

    [18-Nov-2020 10:00:19 UTC] Erro na base de dados do WordPress COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'latin1' na query UPDATE wp_trp_dictionary_pt_pt_en_gb, wp_trp_original_strings SET wp_trp_dictionary_pt_pt_en_gb.original_id = wp_trp_original_strings.id WHERE wp_trp_dictionary_pt_pt_en_gb.original COLLATE utf8mb4_bin = wp_trp_original_strings.original AND wp_trp_dictionary_pt_pt_en_gb.id > 0 AND wp_trp_dictionary_pt_pt_en_gb.id <= 5000 feita por do_action('wp_ajax_trp_update_database'), WP_Hook->do_action, WP_Hook->apply_filters, TRP_Upgrade->trp_update_database, TRP_Upgrade->trp_updated_database_original_id_update_166, TRP_Query->original_ids_reindex

    Any idea of what’s going on here?

Viewing 1 replies (of 1 total)
  • Plugin Author Razvan Mocanu

    (@razvanmo-1)

    Hi,

    We use wpdb->get_charset_collate() function to determine the collation of the database. In your case there is a mismatch. Judging by the error you received, the expected return is latin1, but instead it returns something else.

    Try checking and changing DB_COLLATE to latin1 in wp-config.php. Same with DB_CHARSET if already set.

    Before taking any actions I recommend backing up database and files to safely restore in case something goes wrong.

Viewing 1 replies (of 1 total)
  • The topic ‘Getting SQL COLLATION error’ is closed to new replies.