[Convertor] vBulletin 3.x to phpBB3

[wwalla]

ok, i put them in to the phpbb folder and it looks more promising, except:

General Error
SQL ERROR [ mysql4 ]

Unknown column 'userfield.field4' 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: 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()

[D¡cky]

ok, i put them in to the phpbb folder and it looks more promising, except:

General Error
SQL ERROR [ mysql4 ]

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

This happens sometimes with custom fields. user_field4 is generally used for User Occupation. Do you have a profile field for occupation?

We have a choice of renaming field4 to the field that you are using or we can delete that field altogether from the convertor.

[wwalla]

uploaded into the wrong folder, the vb folder instread of the phpbb folder. Excellent tool and seems that all is transferred. Many many thanks and this is great!

Thanks again.

[Seanieb1983]

Yes, that was it now I am getting an erro here which seems common. I am converting FROM Vbulletin.

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

please help

I'm having this same problem, everything is uploaded in the correct directories as mentioned here, and they're on the same server

mywebsite.co.uk/community111 < old board
mywebsite.co.uk/phpbb3/ < new board

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

its beginning to annoy me now cause i wanna get the forum back online asap, and i cant see any reason why it shouldn't convert for me

[D¡cky]

I'm having this same problem, everything is uploaded in the correct directories as mentioned here, and they're on the same server

mywebsite.co.uk/community111 < old board
mywebsite.co.uk/phpbb3/ < new board

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

Your path is ../community111

[Seanieb1983]

I'm having this same problem, everything is uploaded in the correct directories as mentioned here, and they're on the same server

mywebsite.co.uk/community111 < old board
mywebsite.co.uk/phpbb3/ < new board

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

Your path is ../community111

thanks anyway, turns out i was running the wrong converter!!! I was running the PHPBB one.


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.

[Seanieb1983]

anyone got an idea why this error is happening, I've tried to re-import and still get the error

I really wanna get on with the new PHPBB forum but its seeming like buying a new vB license would have been the better option, and a lot less stressful

[D¡cky]

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.

[samguy]

Hi while converting Vbulletin 3.8 to phpbb i get error http 500 internal server i have followed all the steps and guide. And have installed phpbb3 in a different location than former forum board vb i am using vB 3.x.x 1.0.3 Dicky Credits to wlx Convert please suggest a solution thanks

[D¡cky]

Hi while converting Vbulletin 3.8 to phpbb i get error http 500 internal server

Your server is running out of resources. Try this:

Open {phpbb3_root}/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 that doesn't work, you will need to do the conversion locally. Use EasyPHP, WampServer, or XAMPP.

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

[petersweb]

I keep coming up against this error:

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 80: copy(./../../forum//home/xxxxxx/public_html/forum/attachments/1/1/9/6/844.attach) [function.copy]: failed to open stream: No such file or directory

For some reason, the converter is placing "./../../forum/" in front of my directory path thereby causing the error.

Any ideas would be greatly appreciated!

[D¡cky]

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 80: copy(./../../forum//home/xxxxxx/public_html/forum/attachments/1/1/9/6/844.attach) [function.copy]: failed to open stream: No such file or directory

For some reason, the converter is placing "./../../forum/" in front of my directory path thereby causing the error.

This happens because in your vBulletin configuration, you have the full url in the attachment directory. There are two possible solutions:

1. In the vBulletin Administration Control Panel, set the attachment directory to just the path instead of the full url.
2. OPEN convert_vb3x.php
   FIND

   Code: Select all

   //		'upload_path'			=> 'files/',//人工指定？ files/ is the default path
   		'upload_path'			=> get_config_value('attachpath') . '/',

   REPLACE WITH

   Code: Select all

   		'upload_path'			=> 'attachments/',
   //		'upload_path'			=> get_config_value('attachpath') . '/',

   Replace attachments with the actual directory name where your attachments are stored.

[petersweb]

This happens because in your vBulletin configuration, you have the full url in the attachment directory. There are two possible solutions:

1. In the vBulletin Administration Control Panel, set the attachment directory to just the path instead of the full url.
2. OPEN convert_vb3x.php
   FIND

   Code: Select all

   //		'upload_path'			=> 'files/',//人工指定？ files/ is the default path
   		'upload_path'			=> get_config_value('attachpath') . '/',

   REPLACE WITH

   Code: Select all

   		'upload_path'			=> 'attachments/',
   //		'upload_path'			=> get_config_value('attachpath') . '/',

   Replace attachments with the actual directory name where your attachments are stored.

Thanks Dicky, but no success

I changed the attachments path to just 'attachments' in my AdminCP (I can verify that attachments still work correctly on the site). I also changed the path to my vBuleltin forum in config.php to 'forum' (I had had the full path there).

The error I now get is:

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 80: copy(./../../forum/attachments/1/0/6/6/546.attach) [function.copy]: failed to open stream: No such file or directory

I also tried option #2 but sadly, that didn't make any difference.

I'm attempting to transfer my vBulletin forum to PHPBB for evaluation purposes with a view to moving over permanently so any assistance you can give is appreciated, but not urgent (although I'd like to get this solved soon).

[D¡cky]

I changed the attachments path to just 'attachments' in my AdminCP (I can verify that attachments still work correctly on the site). I also changed the path to my vBuleltin forum in config.php to 'forum' (I had had the full path there).

The error I now get is:

[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 80: copy(./../../forum/attachments/1/0/6/6/546.attach) [function.copy]: failed to open stream: No such file or directory

I also tried option #2 but sadly, that didn't make any difference.

I'm attempting to transfer my vBulletin forum to PHPBB for evaluation purposes with a view to moving over permanently so any assistance you can give is appreciated, but not urgent (although I'd like to get this solved soon).

The most logical reason is that the attachment doesn't exist.
With phpMyAdmin, look in the vBulletin attachments table and find attachment_id 546
Make note of the post_id
Browse your vBulletin board and view that post. Does that attachment show in that post?
Do the same with attachment_id 844.

[bwlinux]

I'm converting a vb 3.5 database and ran into a SQL problem complaining about thread.lastpostid being and unknown field so I commented it out. That seems to allow the convertor to get to the next error where it complains about userfield.field3. So I comment it out as well.

Is there some code I can add to the convertor to map custom fields in VB to new custom profile fields in BB3?