WordPress PhpMyAdmin Collations Sorunu [Çözümü]

Blogolik Yazar tarafından 7 Şubat 2016 tarihinde yazılmıştır.

WordPress PhpMyAdmin Collations Sorunu [Çözümü]
Bazı merak eden arkadaşlar ve bu sorunu yaşayan kişiler için WordPress PhpMyAdmin Collations Sorunu ve çözümüne yer verdik. Kendi bilgisayarınızda hazırladığınız wordpress projenizi sunucuya taşıdınız ve ön izleme yaptığınızda collactions hataları mı alıyorsunuz? O zaman bu yazımızı dikkatlice okuyun.

Bu sorunu çözmek için WordPress tablolarındaki bütün dosyaları collate’ini utf8_general_ci yapmamız gerekecektir. Bunu da yapabilmek için WordPress’inizdeki bütün tablolar için aşağıdaki SQL sorgusunu çalıştırmanız gerekmektedir (Benim karşılaştığım projede toplam 35 tablo olduğundan 35 tabloda da çalıştırmam gerekti).

NOT: PhpMyAdmin üzerinden el ile collaction’ları güncelleseniz bile çalışmayacaktır. Bunun için sorguyla yapmanız gerekecektir.

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;
1 sene önce yazılmıştır.
EtiCanlar:
"WordPress PhpMyAdmin Collations Sorunu [Çözümü]" bu yazı 7 Şubat 2016 tarihinde saat 22:05 sularında "Wordpress" kategorisinde yayınlanmış olup "Blogolik Yazar" tarafından yazıldığı sanılmaktadır..Ve sayaçların yaptığı açıklamaya göre 47 kere okunduğu söylenmektedir..Ayrıca Henüz yorum yazılmamış bir konudur
  • FriendFeed'de Paylaş
  • Facebook'ta Paylaş
  • Twitter'da Paylaş
  • Bu Yazı Hakkında Birşeyler Demek İstermisiniz?





    Her Hakkım Saklıdır®™ Ben Bile Bulamadım :)
    eskisehir escort izmit escort samsun escort bursa escort bursa escort konya escort adana escort gaziantep escort kayseri escort izmir escort hatay escort