[FAQ] Как сконвертировать phpBB 2 в phpBB 3

dmsuslov · Сообщение **dmsuslov** » 10.07.2007 22:37

Кто-нибудь конвертировал сабж? У меня возникла проблема: получилось почти все, кроме кодировки символов

Старый форум (phpBB2) был в кодировке windows-1251, а новый в utf-8. Весь контент переносится в виде каких-то кракозябров...
Окунувшись в документацию, вычитал, что нужно поправить файл lang_main.php в старом форуме, а именно $lang['ENCODING']. Но изменения в нем влияют лишь на внешний вид кракозябров. Нормального текста контента добиться не удалось.

P.S.
phpBB2 2.0.20
phpBB3 3.0 RC3

С чего начать?
Начните с "чистой" установки phpBB3 в отличный от phpBB2 каталог. Затем снова перейдите в баузере в каталог install и щёлкните по вкладке "Конвертирование".
Где почитать документацию по конвертированию на русском языке?
http://www.vvvas.ru/it/phpbb/3.0/docs/I ... ml#convert
Изменяются ли в процессе конвертации содержимое и файлы phpBB2?
В процессе конвертации не подвергаются изменениям ни таблицы phpBB2 в базе данных, ни исходные файлы phpBB2.
Старый форум находится по адресу: forum2.domen.ru, а новый по адресу: forum.domen.ru. При этом старый лежит в папке:
/home/b/boshnet/forum2/public_html/ а новый в папке: /home/b/boshnet/forum/public_html/
Какой относительный путь указать при конвертации?
../../forum2/public_html/
Сохранятся ли моды, которые были установлены в phpBB2, после конвертации в phpBB3?
Будут сконвертированы только моды:
- File Attachment Mod by Acyd Burn
- Birthday by Niels
- Birthdays by TerraFrost
Почему после конвертации в phpBB3 в сообщениях вместо русских букв - кракозябры?
Вариант: кракозябры не везде, а только в сообщениях некоторых пользователей.
Для корректного конвертирования необходимо, чтобы кодировка таблиц phpBB2 в базе данных соответствовала значению переменной $lang['ENCODING'] в файле language/lang_russian/lang_main.php. Варианты решения:
1) Сложный. Переконвертировать содержимое базы данных в кодировку, указанную в переменной $lang['ENCODING'].
2) Простой. Назначить переменной $lang['ENCODING'] значение, совпадающее с текущей кодировкой базы данных. При этом сообщения и другой контент на "старом" форуме могут стать нечитабельными, тем не менее, после конвертации читабельность восстановится.
3) Альтернативный: http://www.phpbbguru.net/community/topi ... ml#p245047

Перед конвертацией также рекомендуется проверить, какой язык по умолчанию установлен у всех пользователей, и изменить на русский, если это необходимо.

17.05.2011 15:15

Гостья писал(а):перегнала phpbb2 в smf utf8

Что вас заставило идти обходными путями?
Почему не стали конвертировать сразу в phpBB3?

Гостья · Сообщение **Гостья** » 17.05.2011 20:14

владимир1983 , ну не получается же сразу с phpbb2 на phpbb3 , а помочь бедной девушке никто не хочет... :(

Сообщение **Mr. Anderson** » 17.05.2011 20:17

Гостья писал(а):ну не получается же сразу с phpbb2 на phpbb3

Почему не получается?

Сообщение **Sheer** » 17.05.2011 21:45

А на локальном компьютере попробовать?

Добавлено спустя 7 минут 12 секунд:
А это правда, что база всего 190 kB? Пришлите дамп мне в ЛС.

Dangerous13 · Сообщение **Dangerous13** » 17.05.2011 22:15

Гостья писал(а):владимир1983 , ну не получается же сразу с phpbb2 на phpbb3 , а помочь бедной девушке никто не хочет... :(

Пытаемся) Если не страшно то правдо, скиньте дамп базы мне или товарищу Sheer. Переконвертим вам Базу в нужную кодировку.

Dangerous13 · Сообщение **Dangerous13** » 18.05.2011 8:48

Как вариант:

dmsuslov писал(а): Варианты решения:
1) Сложный. Переконвертировать содержимое базы данных в кодировку, указанную в переменной $lang['ENCODING'].

