[Convertor] vBulletin 3.x to phpBB3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
ManiacX
Registered User
Posts: 7
Joined: Tue Mar 27, 2012 12:33 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by ManiacX »

Do you know how to mask subfolders? I want my URL to show mydomain.com, but since phpBB is installed in a subfolder it is displaying as mydomain.com/phpBB3.

Tried a few .htaccess commands but no dice so far.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Sorry, I don't know.
Have you hugged someone today?
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

Hi

I getting next error during converting of vbulletin 3.7.2 database to phpbb 3.0.8

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()
Can you please help me? It drives me crazy because I am noob in this technology.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Jonne_brava wrote:Hi

I getting next error during converting of vbulletin 3.7.2 database to phpbb 3.0.8

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)
Can you please help me? It drives me crazy because I am noob in this technology.
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.

What language is that?
Have you hugged someone today?
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

Hi again.

Let me teel you the full story :D
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

Code: Select all

  $db_character_set = 'ISO-8859-1';
       $encoding = $db_character_set;
to

Code: Select all

$db_character_set = 'utf-8';
       $encoding = $db_character_set;
and also deleted

Code: Select all

    function phpbb_set_encoding($text, $grab_user_lang = true)
    {
       return $text;
    }
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 )

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.
I guess it was some mistakes in my actions? :roll:
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

Hi again

I have solved all of the problem I posted above. SQL base was in the mixed cp1251 and utf8 codes. So i just converted base to utf8 and used phpbb 3.0.10.
Now forum mostly successfully converted excepting some cases.

So what I got now it is the next problems:

1) Some user can not login. They received this message
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.
2) Subjects of all nested topics looks like "Неунывающие Контрабасы приглашают "

Image

Can you help me with that please?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Jonne_brava wrote:2) Subjects of all nested topics looks like "Неунывающие Контрабасы приглашают "
Try the workaround in this post. With this, you will not have to reconvert.

A couple of other suggestions are which do require you to reconvert:
http://www.phpbb.com/community/viewtopi ... #p12862449
http://www.phpbb.com/community/viewtopi ... #p12796126
Jonne_brava wrote:1) Some user can not login.
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.

See http://www.phpbb.com/community/viewtopi ... #p13141432 for the new auth_db.php file
Last edited by D¡cky on Fri Apr 27, 2012 8:52 pm, edited 2 times in total.
Reason: Attachment now posted at http://www.phpbb.com/community/viewtopic.php?p=13141432#p13141432
Have you hugged someone today?
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

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"

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?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

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"
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: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?
Run this query in phpMyAdmin:

Code: Select all

UPDATE phpbb_config SET config_value = 'db' WHERE config_name = 'auth_method'
Change phpbb_ if it is not your table prefix.
Then delete all files in the phpBB3 cache folder except for index.htm and .htaccess.
Have you hugged someone today?
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

After I run this query part of users logged in. But other still can not log in.
All of them exist in phpbb_users table and looks the the same as those who can log in. I even changed their pass to 123456 (just copied hash) - same pass was used for those who can log in. But it sill show me "You have specified an incorrect username..."

I wondering if there are any other checkboxes in the database I need to mark? It looks like users switched off somewhere.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

What is the username and username_clean for a user that gets the error message, ""You have specified an incorrect username...?"
The code actually checks the username_clean to see if a user exists, so possibly there is something wrong with username_clean.
Have you hugged someone today?
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

Yes. There was some strange with them. they looks like converted wrong

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.

I tryed to logon by copy/pasting clean name as login name - did not work

Then I just cleaned up username and wrote "Пуля__", then cleaned up username_clean and wrote "пуля__" - as I think it how they should looks like after converting - but still did not work.
Jonne_brava
Registered User
Posts: 7
Joined: Thu Apr 12, 2012 8:39 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Jonne_brava »

Made rusification for the forum.
Installed STK then have run Reclean Usernames to make sure username_clean are OK.

Still cannot login by some Cyrilic nicknames for example with username "Бильдан" and username_clean "6илƅдaн".

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.

Looks like problem with the character encoding. What can I do? I dont want to do that "name changing" with all nicknames that corrupted.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

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.
πyля__ is the correct username_clean for Пуля__. For some reason it will display as пуля__ in some places.
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.
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.

Were you able to get the auth_db.php file I gave you in a previous post to work? I did find a bug in it that it was giving an incorrect error message. It would say the password was wrong when actually the username could not be found.

I have attached a new auth_db.php file. If you could try it and let me know the results.
You do not have the required permissions to view the files attached to this post.
Have you hugged someone today?
htmlc
Registered User
Posts: 2
Joined: Wed May 23, 2012 12:41 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by htmlc »

Hi - I would LOVE to use this converter but I have a question - how does this converter deal with vbseo urls? I want to make sure the urls are converted over.

Thanks!

Return to “[3.0.x] Convertors”