Çevrimdışı
ALTAY25
|
Tarih: 25-04-2016, Saat:00:32
|
|
(Son Düzenleme: 25-04-2016, Saat:00:40, Düzenleyen: ALTAY25.)
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 '%Þ%';
Çevrimdışı
GuvenKuran
|
Tarih: 27-11-2017, Saat:22:20
|
|
(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
|