[Convertor] vBulletin 3.x to phpBB3

[farhan89]

Hello,
If i have the Vbulletin database in sql format then how can move my database to PHPBB3 database????

Is there any offline conversion tutorial for vb3.8.x to phpbb3???? I have very large databse and my server ran out of memory when i run the Conversion

[dreamer2007]

Hi,
first thank's for this great script,

I use it, it work good but stop in final step at step 2 (after zebra finish step or something like this ) i have this message error :

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_id' at row 1 [1264]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(187,37,'Excellent!',30)

BACKTRACE

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

FILE: install/convertors/functions_vb30.php
LINE: 56
CALL: dbal_mysqli->sql_query()

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

FILE: install/install_convert.php
LINE: 1652
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: 406
CALL: install_convert->main()

FILE: install/index.php
LINE: 283
CALL: module->load()

[D¡cky]

Hi,
first thank's for this great script,

I use it, it work good but stop in final step at step 2 (after zebra finish step or something like this ) i have this message error :

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_id' at row 1 [1264]

phpBB is configured to handle only 127 poll option id's. Run this query on your database and you will be able to use a lot more. If your table prefix is not phpbb_ then change accordingly.

Code: Select all

ALTER TABLE phpbb_poll_options CHANGE poll_option_id poll_option_id SMALLINT( 4 )

[farhan89]

Hey dicky !
Can u answer my Question plz:
If i have the Vbulletin database in sql format then how can move my database to PHPBB3 database????

Is there any offline conversion tutorial for vb3.8.x to phpbb3???? I have very large databse and my server ran out of memory when i run the Conversion

[D¡cky]

Hey dicky !
Can u answer my Question plz:
If i have the Vbulletin database in sql format then how can move my database to PHPBB3 database????

You will have to first import the sql file into a database. You can use mysql command or BigDump to import the file.
The you will have to run the convertor.

Is there any offline conversion tutorial for vb3.8.x to phpbb3???? I have very large databse and my server ran out of memory when i run the Conversion

You can try this to overcome timeout and memory errors:
Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id: install_convert.php 8814 2008-09-04 12:01:47Z acydburn $
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

After add:

Code: Select all

@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');

If the above doesn't work, you will have to do the conversion offline. Use EasyPHP, WampServer, or XAMPP.

Some helpful tips are in this Knowledge Base article, Offline Conversions

[offlinebaz]

please help me after conver not acp work

Access to the Administration Control Panel is not allowed as you do not have administrative permissions.

[D¡cky]

please help me after conver not acp work

Access to the Administration Control Panel is not allowed as you do not have administrative permissions.

Find what your user_id is.
Using phpMyAdmin, run this query on the phpBB database.

Code: Select all

UPDATE phpbb_users SET user_type = 3 WHERE user_id = xx;

Change phpbb_ to your table prefix if that is not your table prefix.
Replace xx with your user_id.

This will make you a Founder and allow you access to the Administration Control Panel.

[offlinebaz]

not work
please help me

again not work
in phpmyadmin sql Put

UPDATE phpbb_users SET user_type = 3 WHERE user_id = 1324;

next for test for forum not work

[farhan89]

Hey dicky !
Can u answer my Question plz:
If i have the Vbulletin database in sql format then how can move my database to PHPBB3 database????

You will have to first import the sql file into a database. You can use mysql command or BigDump to import the file.
The you will have to run the convertor.

Is there any offline conversion tutorial for vb3.8.x to phpbb3???? I have very large databse and my server ran out of memory when i run the Conversion

You can try this to overcome timeout and memory errors:
Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id: install_convert.php 8814 2008-09-04 12:01:47Z acydburn $
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

After add:

Code: Select all

@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');

If the above doesn't work, you will have to do the conversion offline. Use EasyPHP, WampServer, or XAMPP.

Some helpful tips are in this Knowledge Base article, Offline Conversions

I have tried it But still I got the Mysql ran out of memory error,
The Offline Conversion link u gave doesn't have The procedure to Convert VBulletin to Phpbb3.

Can u give me Some steps for Conversion . I don't want Images , just give me Steps.

[D¡cky]

I have tried it But still I got the Mysql ran out of memory error,
The Offline Conversion link u gave doesn't have The procedure to Convert VBulletin to Phpbb3.

Can u give me Some steps for Conversion . I don't want Images , just give me Steps.

