hmm...I don't know how the conversion went smoothly if it can't connect to mySQL ;)

It looks like you need to specify a database username and password. Are you?

yes ofcource !!!
it showed some me like
...sucessesfull
....succsesfull
....done

then when the page is forwarded

then it showes the ^ above thread error

how many pages did you go through to get that far?

I think you're thinking about the page that says that it has connected to the database and everything. It has not actually begun the import.

I do have an experimental version out...did you get the version from the first post, or from another post within this thread?

i downloaded the first one but

it asked for databse name and table prefix

but i showed coluld not connect to the database by showing vbulletin username and pasword

one the second file downloaded from this thread
it asked for usename , pass, dataname and table prefix and when i cliecked import

it showed one page like this
...sucessesfull
....succsesfull
....done

and then it showed the above error ^^^error on the next page

my host said that php is in safemode ... do u think that has caused a problem ? :disappointed:

hmm...I guess I'm just having trouble understanding what your problem is. Send me an email through the vBulletin forms with a temporary admin username and password (if you don't mind me looking at it).

Also, I don't believe safe mode would cause any problems with that in the sense that you can't connect to mySQL. It will cause problems if the server is slow, and does not import very fast (PHP limits the amount of time a script can run). But if that happens, start over, and set the interval to a lower number.

Found this error after clicking the BEGIN IMPORT

Warning: Missing argument 1 for selectdb() in /usr/local/***/home/vhosts/****/httpdocs/****/importers/bbimport_phpbb2.php on line 1167
vBulletin 2.2.0+ « phpBB2 RC4+ Importer Importer Version 0.9.5.4 [Restart Import] - [Quit Import]

--------------------------------------------------------------------------------
Attempting to load phpBB Database ... SUCCEEDED
Attempting to load phpBB Data ... SUCCEEDED

Initializing vBulletin database ... DONE

Step 1 Complete...Redirecting...

Greetings.

I need to convert my 2.0.4 phpBB2 database to vBulletin 2.3.0. Since I'm new to the importer scene, I have a few questions.

1. Will the latest phpBB2 converter work from phpBB 2.0.4 to vBulletin 2.3.0?

2. Does it convert both user accounts and threads?

3. What happens if existing forum IDs in vBulletin conflict with forum IDs being imported from phpBB? Will the vBulletin forum(s) be overwritten?

4. Can I run the import once to test and then again to go live without encountering problems?

Thanks so much for your advice. I've heard GREAT things about the converter, but since I'm so new to it all I wanted to make sure I had all my facts going in.

- jj -

Yes.

Yes. Otherwise, what would be the point? ;) It also converts Private Messages, Forums, and other essential stuff too.

of course not. All new IDs are assigned to the things, and data is adjusted accordingly to work with the new IDs. It will only be overwritten if you choose to have it be overwritten.

Not exactly or directly. What you can do is create a separate installation of vBulletin, and then run the importer on the temporary installation. If you like the results, just proceed with the import on the production board.

Good luck. I hope it works out for you ;) If you encounter any problems, post them here.

Thanks Nebula. You rock... I appreciate the info. I'm going to get Photopost integrated and after a few days of beta-testing, I'll be ready to convert.

I really appreciate the advice. I will create a separate install of vBulletin (as you suggested) to test everything out on. I'll make sure and back the site up as well when I convert the production site.

Now that I know forums won't be overwritten due to ID conflicts, I feel much safer giving it a shot.

Thanks again bro.

- jj -

:: www.eq-boss.com/index.php ::

Nebula... did you ever address the following problem?

Thanks for the script.

Cool info to know Zenith. Thanks for the post.

:D

I'm getting ready to do it on my 62.5 mb database. And i sure hope it works!!!

Please help with this...
I am trying to import the data from a phpbb2 forum that is on a different physical server than my vbulletin server. When I try to run the script it cannot connect to my phpbb2 database. What do I need to change in the script so it will connect to the phpbb2 server
Thanks