Воспользоваться перловым скриптом, надыбал его в инете для таких же нужд но конвертил из latin1.
Данный скрипт создаёт файлик с SQL запросами типа ALTER TABLE и ALTER DATABASES для смены кодировки всех полей, всех найденных таблиц, который потом заливаем на сервер.
Вот, отредактировал его для ваших целей. Код сохраняем в файлик и выполняем с помощью утилиты perl (ЗЫ: испытано в linux`e, с виндой не шипко дружу).

Код: Выделить всё

#!/usr/bin/perl
use warnings;
use strict;
use DBI;
unless( 4 == @ARGV ) {
    print STDERR "Usage: $0 <host> <database> <user> <password>\n";
    exit 1;
}
my ($host, $database, $user, $password) = @ARGV;
die "bad host/db/user" unless $host =~ /^[\w\-\.]+$/ and $database =~ /^[\w_]+$/ and $user =~ /^[\w_]+$/;
my $dbh = DBI->connect("DBI:mysql:database=$database;host=$host", $user, $password, {'RaiseError' => 1});
my (@pass0, @pass1, @pass2, @pass3) = ();
my $sth = $dbh->prepare("SHOW CREATE DATABASE $database");
$sth->execute;
my @arr = $sth->fetchrow_array;
$arr[1] =~ /^CREATE DATABASE `$database` \/\*!\d+ DEFAULT CHARACTER SET cp1251( COLLATE cp1251_\w+)? \*\/$/
    or die "bad database spec: $arr[1]";
push @pass1, "ALTER DATABASE `$database` DEFAULT CHARACTER SET cp1251";
push @pass2, "ALTER DATABASE `$database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";

$sth = $dbh->prepare("SHOW TABLES");
$sth->execute;
my @tables = ();
while( my @row = $sth->fetchrow_array ) {
    die "bad table name: $row[0]" unless $row[0] =~ /^[\w_]+$/;
    push @tables, $row[0];
}

foreach my $table (@tables) {
    $sth = $dbh->prepare("SHOW CREATE TABLE `$table`");
    $sth->execute;
    my @row = $sth->fetchrow_array;
    $row[1] =~ s/ COMMENT='[^'\\]*'$//s;
    $row[1] =~ /^CREATE TABLE `$table` \(.*\)([^)]+)$/s
        or die "bad table spec: $row[1]";
    my $tail = $1;
    unless( $tail =~ /\bDEFAULT CHARSET=cp1251\b/ ) {
        die "bad table $table spec tail: $tail";
    }
    push @pass1, "ALTER TABLE `$table` DEFAULT CHARSET cp1251";
    push @pass2, "ALTER TABLE `$table` DEFAULT CHARSET utf8 COLLATE utf8_general_ci";
    my (%fulltext, %column_in_fulltext_indexes, %remove_fulltext_indexes) = ();
    $sth = $dbh->prepare("SHOW INDEX FROM `$table`");
    $sth->execute;
    while( my $row = $sth->fetchrow_hashref ) {
        next unless $row->{Index_type} eq "FULLTEXT";
        $fulltext{$row->{Key_name}} ||= [];
        $fulltext{$row->{Key_name}}[$row->{Seq_in_index}-1] = $row->{Column_name};
        $column_in_fulltext_indexes{$row->{Column_name}} ||= [];
        push @{$column_in_fulltext_indexes{$row->{Column_name}}}, $row->{Key_name};
    }
    $sth = $dbh->prepare("SHOW FULL COLUMNS FROM `$table`");
    $sth->execute;
    while( my @row = $sth->fetchrow_array ) {
        my ($column, $type, $collation) = @row[0,1,2];
        if( defined $collation and "NULL" ne $collation ) {
            die "bad collation in column $column of table $table: $collation" unless $collation =~ /^cp1251_\w+$/;
            push @pass1, "ALTER TABLE `$table` MODIFY COLUMN `$column` $type CHARACTER SET cp1251";
            push @pass2, "ALTER TABLE `$table` MODIFY COLUMN `$column` $type CHARACTER SET  utf8 COLLATE utf8_general_ci";
            foreach my $index (@{$column_in_fulltext_indexes{$column}}) {
                $remove_fulltext_indexes{$index} = 1;
            }
        }
    }
    foreach my $index (keys %remove_fulltext_indexes) {
        push @pass0, "ALTER TABLE `$table` DROP INDEX `$index`";
        push @pass3, "ALTER TABLE `$table` ADD FULLTEXT INDEX `$index` (" . join( ",", map { "`$_`" } @{$fulltext{$index}} ) . ")";
    }
}

