MyBB Depo Forum

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/

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 '%Þ%';

(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

ALTAY25

EmreKarakaya

GuvenKuran