Im getting this error, what am I doing wrong? I obviously changed the username to something else for this post....for security reasons.

0versight, there is an official phpBB2 --> vBulletin importer in the Member's Area over at http://vbulletin.com - Try using that importer.

I don't support two databases on different servers. mySQL does not handle multiple mySQL connections well. Please try putting them on the same server if at all possible. Talk to your host, maybe they can let you have two DBs for a few days. most hosts will let you ;)

Ive already got it sorted out thanks.

AssAssiN]Alright, I'll ask em. :lick:

AssAssiN]I'm trying to update the thread counters but I get this error...Please help Nebula!

hey all i got couple of questions first when i go to teh control panel and i look where it says 'Import & Maintenance' i cant find this 'BB Import Systems' i dont have it i upload everything the folder is there a ways i can do it please help thanks...

Everything went smoothly until importing the topics. I dont really care about the votes...any help would be appreciated. -mm

mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Bad SQL Syntax: SELECT * FROM phpbb_vote_results WHERE vote_id =
mySQL Said: You have an error in your SQL syntax near '' at line 1 (Error Number 1064)

Can't seem to get it to show up in CP either. Does this work with the new 3.0 beta vb?

Hi folks... I've got a few questions as I prepare for the big merge of two forums. I built a phpBB system and just purchased a site that is vB and I want to merge the two. But, my current site has a lot of custom pages that are content fed from the forum database... and I want to maintain my external links, google placement, etc.

Here are my questions...

1. Am I correct that this should work going from phpBB 2.0.3 to vB 2.3.0?

2. What does this importer do or not do, compared to the Jelsoft one?

3. I am going to have users that need to be merged... I believe you do that in the import, correct?

4. Here's the biggy. I want to create a couple of tables to use with a redirect script. One with phpBB topicid and vb threadid.. the other one with phpBB postid and vb postid. I will then replace the phpBB viewtopic.php with a simple redirect that pulls the topicid from the url, and redirects to the appropriate vb thread. I have many custom pages that will need this to. How hard would this be to do? Could you direct me to the part of the import code where I would need to make the mod... or better yet, would you be willing to add it? I've got to believe that other people could use this. I will donate my redirect scripts back, if you can add it to the import... so that its official. I'm a bit leary of messing with the import script.

Thanks.

OK, I ran the test and things look like they went well. The users merged fine. The only real problem I saw was that the user groups didn't get created, but I can redo that... no biggy.

So, my primary question is still the last one. Can I get some help grabbing the old topic and post numbers and putting them in a table with the new thread and post numbers (2 tables).

As an alternative, would this work?

I have concluded that there are roughly 100 missing topics in my phpBB database. I'm assuming that the import script moves them over sequentially, so if I create dummy topics, and then change their topic ids to the missing numbers, I should end up with a clean index that I can add to the old topic number, to get to the new thread number? Would this work?

Is there any danger of creating these dummy records? Should I create them as real topics and then change their id numbers, or should I just insert rows in the topic table? I'm guessing that I should create the topics with a dummy id, then I can purge the user's messages for that ID after very easily. Is there any risk of changing the topic ids?

This won't work for the posts because there are just too many of them, but I think that getting topics straight will solve most of my problems for now.

Thanks.

[fx]assassin: That's an error in vBulletin, though it's probably caused by my thing. But I don't know why that's happening. I'd go ask JelSoft.

No, this does not work with vBulletin 3.0 (any version). It is ONLY for vBulletin 2.2.x.

Read the hack info page, I believe it tells you what mine does and doesn't do. About Merging, mine supports merging, but ONLY if the usernames are the same. JelSoft allows you to merge users with different names.

mccollin: Yes, dummy topics should be fine. I wouldn't make them blank rows though, since they'll have to have the correct topic name and such. Make sure you know what you're doing. Backup the database.

OK, I went ahead and let it rip... a few problems to report...

