[Convertor] vBulletin 3.x to phpBB3

[cheeba_00788]

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]

No one who knows how to help me?
Please .....

[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 ?

[LxPower*]

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.

[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.

[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]

Hi
Thank you for sharing this convertor with us.
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 Vbulletin.
Now I am back
Everythnig went smoothly during the conversion. I didn't face any problem.

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

Thanks again

[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?????

[D¡cky]

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

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'";

[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??

[D¡cky]

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

[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??

[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.

[Catscan]

Just converted vB3.8.4 to phpBB3.

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

............................


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

In my installation i chose swedish language before the conversion.

[Catscan]

Solved it, replaced these letters in my database.