Convert instructions: Convert How To

not work
please help me

again not work
in phpmyadmin sql Put

UPDATE phpbb_users SET user_type = 3 WHERE user_id = 1324;

next for test for forum not work

Your forum doesn't even work? Your login problems may because of that of could be due to incorrect cookie or path settings.

[farhan89]

@Dicky: I want the Steps for the Online Conversion of Vbulletin 3.8.x to Phpbb3. can u help me plz.
Using Bigdump i have Uploaded the database of vbulletin to Phpbb3 Database Now What to do??

[olafkewl]

Hello,

I have a problem when trying to convert from VB 3.0.7 to phpBB 3.0.6

I get the following error during the db conversion process :

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'thread.lastpostid' in 'field list' [1054]

SQL

SELECT thread.threadid, thread.forumid, thread.iconid, thread.postuserid, thread.attach, thread.title, thread.dateline, thread.views, thread.replycount, thread.lastpostid, thread.open, thread.sticky, thread.firstpostid, thread.postusername, thread.lastposter, thread.lastpost, poll.question, poll.dateline, poll.timeout, poll.numberoptions, poll.multiple FROM thread LEFT JOIN poll ON thread.pollid = poll.pollid ORDER BY thread.threadid LIMIT 2000

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_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: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

By the way, it's true, I don't have "lastpostid" in the table called "thread".
Here's the desc of this tables :

Code: Select all

mysql> desc thread;
+--------------+----------------------+------+-----+---------+----------------+
| Field        | Type                 | Null | Key | Default | Extra          |
+--------------+----------------------+------+-----+---------+----------------+
| threadid     | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| title        | varchar(250)         | NO   | MUL |         |                |
| lastpost     | int(10) unsigned     | NO   |     | 0       |                |
| forumid      | smallint(5) unsigned | NO   | MUL | 0       |                |
| pollid       | int(10) unsigned     | NO   | MUL | 0       |                |
| open         | tinyint(4)           | NO   |     | 0       |                |
| replycount   | int(10) unsigned     | NO   |     | 0       |                |
| postusername | varchar(50)          | NO   |     |         |                |
| postuserid   | int(10) unsigned     | NO   | MUL | 0       |                |
| lastposter   | varchar(50)          | NO   |     |         |                |
| dateline     | int(10) unsigned     | NO   |     | 0       |                |
| views        | int(10) unsigned     | NO   |     | 0       |                |
| iconid       | smallint(5) unsigned | NO   | MUL | 0       |                |
| notes        | varchar(250)         | NO   |     |         |                |
| visible      | smallint(6)          | NO   |     | 0       |                |
| sticky       | smallint(6)          | NO   |     | 0       |                |
| votenum      | smallint(5) unsigned | NO   |     | 0       |                |
| votetotal    | smallint(5) unsigned | NO   |     | 0       |                |
| attach       | smallint(5) unsigned | NO   |     | 0       |                |
| firstpostid  | int(10) unsigned     | NO   |     | 0       |                |
| similar      | varchar(55)          | NO   |     |         |                |
+--------------+----------------------+------+-----+---------+----------------+
21 rows in set (0.00 sec)

Any idea ?

Thanks !!!

[farhan89]

I am Getting This error:

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'userfield.field2' in 'field list' [1054]

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 2000

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

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

FILE: _install/install_convert.php
LINE: 1241
CALL: dbal->sql_query_limit()

FILE: _install/install_convert.php
LINE: 211
CALL: install_convert->convert_data()

FILE: _install/index.php
LINE: 405
CALL: install_convert->main()

FILE: _install/index.php
LINE: 282
CALL: module->load()

What to do???

[d3vlabs]

couple of questions

does this converter carry over attachments?
does this convert reputation points?

what about permissions? such as mods/admins/etc

[Trokanda]

Anyway it converts now, but i cant log in there's something up with the password field:

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'user_passwd_salt' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

The convertor should have created the user_passwd_salt field. You can create it manually in phpMyAdmin by entering the following code in the SQL tab: (If your table prefix is not phpbb_ replace with your table_prefix)

Code: Select all

ALTER TABLE phpbb_users ADD user_passwd_salt varchar(5) COLLATE utf8_bin NOT NULL DEFAULT ''

You will need to rerun the convertor so the field gets filled in.

did that, but somehow is the entry user_passwd_salt gone after I do the convertion again. any idea?