wordpress_phpmyadmin_collations_problem.sql

Problem;

WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id AND icl_t.element_type = CONCAT('tax_', tt.taxonomy) WHERE tt.taxonomy IN ('portfolio-category') AND ( ( icl_t.element_type IN ('tax_portfolio-category') AND icl_t.language_code = 'tr' ) OR icl_t.element_type NOT IN ('tax_portfolio-category') OR icl_t.element_type IS NULL ) ORDER BY t.term_order ASC
WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id AND icl_t.element_type = CONCAT('tax_', tt.taxonomy) WHERE tt.taxonomy IN ('category') AND ( ( icl_t.element_type IN ('tax_category') AND icl_t.language_code = 'tr' ) OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) ORDER BY t.term_order ASC
WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('hakkimizda') AND post_type IN ('page','attachment') AND ( post_type NOT IN ('post','page','portfolio') OR ID = (SELECT element_id FROM wp_icl_translations WHERE element_id = ID AND element_type = CONCAT('post_', post_type) AND language_code = 'tr' LIMIT 1))

// The query add the WordPress all table name
alter table table_name convert to character set utf8 collate utf8_general_ci;

// Example;
alter table wp_commentmeta convert to character set utf8 collate utf8_general_ci;
alter table wp_comments convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_content_status convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_core_status convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_flags convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_languages convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_languages_translations convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_locale_map convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_message_status convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_node convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_reminders convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_strings convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_string_positions convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_string_status convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_string_translations convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_translate convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_translate_job convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_translations convert to character set utf8 collate utf8_general_ci;
alter table wp_icl_translation_status convert to character set utf8 collate utf8_general_ci;
alter table wp_layerslider convert to character set utf8 collate utf8_general_ci;
alter table wp_links convert to character set utf8 collate utf8_general_ci;
alter table wp_options convert to character set utf8 collate utf8_general_ci;
alter table wp_postmeta convert to character set utf8 collate utf8_general_ci;
alter table wp_posts convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_css convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_layer_animations convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_settings convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_sliders convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_slides convert to character set utf8 collate utf8_general_ci;
alter table wp_revslider_static_slides convert to character set utf8 collate utf8_general_ci;
alter table wp_terms convert to character set utf8 collate utf8_general_ci;
alter table wp_term_relationships convert to character set utf8 collate utf8_general_ci;
alter table wp_term_taxonomy convert to character set utf8 collate utf8_general_ci;
alter table wp_usermeta convert to character set utf8 collate utf8_general_ci;
alter table wp_users convert to character set utf8 collate utf8_general_ci;

//Default WP Talbes

alter table wp_comments convert to character set utf8 collate utf8_general_ci;
alter table wp_links convert to character set utf8 collate utf8_general_ci;
alter table wp_options convert to character set utf8 collate utf8_general_ci;
alter table wp_postmeta convert to character set utf8 collate utf8_general_ci;
alter table wp_posts convert to character set utf8 collate utf8_general_ci;
alter table wp_terms convert to character set utf8 collate utf8_general_ci;
alter table wp_term_relationships convert to character set utf8 collate utf8_general_ci;
alter table wp_term_taxonomy convert to character set utf8 collate utf8_general_ci;
alter table wp_usermeta convert to character set utf8 collate utf8_general_ci;
alter table wp_users convert to character set utf8 collate utf8_general_ci;