[Convertor] vBulletin 3.x to phpBB3

[itsmefahad]

Mention below msg i copy from conversion page, after this message page close & problem loading page error shows.


----------------------
Installation Panel

Skip to content

* Overview
* Convert

* Introduction
* Settings
* Conversion in progress
* Final stage

Filling tables

Filling table phpbb_privmsgs:

skip_rows = 6166:

skip_rows = 8166:
186 rows/s (2000 rows) |

skip_rows = 10166:
175 rows/s (2000 rows) |

skip_rows = 12166:
167 rows/s (2000 rows) |

skip_rows = 14166:
168 rows/s (2000 rows) |

Step 8 of 16
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

[D¡cky]

If the convertor always stops at the same place, then you probably have a very long private message or a private message with a long unbroken string of characters or smilies.

Look in the phpBB3 priv_msgs table and see what the last message is. Then look in the vBulletin pmtext table after the last message that was inserted in phpBB3 and see if you can spot something out of the ordinary.

[itsmefahad]

Any way to i discard all of pvt msgs?

[Vashidu]

i have a error, please help me

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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 'where config_name="board_startdate"' at line 1 [1064]

SQL

update phpbb_config set config_value= where config_name="board_startdate"

BACKTRACE


FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 66
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: install/install_convert.php
LINE: 1654
CALL: eval()

FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()

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()

[D¡cky]

i have a error, please help me

The board start date is taken from the oldest post that was converted to phpBB3. Either your vBulletin posts did not get converted to phpBB3 or the oldest post does not have a post time. Look at the phpbb posts table to see what is going on.

[killer1993]

I tried to convert vBulletin 4.0.7 to phpBB 3.0.8, but the results turned out quite grusome.
First of all, I was spammed with about 4,000 e-mails about failed deliveries.
Next, all e-mails except for mine, were changed to random AOL e-mails.

And, in addition to that, the board refuses to send me a reset password.

I might need a bit of assistance here.

[D¡cky]

To convert vBulletin 4, use the file in this post in addition to the vBulletin 3 convertor files.

[mhorpheox]

hello i'm converting vbulletin 3.82 to phpbb 3.08 but at step 7 of 16 i have this error:

Code: Select all

SQL ERROR [ mysqli ]

Error writing file '/tmp/MYWwp0nW' (Errcode: 28) [3]

SQL

SELECT user.userid, user.userid AS poster_id, user.usergroupid, user.ipaddress, user.salt, user.joindate, user.username, user.password, user.posts, user.email, user.birthday, user.lastvisit, user.lastactivity, user.timezoneoffset, userfield.field2, userfield.field3, userfield.field4, user.homepage, user.msn, user.yahoo, user.aim, user.icq, user.customtitle, avatar.avatarpath, user.pmunread, user.emailstamp, user.autosubscribe, usertextfield.signature, user.joindate AS post_time FROM ((user LEFT JOIN userfield ON user.userid = userfield.userid) LEFT JOIN usertextfield on user.userid=usertextfield.userid) LEFT JOIN avatar on user.avatarid=avatar.avatarid WHERE (user.userid <> -1) ORDER BY user.userid LIMIT 10994, 2000

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

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 help me?
thank u

[D¡cky]

That is a temporary file for the MySQL server. You will need to contact your hosting provider to find why that file is unavailable. It may be that the server became overloaded at that step. If that is the case, restarting the convertor may allow you to continue after the server has settled down. Go to install/index.php and click the convert tab. You will be presented with a "Continue previously started conversion." Clicking this button will start the conversion where it left off and continue on.

[mario_7]

Hi.

First of all - thank you for this convertor.

I'd like to share with you fixes and improvements that I developed while converting Polish Ubuntu Linux Forum from vBulletin 3.8.4 to phpBB3.

Fixed:

• converting form UTF-8 vb3 to UTF-8 phpBB3 (not tested with any other setup)
• Private Messages IDs (wrong field was considered as PM ID)
• PMs recipients in Sent folder (all were set to Anonymous)
• BBCodes conversion (it wasn't covering all cases)
• convert_zebra function (few details were preventing this function from working at all)
• importing ranks (even with some kind of special ranks support)
• updated auth_vb3.php file with code from recent auth_db.php file (the part with anti-bot question which was not working properly)

New features:

• importing censor (words and usernames)
• cleaning code tags (vb3 parses other BBCodes inside code tags, phpBB3 does not do this)
• importing maxonline and maxonlinedate data
• importing custom user profile fields (or at least example how to do this )
• converting old vb3 style URLs to new phpBB3 style URLs inside posts
• vb3 characteristic php files that act as redirects to appropriate phpBB3 files

Details about all changes in comments inside php files.

I'm attaching exact script i used to convert forum, so you will probably want to extract universal parts from it.

Hope you will find my code useful.

P.S.
The proof that forum is actually working after conversion: http://ubuntu.pl/forum/

[Souljacker]

Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?

[jemiesranova]

Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?

you can try using the format "link" [L] [/ L] or by opening the HTML tips on the forum.

[D¡cky]

Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?

../forum should be the correct path.

Are both boards in the same domain?
The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.
Does the file showthread.php exist in the vBulletin root directory?

[mario_7]

The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.

Isn't it just needed that files and database are on the same server?

[D¡cky]

The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.

Isn't it just needed that files and database are on the same server?

No, they have to be in the same domain or the same subdomain. Relative paths will not work across different domains or different subdomains.