vBulletin 4.0.x to phpBB 3.0.x

prototech · Post by **prototech** » Sat Feb 09, 2013 9:43 pm

I also need the names of the fields, otherwise the values aren't worth much.

The file seems fine, it's exactly the same as the one shipped with 3.0.11. I'm not sure what else could be causing it, unless you installed a MOD by any chance.

yamahar · Post by **yamahar** » Sat Feb 09, 2013 10:12 pm

No no mods, totally fresh install, it has to be the conversion script I used to get it from Vbulletin into phpbb, it's the only thing stopping me migrate my board now as I cannot get into the groups to set the permissions and it seems like that has not converted.

It looks like there are non standard groups and that is screwing it up ? am I right ?

I couldn't really care less about the attachements really, but I guess users will moan if they are not there anymore.

Code: Select all

	attachmentid	contenttypeid	contentid	userid	dateline	filedataid	state	counter	posthash	filename	caption	reportthreadid	settings	displayorder	importattachmentid
	  Edit	  Inline Edit	  Copy	 Delete	1	18	6	1	1294838337	1	visible	4	af829414d0344c360813e9041549e3f5	37236.jpg	NULL	0	NULL	0	0
	  Edit	  Inline Edit	  Copy	 Delete	2	18	7	1	1294838337	2	visible	1	af829414d0344c360813e9041549e3f5	37237.jpg	NULL	0	NULL	0	0
	  Edit	  Inline Edit	  Copy	 Delete	3	18	8	1	1294838337	3	visible	1	af829414d0344c360813e9041549e3f5	37238.jpg	NULL	0	NULL	0	0
	  Edit	  Inline Edit	  Copy	 Delete	4	18	9	1	1294838337	4	visible	2	af829414d0344c360813e9041549e3f5	37254.jpg	NULL	0	NULL	0	0

Does that make more sense ?

prototech · Post by **prototech** » Sun Feb 10, 2013 7:18 am

Thanks. I have access to a vBulletin board now, so I am now able test the converter properly. I'll post an updated version in a few days.

prototech · Post by **prototech** » Sat Mar 02, 2013 10:00 pm

Here is an updated version of the converter. This has been tested with vBulletin 4.2.0 and phpBB 3.0.11. I have cleaned up the code and fixed quite a large number of bugs in the process. The change log provides a basic overview of the changes made.

I haven't had the opportunity to review the code that handles permissions so that area may still be problematic. Please report any bugs/errors encountered here. Thanks.

vb4_convertor_1.1.1.zip: (24.03 KiB) Downloaded 1829 times

Change log
1.1.1 (3/22/2013)

Fixed incorrect field and table names for finding if there is a user with user id 1.

1.1.0 (3/2/2013)

Fixed several PHP and database errors:
- PHP Notice due to Undefined property: dbal_mysql::$mysql_version
- PHP Notice due to Undefined index: ID_MEMBER
- Incorrect integer value: 'minposts' for column 'rank_min'
- Incorrect decimal value: '' for column 'user_timezone'
- Out of range value for column 'user_notify'
- Data too long for column 'user_passwd_salt'

Code: Select all

 bbcode is now displayed correctly. 
[*]Link forums and forums with passwords are now correctly transferred over. 
[*]Forums that are not under a category are no longer skipped. 
[*]Forums with the "Forum is Open" option set to no are now locked in phpBB. 
[*]Inline attachments are now parsed correctly. 
[*]Smilies that do not have whitespace around them in vB are now padded with space so that the phpBB parser can parse them. 
[*]Fixed an error with poll options being assigned the same id resulting in new votes getting counted for all options. 
[*]Updated the authentication plugin to the current state of auth_db.php. This hadn't been updated since at least 2009, so it didn't support CAPTCHA plugins. 
[*]Passwords with HTML special characters now work post-conversion. 
[*]The database character set is now automatically fetched from the languages table. 
[*]Special vB groups are now hidden and the "public (joinable)" setting for other groups is now adhered to. 
[*]New data transferred over:
[list]
[*]Attachments 
[*]Additional board configuration settings 
[*]Additional user preferences 
[*]Friend/ignore lists 
[*]Shadow topics (for moved topics) 
[*]Topic/post icons
[*]List of disallowed usernames [/list][/list]

IainM · Post by **IainM** » Mon Mar 18, 2013 11:26 pm

Thanks for this, the converter looks to be just what I need

So, I dived right in...

Two issues thus far...

1.) On initial attempts I seemed to be missing a "users" table in the vB schema, so I copied the "user" table into "users" and everything worked Ok (I had also to rename the userid column as user_id in the new table). All good afterwards until...

2.) I get to about row 112,000 in the phpbb_posts insert process when the script bugs out with (I think, according to the interwebs) a memory leak, and Apache restarts. Have tried several times with the same result.

Any assistance appreciated

Thanks!

Iain

Apache Error Log below (nothing useful in the PHP log)

Code: Select all

