Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

Pomoc przy konwersji phpBB 2.0.x lub innych skryptów do phpBB 3.0.x. Dyskusje na temat istniejących konwerterów oraz ich tworzenia.
Zablokowany
sylwekb
Posty: 8
Rejestracja: 08 listopada 2006, 12:23

Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

Post autor: sylwekb » 02 marca 2010, 10:00

Witam wszystkich

Po konwersji z phpbb2 do phpbb3 pojawiły się zamiast polskich znaków krzaczki, problem ten występuje zarówno w tytułach jak i treści postów np:

łączmy

chciałbym nadmienić że baza phpbb2 była kodowana w utf-8 i phpbb3 także po zainstalowaniu jest utf-8
jak można to poprawić?

Konwersja przebiegła prawidłowo tzn nie pojawił się żaden błąd.

Jak mogę poprawić te krzaczki aby polskie litery wyświetlały się prawidłowo?
Na górę
Awatar użytkownika
Widmo
Zasłużony
Posty: 695
Rejestracja: 22 maja 2005, 00:04
Lokalizacja: Sosnowiec
Kontakt:
Skontaktuj się z Widmo

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

Post autor: Widmo » 02 marca 2010, 20:42

Spróbuj użyć tego zapytania SQL:

Kod: Zaznacz cały

UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_last_post_subject` = REPLACE(`forum_last_post_subject`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_name` = REPLACE(`forum_name`, 'ñ', 'Ń');


UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_last_poster_name` = REPLACE(`topic_last_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_first_poster_name` = REPLACE(`topic_first_poster_name`, 'ñ', 'Ń');


UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '³', 'ł');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ăl̷', 'ó');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '±', 'ą');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¶', 'ś');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ê', 'ę');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¿', 'ż');
UPDATE `phpbb_users` SET `username_clean` = REPLACE(`username_clean`, '¼', 'ź');

UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '³', 'ł');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'Ăł', 'ó');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ê', 'ę');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¶', 'ś');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'æ', 'ć');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¿', 'Ż');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¼', 'ź');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '³', 'Ł');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¶', 'Ś');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'æ', 'Ć');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ê', 'Ę');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'Ó', 'Ó');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¿', 'ż');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '¼', 'Ź');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'Ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, '±', 'Ą');
UPDATE `phpbb_users` SET `username` = REPLACE(`username`, 'ñ', 'Ń');

UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '³', 'ł');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'Ăł', 'ó');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ê', 'ę');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¶', 'ś');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'æ', 'ć');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ñ', 'ń');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¿', 'Ż');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¼', 'ź');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '³', 'Ł');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¶', 'Ś');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'æ', 'Ć');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ê', 'Ę');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'Ó', 'Ó');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¿', 'ż');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '¼', 'Ź');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'Ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, '±', 'Ą');
UPDATE `phpbb_users` SET `user_interests` = REPLACE(`user_interests`, 'ñ', 'Ń');

UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '³', 'ł');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'Ăł', 'ó');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ê', 'ę');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¶', 'ś');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'æ', 'ć');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ñ', 'ń');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¿', 'Ż');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¼', 'ź');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '³', 'Ł');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¶', 'Ś');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'æ', 'Ć');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ê', 'Ę');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'Ó', 'Ó');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¿', 'ż');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '¼', 'Ź');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_text` = REPLACE(`message_text`, 'ñ', 'Ń');

UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '³', 'ł');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'Ăł', 'ó');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ê', 'ę');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¶', 'ś');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'æ', 'ć');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ñ', 'ń');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¿', 'Ż');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¼', 'ź');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '³', 'Ł');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¶', 'Ś');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'æ', 'Ć');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ê', 'Ę');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'Ó', 'Ó');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¿', 'ż');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '¼', 'Ź');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, '±', 'Ą');
UPDATE `phpbb_privmsgs` SET `message_subject` = REPLACE(`message_subject`, 'ñ', 'Ń');

UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '³', 'ł');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'Ăł', 'ó');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ê', 'ę');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¶', 'ś');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'æ', 'ć');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ñ', 'ń');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¿', 'Ż');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¼', 'ź');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '³', 'Ł');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¶', 'Ś');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'æ', 'Ć');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ê', 'Ę');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'Ó', 'Ó');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¿', 'ż');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_text` = REPLACE(`post_text`, 'ñ', 'Ń');


UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '±', 'Ą');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Âł', 'ł');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Ăł', 'ó');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ê', 'ę');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¶', 'ś');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '±', 'ą');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'æ', 'ć');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ñ', 'ń');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¿', 'Ż');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '³', 'Ł');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¶', 'Ś');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'æ', 'Ć');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ê', 'Ę');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'Ó', 'Ó');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¿', 'ż');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, '¼', 'Ź');
UPDATE `phpbb_posts` SET `post_subject` = REPLACE(`post_subject`, 'ñ', 'Ń');


UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ăł', 'ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'Ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '³', 'Ł');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¶', 'Ś');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'æ', 'Ć');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ê', 'Ę');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'Ó', 'Ó');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¿', 'ż');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '¼', 'Ź');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, 'ñ', 'Ń');
UPDATE `phpbb_forums` SET `forum_desc` = REPLACE(`forum_desc`, '±', 'Ą');

UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '³', 'ł');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'Ăł', 'ó');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ê', 'ę');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¶', 'ś');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'ą');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'æ', 'ć');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ñ', 'ń');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¿', 'Ż');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¼', 'ź');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '³', 'Ł');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¶', 'Ś');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'æ', 'Ć');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ê', 'Ę');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'Ó', 'Ó');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¿', 'ż');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '¼', 'Ź');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'Ą');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, 'ñ', 'Ń');
UPDATE `phpbb_topics` SET `topic_title` = REPLACE(`topic_title`, '±', 'Ą');

UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '³', 'ł');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'Ăł', 'ó');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ê', 'ę');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¶', 'ś');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'æ', 'ć');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ñ', 'ń');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¿', 'Ż');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¼', 'ź');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '³', 'Ł');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¶', 'Ś');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'æ', 'Ć');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ê', 'Ę');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'Ó', 'Ó');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¿', 'ż');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '¼', 'Ź');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'Ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, '±', 'Ą');
UPDATE `phpbb_poll_options` SET `poll_option_text` = REPLACE(`poll_option_text`, 'ñ', 'Ń');
Jeśli nie będzie działać to sam edytuj zapytanie:

Kod: Zaznacz cały

UPDATE `phpbb_forums` SET `forum_last_poster_name` = REPLACE(`forum_last_poster_name`, 'krzaczek', 'odpowiadająca_mu_polska_litera');
I tak z każdą literą. Pamiętaj, ze duże i małe również trzeba osobno wpisywać, bo mają one inne krzaczki.
Zapraszam na polskie forum ze zbiorami BBCode'ów - Kody, których nie znajdziesz nigdzie indziej!

Nie udzielam pomocy na PW, GG, mail. Wszelkie pytania proszę zadawać na forum.
Na górę
sylwekb
Posty: 8
Rejestracja: 08 listopada 2006, 12:23

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpbb3

Post autor: sylwekb » 02 marca 2010, 23:46

Wielkie dzięki wszystko działa, oczywiście z moim prefiksem i trochę innymi krzaczkami, bo te krzaczki są z iso a moje z utf-a
Na górę
neverdie
Posty: 4
Rejestracja: 14 maja 2010, 23:26

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: neverdie » 14 maja 2010, 23:28

Witam,

Mam podobny problem. Niestety nie mogę w ten sposób naprawić znaków, ponieważ w moim przypadku np. ą odpowiada za ń, ą i ę... W jaki sposób mogę przywrócić poprawne znaki?
Na górę
Awatar użytkownika
Widmo
Zasłużony
Posty: 695
Rejestracja: 22 maja 2005, 00:04
Lokalizacja: Sosnowiec
Kontakt:
Skontaktuj się z Widmo

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: Widmo » 15 maja 2010, 09:00

Przeczytaj jeszcze raz, ze zrozumieniem mój powyższy post i ułóż sobie zapytanie.
Zapraszam na polskie forum ze zbiorami BBCode'ów - Kody, których nie znajdziesz nigdzie indziej!

Nie udzielam pomocy na PW, GG, mail. Wszelkie pytania proszę zadawać na forum.
Na górę
neverdie
Posty: 4
Rejestracja: 14 maja 2010, 23:26

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: neverdie » 15 maja 2010, 10:49

Nie bardzo rozumiem? Z tego co widzę, w tamtym przypadku każdemu krzakowi odpowiadał dokładnie jeden znak polski. U mnie, czytając zakrzaczone posty, doszedłem do wniosku, że znak Ă przybiera postać zarówno Ą Ę jak i Ń. Naprawić mogę tylko kilka liter, które zakrzaczyły się np. do postaci Ăł.
Na górę
jaroslw
Zasłużony
Posty: 4524
Rejestracja: 10 grudnia 2005, 18:48
Kontakt:
Skontaktuj się z jaroslw

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: jaroslw » 15 maja 2010, 15:10

Zapewne bazę z phpBB2 masz w kodowaniu innym niż UTF–8. Wyeksportuj ją, zmień kodowanie w pliku SQL na UTF–8 bez BOM i wgraj ją ponownie, ale do bazy również o kodowaniu Unicode. Dalej powinno być już dobrze.
Pobierz styl: we_universal • we_clearblue
Nowości i aktualizacje: Facebook • Google+ • Twitter
Na górę
neverdie
Posty: 4
Rejestracja: 14 maja 2010, 23:26

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: neverdie » 15 maja 2010, 15:50

Problem w tym, że to już zrobiłem. Po przeniesieniu forum na nowy serwer, wystąpiły problemy z kodowaniem. Przerobiłem cała bazę na UTF8 (utf8_general_ci) i forum działało poprawnie. Niestety, po konwersji pojawia się ten problem.

Myślicie, że zrobienie konwersji offline może coś pomóc?
Na górę
jaroslw
Zasłużony
Posty: 4524
Rejestracja: 10 grudnia 2005, 18:48
Kontakt:
Skontaktuj się z jaroslw

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: jaroslw » 16 maja 2010, 10:36

Możesz spróbować. Praca z bazami danych to dość delikatna sprawa. Utwórz bazę o kodowaniu utf8_unicode_ci i zobacz co z tego wyjdzie :) Możesz też podać szczegóły na temat kodowań tabel przed i po konwersji.
Pobierz styl: we_universal • we_clearblue
Nowości i aktualizacje: Facebook • Google+ • Twitter
Na górę
neverdie
Posty: 4
Rejestracja: 14 maja 2010, 23:26

Re: Problem z polskimi znakami po konwersji z phpbb2 do phpb

Post autor: neverdie » 20 maja 2010, 16:03

Problem rozwiązałem. Najskuteczniejszym sposobem było zmienienie wszystkich polskich znaków w bazie przed konwersją na encje ;)
Na górę
Zablokowany

Wróć do „Konwersja”