[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.
Anti-Spam Guide
wwalla
Registered User
Posts: 76
Joined: Fri Feb 20, 2009 2:59 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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()
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 »

wwalla wrote: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.
Have you hugged someone today?
wwalla
Registered User
Posts: 76
Joined: Fri Feb 20, 2009 2:59 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
Registered User
Posts: 3
Joined: Sun Sep 06, 2009 11:46 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Seanieb1983 »

wwalla wrote: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.


:cry: 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
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 »

Seanieb1983 wrote:
wwalla wrote: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
Have you hugged someone today?
Seanieb1983
Registered User
Posts: 3
Joined: Sun Sep 06, 2009 11:46 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Seanieb1983 »

D¡cky wrote:
Seanieb1983 wrote:
wwalla wrote: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
Registered User
Posts: 3
Joined: Sun Sep 06, 2009 11:46 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
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 »

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.
Have you hugged someone today?
samguy
Registered User
Posts: 3
Joined: Tue Sep 15, 2009 7:25 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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
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 »

samguy wrote: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
Have you hugged someone today?
petersweb
Registered User
Posts: 2
Joined: Wed Jun 23, 2004 3:53 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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!
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 »

petersweb wrote:[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.
Have you hugged someone today?
petersweb
Registered User
Posts: 2
Joined: Wed Jun 23, 2004 3:53 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by petersweb »

D¡cky wrote: 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 :cry:

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).
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 »

petersweb wrote: 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.
Have you hugged someone today?
bwlinux
Registered User
Posts: 1
Joined: Thu Oct 22, 2009 6:52 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by 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?
Locked

Return to “[3.0.x] Convertors”