Code: Select all
Общая ошибка
SQL ERROR [ mysql4 ]
Incorrect string value: '\xD1\xEF\xF0\xE0\xE2\xEE...' for column 'forum_name' at row 1 [1366]
SQL
INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_rules, left_id, right_id) VALUES ('1', 'Справочная информация', 0, '', '', 0, 0, '', 1, 2)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: install/convertors/functions_vb30.php
LINE: 201
CALL: dbal_mysql->sql_query()
FILE: install/install_convert.php(1003) : eval()'d code
LINE: 4
CALL: phpbb_insert_forums()
FILE: install/install_convert.php
LINE: 1003
CALL: eval()
FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()
FILE: install/index.php
LINE: 409
CALL: install_convert->main()
FILE: install/index.php
LINE: 286
CALL: module->load()
First of all, you should be converting to phpbB 3.0.10 and using the download package at the Downloads page, not a one-click install. That may be enough to cure your problem.Jonne_brava wrote:Hi
I getting next error during converting of vbulletin 3.7.2 database to phpbb 3.0.8
Can you please help me? It drives me crazy because I am noob in this technology.Code: Select all
Общая ошибка SQL ERROR [ mysql4 ] Incorrect string value: '\xD1\xEF\xF0\xE0\xE2\xEE...' for column 'forum_name' at row 1 [1366] SQL INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_rules, left_id, right_id) VALUES ('1', 'Справочная информация', 0, '', '', 0, 0, '', 1, 2)
I guess it was some mistakes in my actions?1) So at the begining I had a vbulletin 3.6.8 forum with Russian language.
2) Then I found some instruction of how to convert vbulletin 3.7.2 and older to phpbb 3.0.x. using your converter.
3) I upgraded vbulletin to 3.7.2 using standartd files with an ENGLISH language. So at this step I got Vbulletin 3.7.2 with mixed Russian\English administration panel.
4) Then I exported vbulletin database using phpmyadmin. As i understood it was in UTF-8. Just to back up.
5) Donwloaded somewhere here vb30x_phpbb3-v0.7.zip and changed by Notepad++ coulple of strings below
toCode: Select all
$db_character_set = 'ISO-8859-1'; $encoding = $db_character_set;
and also deletedCode: Select all
$db_character_set = 'utf-8'; $encoding = $db_character_set;
6) After that I created in the root directory of my site 2 folders - Forum ( placed there 1 click installation of phpbb 3.0.8 with converter files placed in the include\auth and install\converters folders) and the Forums (there was my Vbulletin 3.7.2 forum it still worked without problem )Code: Select all
function phpbb_set_encoding($text, $grab_user_lang = true) { return $text; }
7) Then I started 1 click installation phpbb (russian language) to the same database that was used for Vbulletin forum. And in the end of installation choosed Convertation of forum and picked vb30x_phpbb3-v0.7 converter instead of standard phpbb2_to_phpbb3.
8) At then I received SQL error like I posted before.
2) Subjects of all nested topics looks like "ÐеÑнÑваÑÑие ÐонÑÑабаÑÑ Ð¿ÑиглаÑаÑÑ "It was not possible to convert your password when updating this bulletin board’s software. Please request a new password. If you continue to have problems please contact the Board Administrator.
Try the workaround in this post. With this, you will not have to reconvert.Jonne_brava wrote:2) Subjects of all nested topics looks like "ÐеÑнÑваÑÑие ÐонÑÑабаÑÑ Ð¿ÑиглаÑаÑÑ "
Try the attached auth_db.php. Unzip and upload to includes/auth. It does require you to change the Authentication Method which you can do in the Administration Control Panel -> General -> Authentication.Jonne_brava wrote:1) Some user can not login.
If you haven't misspelled the username, the error message "You have specified an incorrect username" usually means that the user does not exist. Have you checked the database to be sure all users have been converted?Jonne_brava wrote:Hi
After I converted Vbulletin again it shown me no errors but I cannot login to the converted forum at all.
it always show me "You have specified an incorrect username"
Run this query in phpMyAdmin:Jonne_brava wrote:Also It does not work if I upload auth_db.php
And I cant reach administration pane to change authorization method.
What can I do?
Code: Select all
UPDATE phpbb_config SET config_value = 'db' WHERE config_name = 'auth_method'
πyля__ is the correct username_clean for Пуля__. For some reason it will display as пуля__ in some places.Jonne_brava wrote:For example clean name "Пуля__" was converted as "πyля__" but should be converted as "пуля__" you can see the difference in 1st letter. This name didn't work for log on.
If you can find the username in the Admin Panel, that means that the username_clean is correct which indicates a possible problem with the password.Jonne_brava wrote:In the admin pane found user "Бильдан" then changed name to "Bildan" resetted password to 123456, cleaned cash folder except access and index files - logged successfully. Then changed name back to Бильдан - login successfully. Username and username_clean looks the same.