[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
cheeba_00788
Registered User
Posts: 2
Joined: Fri Oct 23, 2009 4:28 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by cheeba_00788 »

bwlinux wrote:The convertor was not able to find tables with the specified prefix. Please make sure you have entered the correct details for the board you are converting from. The default table prefix for vB 3.x.x is vb_.

This comes out when i press begin conversation. I think it's from here: Prefix for tables in database: vb_ . What could it be?

I too have this problem! I do not know how to fix it. Someone can help me?
cheeba_00788
Registered User
Posts: 2
Joined: Fri Oct 23, 2009 4:28 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by cheeba_00788 »

No one who knows how to help me?
Please .....
User avatar
LxPower*
Registered User
Posts: 82
Joined: Wed Jan 03, 2007 2:31 am
Location: C:\

Re: [Convertor] vBulletin 3.x to phpBB3

Post by LxPower* »

hello there i am tryng to convert
vb3.8 ->> phpBB3
Getting this error:
General Error
SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

SQL

SELECT * FROM forum WHERE parentid = -1 ORDER BY displayorder

BACKTRACE

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

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

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 8
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: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()
Some ideas ?
phpBB Just The Best !
User avatar
LxPower*
Registered User
Posts: 82
Joined: Wed Jan 03, 2007 2:31 am
Location: C:\

Re: [Convertor] vBulletin 3.x to phpBB3

Post by LxPower* »

cheeba_00788 wrote:
bwlinux wrote:The convertor was not able to find tables with the specified prefix. Please make sure you have entered the correct details for the board you are converting from. The default table prefix for vB 3.x.x is vb_.

This comes out when i press begin conversation. I think it's from here: Prefix for tables in database: vb_ . What could it be?

I too have this problem! I do not know how to fix it. Someone can help me?
Go to phpMyadmin panel and look you prefix, maybe you don´t even have it .
then just leave this box empty.
phpBB Just The Best !
iannalex
Registered User
Posts: 1
Joined: Wed Oct 28, 2009 10:53 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by iannalex »

Have just done a test conversion from vB3.8.4 to phpBB3 and all went well apart from a couple of minor glitches which I've sorted.

The only things that weren't carried over were custom fields in the the user profiles. Is there any way to modify the converter to allow these fields to be carried across? Or a method of adding them after conversion.

Any help greatly appreciated.
User avatar
PinoyEngine™
Registered User
Posts: 244
Joined: Fri Apr 24, 2009 7:12 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by PinoyEngine™ »

Hi I am converting 3.8.0 vBulleting to PHPBB3

I am getting this error:
General Error
SQL ERROR [ mysql4 ]

Table 'xxxx.user' doesn't exist [1146]

SQL

SELECT userid FROM user WHERE userid = 1

BACKTRACE

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

FILE: install/convertors/convert_vb30.php
LINE: 192
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 745
CALL: include('install/convertors/convert_vb30.php')

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()
is there really "user table" in the vBulletin SQL?

thanks
Setto
Registered User
Posts: 1
Joined: Fri Nov 06, 2009 9:26 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Setto »

Hi :P
Thank you for sharing this convertor with us. :geek:
You should know that I have subscribed to Phpbb.com especially to thank you.
I am an old user of phpbb but at one time I shifted to :arrow: Vbulletin.
Now I am back :idea:
Everythnig went smoothly during the conversion. I didn't face any problem.

source forum: >>site removed>>
Destination forum: >>site removed>>

Thanks again




Last edited by darcie on Sat Nov 07, 2009 4:38 am, edited 1 time in total.
Reason: Links to your site not needed, 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 was Converting vb 3.8.2 to phpbb3 and i am getting this error

SQL ERROR [ mysql4 ]

[0]

SQL

SELECT userid FROM user WHERE username = 'Mohid)'

BACKTRACE

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

FILE: _install/convertors/functions_vb30.php
LINE: 1926
CALL: dbal_mysql->sql_query()

FILE:
LINE:
CALL: vb3_get_userid_from_username()

FILE: _install/install_convert.php
LINE: 2023
CALL: call_user_func_array()

FILE: _install/install_convert.php
LINE: 1275
CALL: install_convert->process_row()

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



Can anyone help me on this?????
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 was Converting vb 3.8.2 to phpbb3 and i am getting this error

SQL ERROR [ mysql4 ]

[0]

SQL

SELECT userid FROM user WHERE username = 'Mohid)'
farhan89 wrote:Can anyone help me on this?????
It looks like a stray parenthesis made its way into the code.

OPEN functions_vb30.php

FIND

Code: Select all

		WHERE username = '$username)'";
REPLACE WITH

Code: Select all

		WHERE username = '$username'";
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 »

I got this error Now:

Code: Select all

SQL ERROR [ mysql4 ]

MySQL client ran out of memory [2008]

SQL

SELECT userid FROM user WHERE username = 'Mohid'

BACKTRACE

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

FILE: _install/convertors/functions_vb30.php
LINE: 1926
CALL: dbal_mysql->sql_query()

FILE: 
LINE: 
CALL: vb3_get_userid_from_username()

FILE: _install/install_convert.php
LINE: 2023
CALL: call_user_func_array()

FILE: _install/install_convert.php
LINE: 1275
CALL: install_convert->process_row()

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

Seems Like Msql Memory error :(

Is there any other possible solution for this ?????????
Can i export the database of VBulletin and then Import it to phpbb3 database? will this work??
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 got this error Now:

Code: Select all

SQL ERROR [ mysql4 ]

MySQL client ran out of memory [2008]

SQL

SELECT userid FROM user WHERE username = 'Mohid'

BACKTRACE

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

FILE: _install/convertors/functions_vb30.php
LINE: 1926
CALL: dbal_mysql->sql_query()

FILE: 
LINE: 
CALL: vb3_get_userid_from_username()

FILE: _install/install_convert.php
LINE: 2023
CALL: call_user_func_array()

FILE: _install/install_convert.php
LINE: 1275
CALL: install_convert->process_row()

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

Seems Like Msql Memory error :(

Is there any other possible solution for this ?????????
Can i export the database of VBulletin and then Import it to phpbb3 database? will this work??
No, you cannot simply export the database of VBulletin and then Import it to phpbb3 database. If it were that easy, a convertor would not be needed.

Regarding the MySQL memory error, you should contact your host about this. There are some articles at mysql.com about this. It could be because an ODBC driver is being used or it may be because you have a very large database.
My other suggestion is to try the conversion locally. Use EasyPHP, WampServer, or XAMPP.

Some helpful tips are in this Knowledge Base article, Offline Conversions
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 »

Yes i have very large database
I downloaded the easy PHP but it's not starting the server it's giving error that apache2 port(80)is used by ""inedtinfo.exe.

What to 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
Contact:

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

We don't support EasyPHP so you will need to ask at the EasyPHP support page. Another process is using port 80 and it appears that it may be IIS Web Server. If you do have IIS Web Server, shut it down before running EasyPHP or use the IIS Web Server instead.
Have you hugged someone today?
Catscan
Registered User
Posts: 7
Joined: Mon Nov 09, 2009 5:01 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Catscan »

Just converted vB3.8.4 to phpBB3.

But my å ä ö swedish letters in topics is wrong:
Image
............................
Image

Inside posts åäö the topics has the correct å ä ö but in forum where all topics are listed å ä ö is messed up.
Is it possible to fix it? :roll:

In my installation i chose swedish language before the conversion.
Catscan
Registered User
Posts: 7
Joined: Mon Nov 09, 2009 5:01 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Catscan »

Solved it, replaced these letters in my database. :geek: :D
Locked

Return to “[3.0.x] Convertors”