Announcements - these are messed up. I would recommend that anyone planning to use this unset the announcement bit on those topics. I had two very long threads that were annoucements, and the import converted the original topic post to a vBulletin annoucement, and dropped the rest of the thread! Ahhh! I'm attempting to rebuild the two threads by copying and pasting them all in my id, then going into the database and changed the userid. Hopefully this will work.

Moved Threads - all of the moved threads that had a pointer in the original location left empty topics in the original location with a date of 1969. It was easy to prune them out when I figured out what had happened.

Private Messages - gone... don't know why, but none of them came over.

I tried the dummy topics to sync things up, but that didn't work. For some reason a few of the topics didn't make it and that hosed up my counts. Two of them were the annoucements... don't know what the others were.

There is no turning back for me.. the site gets too much traffic to turn it off and fool with the database. I'm trying to clean things up now after the fact. I guess I should have done more testing beforehand, but I didn't have much time.

dang. It works really well for some. I guess all I have to say is stick with phpBB until vBulletin3 goes gold/final, and they release an official importer.

I did do a redirect script which is working fine.

A couple of other things I've noticed.

Anyplace that I had a heading in something with bold and size=, it erased the heading, the bold, and the size, and left a single bold tag by itself.

And, some of the url tags got hosed up as well. It seems that anyplace the bb codes got complicated, I had problems.

Unfortunately, I didn't test this enough before pulling the trigger.

I am finding other odd data problems here and there, but as I said... no turning back at this point. I'll have to clean things up as I find the problems.

And, I'm not using vB V3, I'm totally on vB V2.3. Just do a lot of testing on this before you use it to make sure it will bring things over... and get rid of the announcement flag on any topics, because it totally killed those threads on me.

well, I do not reccomend doing this in a production environment (always do a test first ;)). Sorry it didn't work out completely for you though.

Man, my problem makes me sound stupid. I put the file in the importers folder, but it didnt even show up in the CP. - I got so fed up at one point I put all of vbulletins importer scripts and the file into EVERY folder and nothing. What could be wrong?

hmm...I don't know what to say about that...

you are using vB2, right? ;)

I'm having the same problem. I'm using vB 2.3.2, and it's not showing up. I made an importers directory in the main vB directory, and the file isn't showing in the importers list in the CP. Any suggestions on what I should do?

that folder importers should be in your vb folders ;)
edit: i run the phpbb import scripts, chose phpBB 2 and it say:

Warning: Unable to access ./config.php
in public_html/vbb/admin/global.php on line 96

what do i do ?

Hellooooooooo

I am new at VBulltin and I will like that one explains me how transferer my base of data phpbb 2.5 worms vbulltin 3.7 beta I do not speak and does not include/understand Englais well escusez me

Hi i am trying to import my database to vbulletin. My phpbb2 and photopost currently share the same database. and everytime i try to use the importer i get this error msg

mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Couldn't Select DB phpbb
mySQL Said: Access denied for user: 'vbulletin@localhost' to database 'phpbb' (Error Number 1044)
Date of Error: October 7th, 2003 at 11:52 PM
URL of Script: /forum/importers/bbimport_phpbb2.php
Referring Page:

Any help is greatly appriciated

fyi an offical db importer from vbulletin.com is avliable

mine does a lot more than the official importer ;)

your problem is that the mySQL username/password need to be able to access each database. currently, your username for the vBulletin database does not have permission to access the phpBB database. Talk to your webhost if you don't know how to do this yourself.

I've been getting this error:

"mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Couldn't Select DB snake_xmb1
mySQL Said: Access denied for user: 'snake_vb@localhost' to database 'snake_xmb1' (Error Number 1044)
Date of Error: January 23rd, 2004 at 2:47 PM
URL of Script: /forum2/importers/bbimport_phpbb2.php
Referring Page: "

Any idea why? Or how to fix this?(Sorry if its posted elsewhere, I just didn't want to spend the time looking around for it)

Ok, I see you had a post on this...hmm i'll try something and be back..