MyBB Depo Forum
[1.8] merge sonrası karakter hatası - Baskı Önizleme

+- MyBB Depo Forum (https://mybbdepo.com)
+-- Forum: MyBB 1.8 Depo (https://mybbdepo.com/mybb-1-8-depo-forumu)
+--- Forum: MyBB 1.8 Soru ve Sorunlarınız (https://mybbdepo.com/mybb-1-8-soru-ve-sorunlariniz-forumu)
+--- Konu Başlığı: [1.8] merge sonrası karakter hatası (/merge-sonrasi-karakter-hatasi-konusu.html)



merge sonrası karakter hatası - ALTAY25 - 25-04-2016

merge ile vbulletinden forumu mybb ye taşıdım aktarma esnasında herhengi bir sorun yaşanmadı fakat forumda bazı harflerde karakter hatası mevcut.Bu konuda yardımcı olacak arkadaşların yardımlarını bekliyorum..
Forum:http://altayforum.com/


Cvp: merge sonrası karakter hatası - EmreKarakaya - 25-04-2016

Merhaba

Merge öncesi tabloların tam olarak karakter setini ayarlayamamışsınız.Aşağıdaki kodları phpmyadminde çalıştırın hata düzelecektir.


Kod:
UPDATE mybb_users SET username = REPLACE( username, 'þ', 'ş' ) WHERE username LIKE '%þ%';
UPDATE mybb_users SET username = REPLACE( username, 'Ý', 'İ' ) WHERE username LIKE '%Ý%';
UPDATE mybb_users SET username = REPLACE( username, 'ð', 'ğ' ) WHERE username LIKE '%ð%';
UPDATE mybb_users SET username = REPLACE( username, 'Ð', 'Ğ' ) WHERE username LIKE '%Ð%';
UPDATE mybb_users SET username = REPLACE( username, 'Þ', 'Ş' ) WHERE username LIKE '%Þ%';
UPDATE mybb_forums SET name = REPLACE( name, 'þ', 'ş' ) WHERE name LIKE '%þ%';
UPDATE mybb_forums SET name = REPLACE( name, 'Ý', 'İ' ) WHERE name LIKE '%Ý%';
UPDATE mybb_forums SET name = REPLACE( name, 'ð', 'ğ' ) WHERE name LIKE '%ð%';
UPDATE mybb_forums SET name = REPLACE( name, 'Ð', 'Ğ' ) WHERE name LIKE '%Ð%';
UPDATE mybb_forums SET name = REPLACE( name, 'Þ', 'Ş' ) WHERE name LIKE '%Þ%';
UPDATE mybb_forums SET description = REPLACE( description, 'þ', 'ş' ) WHERE description LIKE '%þ%';
UPDATE mybb_forums SET description = REPLACE( description, 'Ý', 'İ' ) WHERE description LIKE '%Ý%';
UPDATE mybb_forums SET description = REPLACE( description, 'ð', 'ğ' ) WHERE description LIKE '%ð%';
UPDATE mybb_forums SET description = REPLACE( description, 'Ð', 'Ğ' ) WHERE description LIKE '%Ð%';
UPDATE mybb_forums SET description = REPLACE( description, 'Þ', 'Ş' ) WHERE description LIKE '%Þ%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'þ', 'ş' ) WHERE subject LIKE '%þ%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Ý', 'İ' ) WHERE subject LIKE '%Ý%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'ð', 'ğ' ) WHERE subject LIKE '%ð%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Ð', 'Ğ' ) WHERE subject LIKE '%Ð%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Þ', 'Ş' ) WHERE subject LIKE '%Þ%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'þ', 'ş' ) WHERE subject LIKE '%þ%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Ý', 'İ' ) WHERE subject LIKE '%Ý%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'ð', 'ğ' ) WHERE subject LIKE '%ð%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Ð', 'Ğ' ) WHERE subject LIKE '%Ð%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Þ', 'Ş' ) WHERE subject LIKE '%Þ%';
UPDATE mybb_posts SET message = REPLACE( message, 'þ', 'ş' ) WHERE message LIKE '%þ%';
UPDATE mybb_posts SET message = REPLACE( message, 'Ý', 'İ' ) WHERE message LIKE '%Ý%';
UPDATE mybb_posts SET message = REPLACE( message, 'ð', 'ğ' ) WHERE message LIKE '%ð%';
UPDATE mybb_posts SET message = REPLACE( message, 'Ð', 'Ğ' ) WHERE message LIKE '%Ð%';
UPDATE mybb_posts SET message = REPLACE( message, 'Þ', 'Ş' ) WHERE message LIKE '%Þ%';