[Mon Mar 18 16:12:23 2013] [notice] Parent: Created child process 33400
[Mon Mar 18 16:12:23 2013] [notice] Child 33400: Child process is running
[Mon Mar 18 16:12:23 2013] [notice] Child 33400: Acquired the start mutex.
[Mon Mar 18 16:12:23 2013] [notice] Child 33400: Starting 64 worker threads.
[Mon Mar 18 16:12:23 2013] [notice] Child 33400: Starting thread to listen on port 80.
[Mon Mar 18 16:12:55 2013] [notice] Parent: child process exited with status 255 -- Restarting.
[Mon Mar 18 16:12:55 2013] [notice] Apache/2.2.22 (Win32) PHP/5.3.21 configured -- resuming normal operations
[Mon Mar 18 16:12:55 2013] [notice] Server built: Jan 28 2012 11:16:39

IainM · Post by **IainM** » Tue Mar 19, 2013 4:46 pm

The only thing I've tried (which hasn't worked) is to increase the memory available for PHP execution from 128Mb to 1024Mb (same result, at the same point).

Code: Select all

memory_limit = 1024M

totallytech · Post by **totallytech** » Thu Mar 21, 2013 1:36 pm

Hi,

I'm quite sure I'm being really dim but do I install the vb 4.2.0 -> phpBB 3.0.x converter on the vb site or the phpBB site?

prototech · Post by **prototech** » Fri Mar 22, 2013 9:09 am

IainM wrote:1.) On initial attempts I seemed to be missing a "users" table in the vB schema, so I copied the "user" table into "users" and everything worked Ok (I had also to rename the userid column as user_id in the new table). All good afterwards until...

I'm not sure how this slipped by.

Fixed in the latest download.

IainM wrote:2.) I get to about row 112,000 in the phpbb_posts insert process when the script bugs out with (I think, according to the interwebs) a memory leak, and Apache restarts. Have tried several times with the same result.

You can try reducing the batch size. In convert_vb4.php, find $test_file = 'showthread.php';... after, add $convert->batch_size = 1000;.

You can also try adding the following before if (!defined('IN_INSTALL')) in install/install_convert.php:

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

totallytech wrote:Hi,

I'm quite sure I'm being really dim but do I install the vb 4.2.0 -> phpBB 3.0.x converter on the vb site or the phpBB site?

The converter relies on the phpBB installation system. See the Convert How To stickied at the top of this forum for how to use it.

IainM · Post by **IainM** » Mon Mar 25, 2013 7:16 pm

Thanks for the suggestions prototech, tried implementing both but unfortunately Apache still dies in approximately the same place in the conversion

Cheers, Iain

prototech · Post by **prototech** » Mon Mar 25, 2013 9:42 pm

Take a look at the posts table in phpBB to see which was the last post converted. Then see if the post that follows in the vBulletin posts table is rather large or if there's anything out of the ordinary.

IainM · Post by **IainM** » Tue Mar 26, 2013 1:08 am

Not that I could see. I guess it could be anywhere in the next "batch" of posts the converter looks at. I deleted a week's worth of posts to see if it would progress.

It did, once or twice, and then I had to do the same thing. And then do the same thing again.

I'm liable to lose a lot of posts with the shotgun approach, I'm only up to July 2011

Anything else I can do to provide more debug information?

Cheers!

Iain

storrm · Post by **storrm** » Thu Mar 28, 2013 8:02 pm

Help! Struggling to import a 4.03 vB board which has been struck with a trojan. Managed to save the SQL data and original website, imported to a new server and installed phpBB3. Ran the installer (no problems), downloaded the 1.1.1 converter and went immediately to the Conversion page. Configured it to point to the old database and also the location of the old website relative to the phpBB3 doc root. Everything checked out fine and the conversion started to work until I got to "Filling table phpbb_posts" (it says step 10 of 20 but to be honest, I think it said that on each page!). When I hit the continue conversion button I get loads of the following errors on the page :-

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb4.php on line 744: Invalid argument supplied for foreach()

and then at the bottom I get 4 lines of

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/install/index.php on line 361: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)

I can't link my php errors log because for some reason its not logging anything at the moment.

xtreamer · Post by **xtreamer** » Fri Mar 29, 2013 5:09 pm

could you help me with this:

viewtopic.php?f=65&t=2177674

SeveralZombies · Post by **SeveralZombies** » Fri Jul 26, 2013 8:23 pm

After filling in the required fields and starting the converter, it redirects me back to my site, seemingly without importing any of the information from the vBulletin install. I'm not seeing anything in the tables and there's nothing in the error logs to indicate any catastrophic failure -- it just sends me back to an imageless front page (the url includes ?mode=convert&sub=in_progress&tag=vb4&confirm=1&language=en on the end, but it's not moving from there and I'm not getting any kind of prompt) The information is definitely there (I can see the old forum posts if I go to mydomain.com/fourms, even without a valid vB license) but the the converter doesn't seem to want to bring that data over to the PHPBB install.

Has anyone else encountered a similar issue?

phrogg · Post by **phrogg** » Tue Oct 08, 2013 12:17 am

I'm having exactly the same errors. I cannot get vB imported past this step. I see that it has created the Forums and all of the boards under that. I also see users having been created and groups. But then there are no topics to work with yet. So I think its failing there somewhere.

storrm wrote: When I hit the continue conversion button I get loads of the following errors on the page :-
Code: Select all
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_vb4.php on line 744: Invalid argument supplied for foreach()
and then at the bottom I get 4 lines of
Code: Select all
[phpBB Debug] PHP Warning: in file [ROOT]/install/index.php on line 361: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
I can't link my php errors log because for some reason its not logging anything at the moment.

advertisements