Ok guys..to fix this on a Cpanel server its really very easy. Just go into your Cpanel config, go into the mysql section of it. Then add your vbulliten user name to the phpbb database table.

Hope that helps any future problems you guys may have.

As for people who do not use Cpanel, then you can try to do it manually,or using phpmyadmin(please reffer to the documentation for that.)

If you don't have CPanel (which is sad, it is a wonderful tool, yet semi-expensive for the ISP), just email your ISP asking them to add your vBulletin mysql username to the phpBB database. The same username needs to be in both databases, just for the sake of the script, and PHP not handling multiple connections well.

And, I haven't tried it, but I have a feeling that can't be done with phpMyAdmin unless you had mySQL root-level access...because otherwise anyone could add their username to your database and steal passwords/delete it/mess around/etc...

thanks

I`ve installed this, and import up the the point where it imports the topics.

I get this error while importing 151-175 topics :

Database error in vBulletin Control Panel 2.3.4:

Invalid SQL: UPDATE session SET lastactivity=1075399389,location='' WHERE sessionhash='4e630efc1fd97e8b178daf1889565516'
mysql error: Table 'minim_xmb1.session' doesn't exist

mysql error number: 1146

Date: Thursday 29th of January 2004 06:03:10 PM
Script: http://www.ne-minimoto.co.uk/vb/vb/i...&anncExpire=30
Referer:

Anyone any idea? I tried renaming the table to no avail also.

Bugger it.

I used the official vB one, no problem...... Just gotto go through all me admin options ;)

The conversion runs fine until it goes to step two. Then I get...

Database error in vBulletin Control Panel 2.3.4:

Invalid SQL: SELECT COUNT(*) AS count FROM .phpbb_users
mysql error: Table 'timeslip_vbulletin.phpbb_users' doesn't exist

mysql error number: 1146

Date: Saturday 31st of January 2004 05:01:55 PM
Script: http://www.timeslipforums.net/import...ort_phpbb2.php
Referer: http://www.timeslipforums.net/import...ort_phpbb2.php


If anyone can help me it'd be appericated.
:)

Give up and use the official one, its easier, and works first time.

Any chance of supporting the (very common) attachment mod for phpbb? Pleeeeeease...

Just wanted to say.... AWESOME! I just ran through a test import and your script worked beautifully with no errors. Seeing as it was just a test run at this point I pretty much selected every option I could with the only one that didn't turn out too well being the phpBB2 styles... and that's no big deal at all. Oh, that's from a phpBB2 board with over 70+ hacks installed too btw.

So... will the vB3 version be ready by Friday? Just askin.... LOL Thanks for this Nebula.

Wow! That was too close to disaster for my liking. I ran a couple of test imports during the week just to be sure everything would be okay... and I thought it did. What I did not notice was that all the userID's were renumbered starting from 1. This means that every time a missing ID was encountered, all the users from that point on would change ID affecting everything across my site (user base is integrated with three other applications). To make matters worse, my backups from Friday were corrupt and I had to manually cut and paste all date back into the db.

I'm back to where I started now but can't seem to override the auto increment of user ID's. I've tried your importer (the better one IMO) and the jelsoft version, both with auto-inc disabled. Is there a way to import the usernames and keep them associated with current ID's in phpBB2? A perfect example is admin which is user 2 in phpBB but #1 in VB. Once I import I become "lilpinkpuppynoses" in my gallery, classifieds, and chat. I'm dealing with 8000 registered members here and do not want to go through renumbering each one individually if at all possible.

Nebula -- thank you so much for your time developing this. After reading the entire thread, I decided to not even try Jelsoft's converter and to just go with yours. With that said, here's my errors/problems to help further your development:

Based on phpBB 2.0.6 - vb 2.3.4. Databases on same server. I ran all utilities at end of install in the order written in the previous page (which is a diff order than they appear on that page -- that would be cool to change to match order they're supposed to be run in):

Rankings didn't transfer -- we had a bunch of custom rankings depending on number of posts, and that data didn't copy over.

Avatars that were images linked to other sites did not transfer. Avatars that were uploaded seemed to.

People who customized their signature all had [/siz] at the end of their signatures.

Admins didn't remain admins, except for the primary user who I opted to skip.

Question: Has anyone converted from phpBB to vb 2.3.4, then upgraded to vb 3.0 rc 4? I attempted this, and had a database error. I unfortunately didn't write it down (because I'm a chucklehead), so I'm not able to find out if it had anything to do with the conversion. I will probably wait for the final release of vb3 before I try again, as going through 80 pages of updates through all the betas and rc candidates really sucks.

Ok, thanks!

@Phenomenon

I had the same problems earlier before. Please read my post at vbulletin.com. Maybe do you have the same problems, I did deleted some tables - because the name 3 of them was the same as from the new vbulletin.

http://www.vbulletin.com/forum/showthread.php?t=91797

regards
Andreas

oh... interesting ok. Thanks Andreas

Hello,
i have a problem with this hack.
Ive installed vB2.3.5.

but i cant import my phpbb database.
following error:
Warning: main(../admin/bbimport.php): failed to open stream: No such file or directory in /usr/virtualweb/xxx.20.113.142/html/fh/importers/bbimport_phpbb2.php on line 6

Fatal error: main(): Failed opening required '../admin/bbimport.php' (include_path='.:/usr/share/php') in /usr/virtualweb/xxx.20.113.142/html/fh/importers/bbimport_phpbb2.php on line 6

before somone ask me weather i have the files in the correct directory, they are _all_ in the right directories.

forum/importers/bbimport_phpbb2.php
I think that this is the right directory, but it doesnt work...

can somebody help me?

MfG
Skyrunner

hi.

i just installed vBulletin 3.0.7 and I currently have a phpBB 2.0.11

I want to convert the database, and I've downloaded the file you give in this thread and made a new folder 'importers' and upload the file in there.

It's not showing in my admin cp though?

TonTon

This hack was for vB2. You are running vB 3.0.7, this hack will do you no good, on the contrary.

To migrate your phpBB better use the ImpEx utility you can download from your vb.com member area.

Oh, I hadn't noticed this was for vB2

Ok thanks.

this may be a dumb question but i cant find it in my admin CP pannel. I created an "importer" folder and uploaded the file but it is not showing on the left hand control pannel?? any ideas why? sorry for the newb question

This is an old importer created to work with vBulletin 2.

Unless you are using vBulletin 2, i suggest you have a look at ImpEx instead, which can be downloaded from the Members' Area.