[SUPPORT] vBulletin 3.0.x to phpBB

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
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:

[SUPPORT] vBulletin 3.0.x to phpBB

Post by D¡cky »

The vBulletin 3.0.x convertor will transfer the following:
  • Forums and subforums. Subforums are placed into a new category.
  • Topics
  • Posts
  • Users
  • Groups
  • Ranks
  • Private messages
  • Topics watch
  • Polls
  • Banned list
  • Censored words
This convertor should work for all 3.0.x versions.

Download
Have you hugged someone today?
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

PMs

Post by justinkim »

Tried converting a vBulletin DB tonight. Everything seems to have worked well except PMs. I have 5,150 PMs in my vBulletin DB and only 3,093 seem to have been converted.
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:

Post by D¡cky »

vBulletin has two pm tables, a vb3_pm and a vb3_pmtext. The vb3_pm table has a lot of duplicate pm's. I am not sure why, but I used the vb3_pmtext table for the conversion. This table seems to contain all the pm's.

You may end up with even less pm's than what shows in the vb3_pmtext table as I did not convert pm's for users that are no longer a member of the board.
Have you hugged someone today?
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

I've only checked a few accounts so far, but all of the accounts I've checked are missing PMs. I've checked the VB database to make sure that the missing PM's are there (which they are).

I've also set the PM quota to be very high.

Thanks for your help and for writing the converter!
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:

Post by D¡cky »

Are you looking at the vb3_pmtext table?
Are both the sender and receiver members of your vB board?

Keep in mind too that the user id's are different between vB and phpBB. The user id's are one higher in phpBB than vB.
Have you hugged someone today?
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

I did check the count of messages in the VB pmtext table and phpbb_privmsgs, and the is a difference of 29 messages. This doesn't account for all of the missing messages.
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

D¡cky wrote: Are you looking at the vb3_pmtext table?
Are both the sender and receiver members of your vB board?


Yes.

I checked the last 40 or so messages in the VB board and then checked to see if they made it to phpbb in the DB (they hadn't). I also checked the phpBB account inboxes some of those messages should have been in to make sure I didn't miss them in my queries.

There also appear to be at least a few dupes in the phpBB PM tables.
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:

Post by D¡cky »

See if this works any better

conv_pm.php

Right click on the link and save to your vb3_2phpbb directory.

Then run just the pm conversion section of the convertor.

I think the id's were getting confused.
Have you hugged someone today?
{S'PORT}_Skillz
Registered User
Posts: 297
Joined: Fri Aug 23, 2002 5:56 am

Post by {S'PORT}_Skillz »

Dicky,

I love you. Will be testing this out tomorrow after I get home from work. Hopefully everything works perfectly!

Thanks man! You rock!
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

That link redirects me to http://portal.tds.net/. You may have to zip it.
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:

Post by D¡cky »

justinkim wrote: That link redirects me to http://portal.tds.net/. You may have to zip it.

Try it now

conv_pm.zip
Have you hugged someone today?
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

Success! The new conv_pm.php file did it!
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:

Post by D¡cky »

Thank you for testing. The package will be updated tonight.
Have you hugged someone today?
justinkim
Registered User
Posts: 7
Joined: Tue Sep 20, 2005 12:34 am

Post by justinkim »

No, thank you for the converter and for getting me out from under the jackbooted heel of VB. :)
c_erck
Registered User
Posts: 6
Joined: Sat Aug 27, 2005 10:39 am

Post by c_erck »

The script has a number of issues...

For one you have a logic error / typo in conv_users at line 230

Code: Select all

			else
				if ($users_left == 0)
				{
					$users_left = $user_default;
				}
			{ 
				$sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left ";   // on the last pass only what is left 
			} 
should be

Code: Select all

			else
			{
				if ($users_left == 0)
				{
					$users_left = $user_default;
				}
 
				$sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left ";   // on the last pass only what is left 
			} 
This causes a number of users to be droped.

Another minor correction around line 131

Code: Select all

		$sql = "SELECT joindate FROM " . VB3_MEMBERS_TABLE . " where userid = 1"; 
Change to

Code: Select all

		$sql = "SELECT MIN(joindate) as joindate FROM " . VB3_MEMBERS_TABLE ; 


Forum conversion causes all sorts of problems since it's not regarding forum categories at all, but I haven't gotten that far yet.
Locked

Return to “[2.0.x] Convertors”