[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.
Scam Warning
farhan89
Registered User
Posts: 51
Joined: Wed Mar 18, 2009 7:08 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
Registered User
Posts: 42
Joined: Sat Jul 21, 2007 10:52 am

Re: [Convertor] vBulletin 3.x to phpBB3

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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

dreamer2007 wrote: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 :roll: ) 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 )
Have you hugged someone today?
farhan89
Registered User
Posts: 51
Joined: Wed Mar 18, 2009 7:08 pm

Re: [Convertor] vBulletin 3.x to phpBB3

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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

farhan89 wrote: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.
farhan89 wrote: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
Have you hugged someone today?
offlinebaz
Registered User
Posts: 2
Joined: Mon Oct 26, 2009 7:44 pm

Re: [Convertor] vBulletin 3.x to phpBB3

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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

offlinebaz wrote: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.
Have you hugged someone today?
offlinebaz
Registered User
Posts: 2
Joined: Mon Oct 26, 2009 7:44 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by offlinebaz »

not work :? :? :?
please help me
:shock: :shock: :shock: :shock:
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
Registered User
Posts: 51
Joined: Wed Mar 18, 2009 7:08 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by farhan89 »

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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

farhan89 wrote: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

offlinebaz wrote:not work :? :? :?
please help me
:shock: :shock: :shock: :shock:
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.
Have you hugged someone today?
farhan89
Registered User
Posts: 51
Joined: Wed Mar 18, 2009 7:08 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
Registered User
Posts: 1
Joined: Tue Nov 24, 2009 10:44 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
Registered User
Posts: 51
Joined: Wed Mar 18, 2009 7:08 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
Registered User
Posts: 1
Joined: Sat Nov 28, 2009 6:57 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by d3vlabs »

couple of questions

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

what about permissions? such as mods/admins/etc
Trokanda
Registered User
Posts: 2
Joined: Fri Dec 04, 2009 9:20 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Trokanda »

D¡cky wrote:
Seanieb1983 wrote: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?
Locked

Return to “[3.0.x] Convertors”