print join ";\n", "USE `$database`", @pass0, @pass1, @pass2, @pass3, "";

Ну или попробуйте воспользоваться уже готовым вариантом:

Код: Выделить всё

ALTER DATABASE `forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_auth_access` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_email` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` MODIFY COLUMN `cat_title` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_name` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_value` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `confirm_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `code` char(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` MODIFY COLUMN `disallow_username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forum_prune` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_name` varchar(150) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_desc` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_name` varchar(40) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_description` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `poster_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `post_username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_subject` char(60) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_subject` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_title` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_image` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `search_array` mediumtext CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` MODIFY COLUMN `word_text` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordmatch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `key_id` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `last_ip` varchar(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `code` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `smile_url` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `emoticon` varchar(75) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `template_name` varchar(30) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `style_name` varchar(30) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `head_stylesheet` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_background` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_bgcolor` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_text` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_link` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_vlink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_alink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_hlink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface1` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface2` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface3` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` MODIFY COLUMN `topic_title` char(60) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics_watch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_user_group` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_password` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_lang` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_dateformat` varchar(14) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_avatar` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_email` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_icq` varchar(15) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_website` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_from` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig_bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_aim` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_yim` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_msnm` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_occ` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_interests` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_actkey` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_newpasswd` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `salt` varchar(5) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` MODIFY COLUMN `vote_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` MODIFY COLUMN `vote_option_text` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` MODIFY COLUMN `vote_user_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `word` char(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `replacement` char(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;

PS: Не забываем делать Резервную копию базы, перед тем как что-то в ней менять!!!!!!!!

VVVas · Сообщение **VVVas** » 18.05.2011 10:48

Если не ошибаюсь, то в тройке можно переиндексировать поисковую базу (http://www.phpbbguru.net/documentation/ ... intenance/), так что может не стоить тащить с собой поисковую базу. Если не прав, пусть старшие товарищи меня поправят.

Гостья · Сообщение **Гостья** » 26.05.2011 9:18

бьюсь как головой об стену... после конвертации некоторые посты в кракозябрах. в основном пользовательские, админские нормально показываются.как же все-таки правильно перегнать 2 в 3 ??? перечитала 70 страниц - толку от них мало. обновиться все-равно не получается. дамп дать не могу, извините, там очень "интимная" информация организации. не хочется терять постя и заставлять пользователей региться понову. ребят, дайте нормальную инструкцию, плиз!!!

Добавлено спустя 29 минут 39 секунд:
может вообще не стоит паритсья на тему тройки... двойка работает и ладно

Dangerous13 · Сообщение **Dangerous13** » 26.05.2011 11:23

Не пробовали мой вариант конвертации? т.е. Базу двойки в UTF8 переконвертить с помощью SQL-запросов:

Код: Выделить всё

ALTER DATABASE `forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_auth_access` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_banlist` MODIFY COLUMN `ban_email` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_categories` MODIFY COLUMN `cat_title` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_name` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_config` MODIFY COLUMN `config_value` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `confirm_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_confirm` MODIFY COLUMN `code` char(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_disallow` MODIFY COLUMN `disallow_username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forum_prune` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_name` varchar(150) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_forums` MODIFY COLUMN `forum_desc` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_name` varchar(40) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_groups` MODIFY COLUMN `group_description` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `poster_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts` MODIFY COLUMN `post_username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_subject` char(60) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_posts_text` MODIFY COLUMN `post_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_subject` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs` MODIFY COLUMN `privmsgs_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_privmsgs_text` MODIFY COLUMN `privmsgs_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_title` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_ranks` MODIFY COLUMN `rank_image` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_results` MODIFY COLUMN `search_array` mediumtext CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordlist` MODIFY COLUMN `word_text` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_search_wordmatch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_id` char(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions` MODIFY COLUMN `session_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `key_id` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_sessions_keys` MODIFY COLUMN `last_ip` varchar(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `code` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `smile_url` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_smilies` MODIFY COLUMN `emoticon` varchar(75) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `template_name` varchar(30) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `style_name` varchar(30) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `head_stylesheet` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_background` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_bgcolor` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_text` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_link` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_vlink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_alink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `body_hlink` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `tr_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `th_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_color3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `td_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface1` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface2` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontface3` varchar(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor1` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor2` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `fontcolor3` varchar(6) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class1` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class2` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes` MODIFY COLUMN `span_class3` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `tr_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `th_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_color3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `td_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontface3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontsize3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `fontcolor3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class2_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class3_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics` MODIFY COLUMN `topic_title` char(60) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_topics_watch` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_user_group` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `username` varchar(25) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_password` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_lang` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_dateformat` varchar(14) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_avatar` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_email` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_icq` varchar(15) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_website` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_from` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_sig_bbcode_uid` char(10) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_aim` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_yim` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_msnm` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_occ` varchar(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_interests` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_actkey` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `user_newpasswd` varchar(32) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_users` MODIFY COLUMN `salt` varchar(5) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_desc` MODIFY COLUMN `vote_text` text CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_results` MODIFY COLUMN `vote_option_text` varchar(255) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_vote_voters` MODIFY COLUMN `vote_user_ip` char(8) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `word` char(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;
ALTER TABLE `phpbb_words` MODIFY COLUMN `replacement` char(100) CHARACTER SET  utf8 COLLATE utf8_general_ci;

PS: Не забываем про ДАМП!

Зачем менять форум, если Вас устраивает текущий? Если всё хорошо то пусть будет так)
А вообще у Вас очень интересный случай, особенно что сообщения хаотично переконвертировались *CRAZY*

Гостья · Сообщение **Гостья** » 26.05.2011 15:48

Dangerous13 , нет, пока не пробовала. завтра попробую и отпишусь.
а по поводу "зачем менять" - ну не вечно же на жигулях кататься, нужно и ауди (например) попробовать :) прогресс идет... да и двойка уже ведь не поддерживается

Сообщение **rxu** » 26.05.2011 18:49

Гостья
В первом посте данной темы есть ответ на ваш вопрос.

Гостья · Сообщение **Гостья** » 27.05.2011 8:59

rxu , я может быть не так профессиональна как тут некоторые, но читать умею. все ваши три пункта - коту под хвост.

Добавлено спустя 7 минут 16 секунд:
Dangerous13 , ваш запрос выдал ошибку

Error

SQL query:

ALTER TABLE `phpbb_themes_name` MODIFY COLEutf8_general_ci;

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'utf8_general_ci' at line 1

Добавлено спустя 2 минуты 9 секунд:
таблицы которые стоят выше phpbb_themes_name перешли на utf8, те что ниже - нет

Сообщение **Sheer** » 27.05.2011 10:07

Гостья писал(а):ALTER TABLE `phpbb_themes_name` MODIFY COLEutf8_general_ci;

Код: Выделить всё

ALTER TABLE `phpbb_themes_name` MODIFY COLUMN `span_class1_name` char(50) CHARACTER SET  utf8 COLLATE utf8_general_ci;

Можно было бы и догадаться.

Гостья · Сообщение **Гостья** » 27.05.2011 13:34

опять.

Error

SQL query:

ALTER TABLE `phpbb_users` MODIFY COLUMN `salt` varchar( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said:
#1054 - Unknown column 'salt' in 'phpbb_users'

Добавлено спустя 6 минут 13 секунд:
выкинула вообще строку

ALTER TABLE `phpbb_users` MODIFY COLUMN `salt` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci;

я правильно сделала?

Добавлено спустя 9 минут 48 секунд:
так, базу вроде сконвертировала.
что теперь должно быть прописано в $lang['ENCODING'] = '...........';
windows-1251 или utf-8 ? или теперь не надо менять?

Добавлено спустя 4 минуты 21 секунду:
хоть windows-1251 , хоть utf-8 , все-равно половина постов в кракозябрах.......

Dangerous13 · Сообщение **Dangerous13** » 27.05.2011 21:14

Да, сделали все правильно. столбец `salt` мне нужен был для работы с паролями при переходе с ipb 2.1.7 на phpbb2.

Ну если у вас и так не получается, то тогда отдельно выгружайте дамп постов и с помоью програмулины "Штирлиц" приводите все к одной кодировке.

phpBB Guru - Официальная русская поддержка форума phpBB3

[FAQ] Как сконвертировать phpBB 2 в phpBB 3

[FAQ] Как сконвертировать phpBB 2 в phpBB 3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3

Re: [FAQ] Конвертация phpBB2 > phpBB3