Cvp: merge sonrası karakter hatası - GuvenKuran - 27-11-2017

(25-04-2016, Saat:03:56)EmreKarakaya Adlı Kullanıcıdan Alıntı: Merhaba

Merge öncesi tabloların tam olarak karakter setini ayarlayamamışsınız.Aşağıdaki kodları phpmyadminde çalıştırın hata düzelecektir.


Kod:
UPDATE mybb_users SET username = REPLACE( username, 'þ', 'ş' ) WHERE username LIKE '%þ%';
UPDATE mybb_users SET username = REPLACE( username, 'Ý', 'İ' ) WHERE username LIKE '%Ý%';
UPDATE mybb_users SET username = REPLACE( username, 'ð', 'ğ' ) WHERE username LIKE '%ð%';
UPDATE mybb_users SET username = REPLACE( username, 'Ð', 'Ğ' ) WHERE username LIKE '%Ð%';
UPDATE mybb_users SET username = REPLACE( username, 'Þ', 'Ş' ) WHERE username LIKE '%Þ%';
UPDATE mybb_forums SET name = REPLACE( name, 'þ', 'ş' ) WHERE name LIKE '%þ%';
UPDATE mybb_forums SET name = REPLACE( name, 'Ý', 'İ' ) WHERE name LIKE '%Ý%';
UPDATE mybb_forums SET name = REPLACE( name, 'ð', 'ğ' ) WHERE name LIKE '%ð%';
UPDATE mybb_forums SET name = REPLACE( name, 'Ð', 'Ğ' ) WHERE name LIKE '%Ð%';
UPDATE mybb_forums SET name = REPLACE( name, 'Þ', 'Ş' ) WHERE name LIKE '%Þ%';
UPDATE mybb_forums SET description = REPLACE( description, 'þ', 'ş' ) WHERE description LIKE '%þ%';
UPDATE mybb_forums SET description = REPLACE( description, 'Ý', 'İ' ) WHERE description LIKE '%Ý%';
UPDATE mybb_forums SET description = REPLACE( description, 'ð', 'ğ' ) WHERE description LIKE '%ð%';
UPDATE mybb_forums SET description = REPLACE( description, 'Ð', 'Ğ' ) WHERE description LIKE '%Ð%';
UPDATE mybb_forums SET description = REPLACE( description, 'Þ', 'Ş' ) WHERE description LIKE '%Þ%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'þ', 'ş' ) WHERE subject LIKE '%þ%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Ý', 'İ' ) WHERE subject LIKE '%Ý%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'ð', 'ğ' ) WHERE subject LIKE '%ð%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Ð', 'Ğ' ) WHERE subject LIKE '%Ð%';
UPDATE mybb_threads SET subject = REPLACE( subject, 'Þ', 'Ş' ) WHERE subject LIKE '%Þ%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'þ', 'ş' ) WHERE subject LIKE '%þ%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Ý', 'İ' ) WHERE subject LIKE '%Ý%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'ð', 'ğ' ) WHERE subject LIKE '%ð%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Ð', 'Ğ' ) WHERE subject LIKE '%Ð%';
UPDATE mybb_posts SET subject = REPLACE( subject, 'Þ', 'Ş' ) WHERE subject LIKE '%Þ%';
UPDATE mybb_posts SET message = REPLACE( message, 'þ', 'ş' ) WHERE message LIKE '%þ%';
UPDATE mybb_posts SET message = REPLACE( message, 'Ý', 'İ' ) WHERE message LIKE '%Ý%';
UPDATE mybb_posts SET message = REPLACE( message, 'ð', 'ğ' ) WHERE message LIKE '%ð%';
UPDATE mybb_posts SET message = REPLACE( message, 'Ð', 'Ğ' ) WHERE message LIKE '%Ð%';
UPDATE mybb_posts SET message = REPLACE( message, 'Þ', 'Ş' ) WHERE message LIKE '%Þ%';

ben çalıştırdım hala bozuk karakter seti