PDA

View Full Version : phpBB2 Importer


Nebula
07 Apr 2002, 22:55
Heya everyone. This is a beta release of my importer that converts phpBB2 (RC4 or greater) into vBulletin. It should convert into vBulletin 2.2.0 or greater.

To install the script:
[list=1]
Download bbimport_phpbb2.php from this post (You can only download it if you have entered your username in the vBulletin Members Area, DO NOT PRIVATE MESSAGE ME ASKING ME TO SEND IT TO YOU!!)
Open your FTP program of choice, and upload it to the /importers directory in your vBulletin folder (You may need to create this folder if you have never run an importer before)
Log into your vBulletin Control Panel
On the left navigation pane, find the 'Import & Maintenance' section, and click on 'BB Import Systems'
In the page that loads, select 'phpBB2 RC4+', and click 'Begin Import'
Follow the instructions from there
[/list=1]
Post your results here! Let me know anything that goes wrong, or your success story ;)

Current Version: 0.9.5.2

Chen
08 Apr 2002, 14:48
Good job! Always good to have more importers, especially for phpBB2. :)

Nebula
08 Apr 2002, 20:30
no problemo. I need it tested though. Can you remove the '(BETA)' part in the thread name though? I can only edit the post subject. And, since it's in the beta forum, it goes without saying ;)

Steve Machol
08 Apr 2002, 20:57
Done! :)

Nebula
08 Apr 2002, 21:00
Ah, thank you ;)

BTW...sweet avatar smachol!

Steve Machol
08 Apr 2002, 21:01
Thanks!

Nebula
08 Apr 2002, 21:49
Version 0.6 is out. vBulletin was being picky with reuploading a new file with the same name, so it's now zipped. Here's a changelog:


Fixed theme prefixing not working
Added option to skip import of SubSilver Theme
Added option for admin to choose what style users see on their first visit
Table Prefixing now works correctly
Gallery Avatars can now be imported


Enjoy ;)

Chen
09 Apr 2002, 12:51
Is there a stable vB to phpBB importer? Maybe I can test this script using that.

MrBojangle1
09 Apr 2002, 21:21
ya at http://www.phpbb.com/downloads.php at the bottem its stable, of couse it doesnt do the attachments, yet to look into it,

DemiNeo0101
09 Apr 2002, 23:54
Nice job man. I'm going to try this on cheatlist right now :)

Nebula
10 Apr 2002, 20:44
hehe, lemme know how it works out ;)

plauderer
10 Apr 2002, 20:51
I use phpBB2.0 Gold and I have this error:

Script That Crashed: phpBB2 Importer
Script Returned: Bad SQL Syntax: SELECT * FROM themes ORDER BY themes_id ASC LIMIT 0,10
mySQL Said: Table 'db34382616 .themes' doesn't exist (Error Number 1146)
Date of Error: April 10th, 2002 at 9:47 PM
URL of Script: /importers/bbimport_phpbb2.php
Referring Page:

Table Prefix are _phpBB and I type this in the importer script! Now I see db34382616... its the name of the database ???

???

Plauderer

Nebula
10 Apr 2002, 21:15
Hmm, lemme get this straight:

Your table prefix is: '_phpBB'

okie, I understand that much. It looks like there's a trailing space at the end of the database name, you may want to check that. Or, it could be how vBulletin saved the data :p

::skimms through code::

ah, found the problem. Expect a new version in a few minutes...sorry about this...

Nebula
10 Apr 2002, 21:29
Here's Version 0.6.3. What's changed:


Table Prefixing should now work
Added version indicator at top of every page
Fixed Minor HTML Bugs
Optimizations here and there


Lemme know if this version works ;) ;)

BTW...FireFly, there's a bug in the re-uploading thing. You try to select data from the 'attachmentid' table. I think you went to fast while coding that :-P

rochen
13 Apr 2002, 00:26
I just tried this and when it comes to the styles import section I get this error

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: INSERT INTO style (styleid,replacementsetid,templatesetid,title,userselect,importstyleid) VALUES (null,19,1,'phpBB2 - subSilver
mysql error:

mysql error number: 0

This is on version 2.2.5.

Even if I opt to not import the styles it still gives me this error. Any ideas?

Nebula
13 Apr 2002, 01:10
Ugh, put a comma instead of a period when executing the query ;)

Expect a new version soon (one that imports polls and (hopefully) announcements, whee! ;)).

Nebula
13 Apr 2002, 03:56
Version 0.7.1 is released! Here's a more-or-less complete changelog (forgot to keep track):


Topic Polls now import
Forum Announcements now import
Started work on not importing users if their username is already in the database
BUG FIX: Bad Style Import query
BUG FIX: Would not skip subSilver even if requested


That's it. Download it ;)

Timmmmmy
16 Apr 2002, 20:54
I tried to use this import script but i get this error


Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT title,styleid FROM style ORDER BY title
mysql error: Table 'ama_phpbb2.style' doesn't exist

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:03:38 PM
Script: http://www.allmadden.hwgn.net/forums/forums/importers/bbimport_phpbb2.php?s=&action=users&iuser=allmadden&ipasswd=67amtyg&iserver=localhost&idbname=ama_phpbb2&iprefix=phpbb_
Referer: http://www.allmadden.hwgn.net/forums/admin/?


It gets to step step three then right below it says the error above....i can take a screen shot if need be

Im using phpbb2 gold (final release)

Ive also tried it with RC4

the phpbb forums are located at:
phpBB2 (http://allmadden.hwgn.net/Forums)

VBB 2.2.5
VBB 2.2.5 (http://allmadden.hwgn.net/forums)

Nebula
16 Apr 2002, 21:03
I think you messed something up. (Or, I'm not feeling well, read note#1)

In vBulletin's config file, it should point to your vBulletin database. From what it looks like, the vBulletin DBwrapper is giving you an error, and you're trying to access a database labeled 'ama_phpbb2'. That's the only thing I can think of. Make sure in your vBulletin config file, that you enter the correct settings for your vBulletin database, not your phpBB database.

You enter your phpBB details when you run the importer.

NOTE: I'm not feeling well (I have some form of heat stroke), it's really hot here in Michigan!

NOTE #2: A new version is on the way. Everything is perfect, and ready to be released, except the BBcode routines. I'm having lots of fun with converting size tags. phpBB measures font size in pixels, and vBulletin measures in points, or something other then pixles. Maybe a new version will be out tonight or tomorrow.

Timmmmmy
16 Apr 2002, 21:19
I can assure you the problem isnt with me, ive dont this about 15 times or so. The MySQL error im getting is whats throwing me off. Its looking for

mysql error: Table 'ama_phpbb2.style' doesn't exist

now im not sure, if thats in the vb db or the phpbb db? does that makes sense?

I think ill try to create a ama_phpbb.style in the vb forums, otherwise ill just wait until your final release....anyways hope you feel better, and thanks for the quick reply!

I used to have access to my db, thru phpmyadmin, but i lost the URL my host gave me. Im waiting on a email back from them.

I created the style ama_phpbb2 and it didnt work

I know it was a crazy idea lol

I then selected to quit at the top right hand corner and i get these errors...


Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site50/web/forums/admin/db_mysql.php on line 195

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site50/web/forums/admin/db_mysql.php on line 154

Warning: Cannot add header information - headers already sent by (output started at /home/sites/site50/web/forums/admin/db_mysql.php:195) in /home/sites/site50/web/forums/importers/bbimport_phpbb2.php on line 167


Since my host is getting ready to move servers its all just playing ground for me right now anway...so any help today would be cool if not ill just wait

PS
Database info is

usr: allmadden
pwd:*******
db name: ama_phpbb2
prefix:phpbb_

I have to change them to lower case for both the db and bb from what the control panel gives me, because its not right. if that makes sense

Nebula
16 Apr 2002, 21:30
...

All I can think of is that you entered your phpBB details inside the vBulletin database. That's the ONLY way you could be getting errors about a phpBB database through the vBulletin wrapper.

If you want to give me FTP access, I can check it out. Email me the details if you want, don't post them here, for obvious reasons.

Timmmmmy
16 Apr 2002, 21:53
you can have all the access you want lol i can change the pwd when your done do you have icq?

Timmmmmy
16 Apr 2002, 21:59
i added you to my icq or at least requested that you let me lol..i also sent you an email with the info you requested......just let me know what else you need...if you need access to the board i can do that too...whatever you need let me know thanks again

James5mith
16 Apr 2002, 23:01
I'm trying to convert my phpBB2 forums over to vB.

I don't care about styles.
I don't care about smileys.

All I want is my user information and threads transferred over.

I cannot get that far though, because the converter keeps erroring out on trying to transfer over the styles, and then the smileys.

I have set the converter script to:

Do Not import subsilver
Do Not import smileys
# of styles to Import: 0

It's still giving me errors.

Any suggestions?

*Edit:

I'm at step 3.

Options:
Should I skip users who's username is already in the database? (Not Complete)
Yes

Would you like me to import avatars?
No

What style should the users have by defualt?
(There is no option to chose at this point, is this the problem?)

Then I get two error windows below, and cannot proceed:


Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT title,styleid FROM style ORDER BY title
mysql error: Table 'sbf.style' doesn't exist

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:04:55 PM
Script: http://www.spaghettibasgetti.net/vb225/vb225/admin/bbimport_phpbb2.php?s=&action=users&iuser=root&ipasswd=server&iserver=localhost&idbname=sbf&iprefix=sbf_
Referer:



Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE session SET lastactivity=1018991095,location='' WHERE sessionhash='f84f112c57569ed34494c5bff4bd8d1e'
mysql error: Table 'sbf.session' doesn't exist

mysql error number: 1146

Date: Tuesday 16th of April 2002 03:04:55 PM
Script: http://www.spaghettibasgetti.net/vb225/vb225/admin/bbimport_phpbb2.php?s=&action=users&iuser=root&ipasswd=server&iserver=localhost&idbname=sbf&iprefix=sbf_
Referer:

Timmmmmy
16 Apr 2002, 23:05
Well im not an expert, nor do i have your answer but those that can help, would probably like to know what errors your getting. Its like going to get your car fixed and saying its broken lol....sorry...kinda frustrated myself...im probably getting the same errors as you lol...i try no to everything, i just want my forums as far as the layout with categories and forums...the posts and the users not to much to ask lol i did talk to Nebula i gave him some info so hopefully he can fix it :)

James5mith
16 Apr 2002, 23:14
^^ ;)

After going through it about 5 more times, that same error keeps appearing. At every step.

Even though the import script will continue past the first two steps, at the bottom of each page is a window with pretty much that exact error.

DemiNeo0101
17 Apr 2002, 13:13
time to give this script the stress test. I got a phpbb with a 150 meg DB that need to merge with me vbb. :) I'll tell you all how it comes out.

Http://forums.cheatlist.com

Nebula
18 Apr 2002, 02:51
ugh, sorry for not replying for a while.

Due to current complications in my already busy live with my brain running at 1000% normal capacity, I don't think I'm going to have time for this for a little bit. I'm going to work on it this weekend, someone email me so I don't forget, LOL ;)

James5Smith: I don't know what's wrong, I'll look into it this weekend.

Timmmmmy: My brain's running fast enough already, I'm planning on working on your DB this weekend.

Timmmmmy
18 Apr 2002, 21:53
Hey dont worry about it man, i went on without it.....i manually registered people LOL I only have arround 30 members, i just did a copy and paste job, and told them if there are any posts they want saved to copy them over....thanks though

Nebula
21 Apr 2002, 22:45
Version 0.9.1 is out!! Here's a changelog:


BUG FIX: Options would not take effect until you entered the config page in the vB Control Panel, and saved configuration.
Added option to skip importing a user if their username is already in the database
Removed duplicate moderator detector, because vBulletin's import routine has it built in (doh :p)
Special Forums now import
BUG FIX: Script would not pause while smilies were imported
Added links during pause so that you could modify individual items (links only appear if you elect to pause)
BUG FIX: Would import thread subscriptions even if asked not to


Go download it. The script looks pretty much complete. I want to rewrite some of the parts the user sees, but I think all the bugs are gone. Please help test this almost complete version!! ;)

Nebula
26 Apr 2002, 12:41
Version 0.9.3 is out, here's a changelog:


BUG FIX: Invalid function 'iff', should have been 'iif' during style import
BUG FIX: Configuration Import would crash if you hadn't banned any users


Go download it. This is one step closer to a final release.

erdem
26 Apr 2002, 20:19
uhm it gives me errors!

mysql error: Table 'erdem_trojan.session' doesn't exist

where erdem_trojan is my db name

Nebula
26 Apr 2002, 20:26
could you provide more information?? Like what step are you on???

erdem
26 Apr 2002, 20:46
uhmmm i find the solution!!!
tnx nebula!
i backup my old forum and import into same db as vb2.. it works now..

and some offtopic que but i hope u can answer it:
i download silverstyle.. it includes images and style.php howto install this?

and tnx for importer! it rocks!

Nebula
27 Apr 2002, 02:08
Hmm, I'm not sure I understand what you're saying about the silverstyle. Is it for phpBB??

fury
28 Apr 2002, 23:57
To get this to work, I had to have phpBB2 and vBulletin in the same database.

Because when I tried to do the import with the following configuration

phpBB2 database: conversion_phpbb2
phpBB2 prefixes: phpbb_
vBulletin database: conversion_vbulletin

It tried to access vBulletin tables from the phpBB2 database (e.g. "smilies", "session", etc.) and I couldn't get anywhere.

Also, it didn't convert closed threads properly, and it stuck a thread that I didn't have stuck in the phpBB2 test forum. Just thought I'd let you know.

Pretty good effort, man. Thanks for this contribution to the vBulletin hacking community :)

Sketch
29 Apr 2002, 21:34
I'm now a subscriber! Whoo! :D

So, I'm going to try to upgrade my phpbb2 Final bulletin board to vB 2.2.5....wish me luck. :D

Sketch

Sketch
30 Apr 2002, 02:07
Okay, found a bug and I emphasize A bug...just one. Everything was hitcless! Very very good.

The one bug I found was when trying to import Arty O'Connell in as a user. Not sure if it was the space or the ' that did it, but I just changed his name in phpbb to arty did the import, changed it back in phpbb and then changed it in vB, but I imagine if I had thousands of users that might constitute a problem.

Thanks again.

Sketch

Nebula
30 Apr 2002, 02:33
Fury: This seems to be something wrong with certain versions of PHP or what not. It works fine for me, I don't know what to say, other then to merge the two DBs, which you seem to have already done ;) Also, to say the least, phpBB works very...odd...to say the least. I don't know why closed and stuck threads aren't working well, could you send me your DB?

Sketch: I can't imagine why that username messed up the script, it the vBulletin library SHOULD addslashes as necessary. Mind sending me your DB? :speechless:

LOL, sorry I can't be of any help, you guys stumped me :rolleyes: :hurt:

Sketch
30 Apr 2002, 02:39
Nebula, no big deal, man. Addslashes will kill everyone and I wish the whole concept would be killed, but we are stuck with it and it has its uses. I imported no problem other than that one hiccup. Thanks.

Sketch

Sketch
30 Apr 2002, 06:21
***EDIT***
Forgive me if I double post, I sent an email to reply and I don't know that I did it right because I am not seeing it appear, so I am doing a direct post

Hey, and one other thing...

Some of the BBcode doesn't translate over to VBcode. Not sure if you can even fix that as it would, in essence, be a find/replace in the db. The trick code is, in bbcode: yada yada yada and in vbcode, it should just be [quote]yada yada yada[/ quote]... [/code] You know how that could be fixed?....a nicely written preg regx :)

Good luck.
Sketch

Koneko
07 May 2002, 06:02
Ok, i'm having some problems with this.

Here's my error:

----------
Attempting to log onto phpBB Server ... SUCCEEDED
Attempting to load phpBB Database ... SUCCEEDED
Attempting to load phpBB Data ... FAILED

Sorry, but I am unable to load some phpBB2 data, although I was able to connect and select the database. Please click back, and make sure you set the right table prefix.
----------

I think it's because of the phpBB2's mySQL Table Prefix? How do I find out this information?

setroxhq
07 May 2002, 10:22
Koneko i have same problems too..

how is correct it?

please help :)

Attempting to log onto phpBB Server ... SUCCEEDED
Attempting to load phpBB Database ... SUCCEEDED
Attempting to load phpBB Data ... FAILED

Sorry, but I am unable to load some phpBB2 data, although I was able to connect and select the database. Please click back, and make sure you set the right table prefix.

Nebula
07 May 2002, 12:15
I didn't think [quote=] tags worked like that in phpBB2. ::makes sticky note and puts on compie::

I'm redoing the BBcode thingy, because it's really crapping up some DBs that don't use BBcode perfectly (forgetting to close tags, etc...

Anyways, blabla, expect a new release this weekend, or today, or whenever I have free time...school is getting hard this last month :dead:

EDIT: You find out your table prefix in the phpBB2 config.php file or whatever.

bensonfactor
12 May 2002, 19:54
It worked for me expect the passwords got screwed up. I had to put the databases in the same database name and then had to proceed with the import.

Although it was a lot easier than doing it myself like I did from Ikonboard to Phpbb2,

Thanks for this importer.

maxchang
13 May 2002, 11:33
Excellent!!

It also works on Chinese language!!

But my user lost their password. How can I do??

Byron
27 May 2002, 07:49
Hello,

I want import a phpBB into our latest vb.


1) Will this importer work on the latest version of phpBB?

2) Will there be any broken images for the avatars or smiles?

3) Any problem with the BBcode?

4) Are all your members able to log in after your import?

(I read that some of you are having problem with your users passwords.)

5) Are there any other problems?


Thank you.

Nebula
27 May 2002, 11:47
Sorry I haven't been around much (life is hectic as I'm closing up school). Byron, here are some answers:


Will this importer work on the latest version of phpBB? Yes
Will there be any broken images for the avatars or smiles? Avatars? No. Smilies? Only if you don't move them into your smilies directory.
Any problem with the BBcode? I've got a brand new BBCode convertor in the next release, works much better ;)
(I read that some of you are having problem with your users passwords.) I have fixed that in the upcoming release. Sorry about that!!
Are all your members able to log in after your import? Yes, of course!
Are there any other problems? If there are, people haven't told me ;)


Also, other problems that I have fixed are typos across the script, and the problem with vBulletin trying to read phpBB databases from the vBulletin database, or vice versa. New release soon if I can get enough time.

jimmy mac
03 Jun 2002, 22:08
ok i've encountered a problem. hopefully it has an easy fix.

i'm on i think the second step of the import. where it's trying to import my users. i get this erroron the first person it tries to import:

Importing User jimmy mac ... Fatal error: Only variables can be passed by reference in /home/www/angryfinger/vbulletin/admin/bbimport.php on line 622

jimmy mac
03 Jun 2002, 22:39
i am using vB v2.2.6 that may have something to do with the problem.

Nebula
04 Jun 2002, 21:04
Sorry, but I guess I have no choice but to not completely support this anymore, seeing as vBulletin has completely wasted all my time and effort I put into this. :hurt: ARGH!!!! Poop on you vBulletin.

I guess if you're still having problems with this, go try vBulletin's "official" importer.

This would have been done a long time ago, but I got real busy with school, and obviously vBulletin took the chance, and ran with it.

::screams:: :dead:

Oh well, can't win them all. Just so you know vBulletin, I hope you feel good about your importer. :disappointed: :mad:

CodeDawg
05 Jun 2002, 08:39
Don't give up the support yet!!!! I have had much more success with your importer than the official one from vB.

I am getting one error, but I think it may be my database or something:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO pollvote (pollid,userid,votedate) VALUES (1,,985364649)
mysql error:

mysql error number: 0


No clue what is wrong with this particular post, but it is causing the conversion to stop. I know from the ohomyadmin I just ran it doesn't like the datestring.

Any help?????

Nebula
05 Jun 2002, 12:27
well, it's nice to know SOMEONE appreciates what I do.

I will be able to work on it tonight, since I will have plenty of time (my last final was yesterday). No more homework for 3 months!! ;)

CodeDawg: I'll look into this tonight.

CodeDawg
05 Jun 2002, 17:18
Well I kinda got around that issue by setting all the polls to "inactive"

THen it hung up on me last night, then the web server died...so I will give it another go tonight and see what happens...will keep you posted.

Just so you know, the official version doesn't convert nearly as much as your script....but the vB guys did fix an error I found in theirs at 2:30 am.

CodeDawg
05 Jun 2002, 23:51
Nebula:

I got the script to work, didn't convert the polls. Had a bunch of post come through as sticky, but fixed that fairly quickly by doing an update on the threads table and turning off all sticky post....then simply went in and made the 10 or so post that needed to be sticky.

One idea that maybe you and someone over at vBulletin.com might want to look at is merging the two scripts. I tried to use both and found that yours was far more detailed in what it converted, but was missing some key things that the official one had.

I have been up for about 22 hours trying to get things converted and running so I will post some detailed ideas for you once I get some sleep and a clear head.

I do have to say THANKS!!!!! to you for creating this script...even with the glitches I ran into it did a MUCH better job than the official one from vB. :nervous:

NeRilkA
08 Jun 2002, 17:23
hi :)

i just want to thank Nebula for this wonderful script !! which works great !! and helped me a lot

the official team of vbulletin should replace their script by yours !!!

thanks again !!!

Nebula
10 Jun 2002, 17:34
Hey! Version 0.9.4 is out (finally :P). Sorry it took me so long for an update, I was really swamped with homework at the end of the year.

Anyways, here is a list of updates:


Script now only works if the vBulletin database and the phpBB database are on the same server (caused too much trouble and bugs)
Fixed bug with database switching (script would try to read phpBB data from the vBulletin database or vice-versa)
Fixed poll import bug (Thanks CodeDawg)
Fixed thread sticky bug
Improved BBdecode routine
Many other things I've forgotten about :D


I also tried the official vBulletin importer, and I must say, I don't like it ;) Mine's a lot more user friendly, and it importes much, much more ;);)

Sorry about the sticky bug...I feel really stupid, here's what was wrong (for you PHP Guru's):


// What it was
if ($threadData[topic_type] == 1) {
$thread[sticky] = 1;
}

// What it should be (and is now)
if ($threadData[topic_type] == 1) {
$thread[sticky] = 1;
} else {
$thread[sticky] = 0;
}


Basicially, if one thread was sticky, every other thread was made sticky after that until a new page loaded. I think I was asleep when I coded that ^^;;;;

Anyways, enjoy. I ran this a lot this morning, and believe it to be bug free with every DB I've ran it on so far. Hehe. If you have a problem with your DB, send it to me, and I'll fix it up in a jiffy ;)

EDIT #1: I renamed the actual importer filename, so that you could store both the official and unofficial script in the same directory (the vBulletin one is stupid, and doens't like being renamed, yet mine doesn't care if it's renamed. Another reason mine is better ;)).

EDIT #2: I moved the attachment to the first post. I forgot that's where I put them, lol

CodeDawg
10 Jun 2002, 18:14
Nebula,

Thanks for the updated script. I will download it tonight and give it a try.

dieKetzer
11 Jun 2002, 03:38
I used your importer quite a while ago and had great success with it. I'm sure that there are many others that are happy and thankful to you for releasing this hack. For many, waiting many months for vb to release an 'official' importer was not an option :o)

Brad
12 Jun 2002, 22:00
Nebula, ran with great results on my local system with a phpbb2 to vB 2.2.6 import.

Nebula
12 Jun 2002, 23:04
Also, for those of you who may be wondering, I have checked the upgrade for vBulletin 2.2.6, and there are no schema changes or data handling changes, so this script is fully compatible with 2.2.6. As for phpBB 2.0.1, I think it should be fine. However, I'd appreciate any testing you guys could do. Thanks!

Also, if nobody submits any bug reports, this will be the version I'll submit to JelSoft. Maybe they can combine mine and theirs? I dunno if they'll even use it. I hope I'll get something for my efforts, lol.

I am also in the process of rewriting all the messages users see. Hopefully, it'll be easier for people to understand. We'll just see ;)

Nebula
12 Jun 2002, 23:21
oops...I guess my script isn't as cool as I thought. You will have to rename it to bbimport_phpbb2.php...

I'll repack it in a few minutes...silly me ;)

Nebula
13 Jun 2002, 00:07
there, file repacked, go download! ;)

I also added in a filename checker that checks if it's named correctly.

CodeDawg
14 Jun 2002, 04:28
Worked great Nebula....only one thing I noticed and may be only me: I have a few custom/private user groups....the script did not import the users of those groups into the groups in vB.

Is this something you can fix (thinking that if you imported the usergroups BEFORE the users it could be done)?

I don;t know php well enough to even attempt this on my own so am hoping that you can come up with something that may work for me.

Thanks a ton for all the hard work you have put into this...it really kicks the "official" converters arse!!!!!!

Nebula
17 Jun 2002, 19:59
hmm...user groups? I know what they are, but never thought of importing them...

CodeDawg
18 Jun 2002, 05:34
Yeah, basically as an example: On my site I have a group for folks from Colorado. They have access to a private forum. The convertor creates the user group, but it doesn't import the users of that group. I believe this is beacause the user groups are added AFTER the users are imported.

It's not a huge deal, but if you think you can work something out by Friday when I plan to do the official conversion for my forum that would be awesome. If not then I have already alerted my users that they will have limited access to that area until I can add them back into the group.

If you would like a copy of my DB to use just let me know.

Again....THANK YOU SO MUCH!!!!!! Your convertor kicks butt!!!!!!!

Nebula
18 Jun 2002, 13:45
Yes, I've heard people saying user groups aren't importing. I'm not surprised, since I never planned to code that.

But, I guess it's not a problem. It's just one more thing I have to learn from stupid phpBB2 ;)

KingsFan
19 Jun 2002, 21:30
Nebula,
I have used both your script and the officail one and I've got to agree with everyone else that yours is superior but I have had a few problems.

1. The major one is that passwords don't get converted correctly. I'm not sure why but they are all jumbled and no one can login with their old passwords. This is true for imported users only. Users that were already in the database before the import can login, but their password is copied to the email field and visible.

2. For some reason Avatars don't get converted for me.

3. The "quotes" don't appear correctly. phpBB uses a tag like[quote=username] and vB doesn't like that.

I could live with 2&3 but is there anyway to look into the password problems?

Thanks!

Nebula
19 Jun 2002, 23:38
WOAH...:eek:...as I look over my code, I realize I didn't fix the password problem. I know it was fixed at some point...hmm...I'm currently in the process of setting up a computer for a friend, but I'll re-add support ASAP, and rebuild it.

For the avatars, I've had problems with that, and that'll be outa there by the next release.

Also, I'll update the code routines to support [quote=username].

Again, I have no clue how the new password support routine disappeared :eek:

CodeDawg
20 Jun 2002, 18:19
Nebula...any timefram for the fixes KingsFan found? I was goign to do the actual conversion on my site tomorrow night, but want to wait for the passwords thing to be corrected.

Nebula
20 Jun 2002, 18:53
it is fixed now. Sorry about that. Current version is now 0.9.47.

CodeDawg
20 Jun 2002, 23:46
Sweet!!!!! Any thoughts on when you might be able to look at the user group issue I brought up? No hurry, I have already made plans to move my members over myself, but it would be nice to see that taken care of.

Nebula
21 Jun 2002, 01:07
Hmm...I will look at how phpBB UserGroups work right now. I don't know if I'll be able to implement anything, but we'll see how it goes ;)

Nebula
21 Jun 2002, 01:29
UGH...talk about confusing...:dead:

Geez, I can't really make out how phpBB user groups work. It totally confuses me, LOL. If someone tells me how the @#$@#$% group system works, I will definately code something. But as of currently, I don't see how groups can be allowed/disallowed, just if they can be set as moderators or not.

Sorry, but as of now, I don't think I'm going to add support. That will change if someone tells me how it works, LOL.

CodeDawg
21 Jun 2002, 02:24
HEHEHEHEHE, no problems with that. I have no clue on any of the php coding so I can;t help ya. As I said, it would be cool if you could figure it out, but I can move the users to the group by hand after the conversion is complete.

Thanks for looking into it though.



Originally posted by Nebula
UGH...talk about confusing...:dead:

Geez, I can't really make out how phpBB user groups work. It totally confuses me, LOL. If someone tells me how the @#$@#$% group system works, I will definately code something. But as of currently, I don't see how groups can be allowed/disallowed, just if they can be set as moderators or not.

Sorry, but as of now, I don't think I'm going to add support. That will change if someone tells me how it works, LOL.

NietzscheKid
21 Jun 2002, 17:20
hello

i am a complete newbie and just purchased vbulletin and would like to convert my current phpBB2 board to vbulletin.

the big concern i have, are the following:

- i have tons of mods installed on my forum. does this affect the conversion in any way?

- i run phpBB2 version 2.0.1 (is this one also compatible with your script?)

- i have a huge DB (about 40 MB), about 500 members and 10 k posts and i cannot afford to lose any of them (posts and users)

- my host runs in safe mode (is it ok with the script?)

thank you for any suggestions :classic:

oh and i have some really dumb questions to add:

- where do i place the folder 'import' or is it 'importer' ? do i put it in the admin or the vbulleting root?

CodeDawg
21 Jun 2002, 23:13
My DB is like 30 MB, 2800 users and over 30000 post...the converter handled it just fine.

Also was running phpBB 2.0.1

The mods shouldn't affect the conversion....it is only converting the database, not the files

Not sure about teh safe mode, but I would imgaine it would work

And put the importer folder in the vbulletin root directory.

CodeDawg
23 Jun 2002, 01:02
Nebula,

Ran the convertor last night and everything worked smooth as silk. Thakn you so much for providing this great script and making my life a lot easier.

TLfuRy
24 Jun 2002, 14:41
This script worked great! I went from XMB 1.6 to phpBB 2.01 to vBulletin 2.2.6. :D My only issue with the conversion is that many of my users now have private messages that do not belong to them, both in their inbox and sent box. I'm not sure how I can fix this without deleting all private messages from the database?

Chad Beattie
20 Jul 2002, 16:59
The script works very well. I only had it hang on one post, which I then deleted. After that, everything was imported fine. The only issue I am having is with private messages. I am looking at the bbimport.php and bbimport_phpbb.php to see if I can figure out why messages don't end up in the correct boxes. If I can't get it figured out, I will probably just tell my users I will be deleting all PM's before our conversion. I would hate for something to show up in someone's box that they were not supposed to read :) But, that is very minor in comparision to how well this script works. Thank you very much for all your work. I was dreading switching boards because I was afraid of the conversion.

Keep up the good work.

ZenithRS
23 Jul 2002, 00:06
Nebula... good work dude. I have a phpBB2 forum which I'm looking to convert over to vBulletin so decided to test your script out on a test server. The import worked fine with the exception of the following...

a) For some reason there was a post with a poll that caused it to crash out. The Jelsoft importer fell over at the same point. Once I deleted that post the import carried on successfully. I'm not sure why it was falling over, but the sql query it was executing was trying to select null id's.

b) Private Messages seem to have all imported OK, but just looking at my own in and out boxes there are quite a few that are identified with the wrong username. i.e. the message is meant for me but the from user displayed is incorrect. This is strange because some are in fact correct.?!?! This is not a biggie, as others have said I can just delete the PM's before import, but would be nice to see it work too :)

c) Avatars don't seem to be importing at all. No errors reported.

Again, good job. Keep it up :banana:

Cheers

Z

ZenithRS
23 Jul 2002, 09:27
I've worked out the problem with the Private Messages import. At some stage in the history of my phpBB2 I've deleted a user which left a gap in the sequence of userid's. In this case it was userid 18. The import script doesn't allow for this so phpbb userid 19 gets entered into the vbulletin as userid 18 as 18 is the next available spot...the field must be set to auto increment and the script doesn't "notice" the jump in phpbb's userid's.

I created a dummy user on the phpbb2, and then changed it's userid to 18 to fill in the gap in the sequence. Then ran the import script again. All the private messages are now associated with the correct user ids.

This explains why some had problems with the PM import while others didn't. I haven't delved into Nebula's code to find out why it does this, but I'm sure it will be a simple fix.

Hope this helps.

:banana:

Z

b.richards
23 Jul 2002, 17:36
Wow . I REALLY appreciate this script. Many blessings to you!

Chad Beattie
23 Jul 2002, 21:53
Originally posted by ZenithRS
I've worked out the problem with the Private Messages import. At some stage in the history of my phpBB2 I've deleted a user which left a gap in the sequence of userid's. In this case it was userid 18. The import script doesn't allow for this so phpbb userid 19 gets entered into the vbulletin as userid 18 as 18 is the next available spot...the field must be set to auto increment and the script doesn't "notice" the jump in phpbb's userid's.

I created a dummy user on the phpbb2, and then changed it's userid to 18 to fill in the gap in the sequence. Then ran the import script again. All the private messages are now associated with the correct user ids.

This explains why some had problems with the PM import while others didn't. I haven't delved into Nebula's code to find out why it does this, but I'm sure it will be a simple fix.

Hope this helps.

:banana:

Z

Hmm. That helps a bit. I know I have created test users in the past and then deleted them. So that is probably why I am seeing this. Well, I hope you find it, that will be nice to get working. But really nothing to much to worry about. Now that you mention it, I don't think my avatars came across either. I was too busy trying to find the post it hung on and then also the PM issue that I didn't pay attention. Anyway, thanks for the info.

Scott MacVicar
25 Jul 2002, 03:07
An official phpBB2 importer has been released at http://www.vbulletin.com/members/

ZenithRS
25 Jul 2002, 03:24
Err.. yeah, but it's not as full featured as Nebula's, which I think was the point of this thread.

BTW, I've also come up with a small script that converts the quote="username" format of phpBB2 to vBulletin's standard format if anyone's interested in it. It's stand alone and can be run after the import.

Cheers

Z

Scott MacVicar
25 Jul 2002, 16:04
The one in the members area does Members, Forums, Threads and Polls

Chad Beattie
26 Jul 2002, 17:33
But still, I think you are missing the point. If you read through this thread you will see everyone that has used the official one thought it was horrible. I can vouch for that. I tried it first, and I was very dissapointed. I purchased vb a week back and my biggest concern was converting my phpBB board over to vb. I would have to say if the only thing available at the time was the offical convertor script, I would have been kicking and screaming to vb asking why they could call a script an 'official phpBB convertor' when it does a horrible job. The script posted here works great. Sure, a couple of things my have issues, but the end result of this script vs the official script is 1000 times better. To be honest, I would have not purchased vb if I had not found this thread. Reading how bad the official script is and what state it leaves your forums in, I would not have wasted my time. But I have to thank Nebula for putting in the time to do something correct. After reading how well his script works, and using it myself, I can now convert over with out any major issues.

Thanks :)

Chad Beattie
26 Jul 2002, 17:35
Originally posted by ZenithRS
Err.. yeah, but it's not as full featured as Nebula's, which I think was the point of this thread.

BTW, I've also come up with a small script that converts the quote="username" format of phpBB2 to vBulletin's standard format if anyone's interested in it. It's stand alone and can be run after the import.

Cheers

Z

Yes, I am very interested in getting a copy of it. Can you post a copy.

Thanks.

ZenithRS
27 Jul 2002, 02:11
OK... but please please PLEASE backup your database before running this. I'm a builder, so my PHP skills are rudimentary at best. The script did run fine on my 2.2.6 vB.

Here's the code... just put it anywhere on your server and run it.

BACKUP YOUR DATABASE FIRST. This hasn't been tested anywhere other than on my solitary box. Your database is YOUR responsibility.

<?
connectToDB();
$result=mysql_query("SELECT * FROM post WHERE pagetext LIKE '%."</b><br>\n";
$post_string=$myrow["pagetext"];
$post_string=str_replace("","[/B][/QUOTE]",$post_string);
while(substr_count($post_string,"[quote=\"")) {
$position=strpos($post_string,"[quote=\"");
$temp[]=substr($post_string,0,$position+6);
$temp[]="]Originally posted by ";
$post_string=substr($post_string,$position+8,strlen($post_string));
$temp[]=substr($post_string,0,strpos($post_string,"\""))." ".chr(13).chr(10)."[B]";
$post_string=substr($post_string,strpos($post_string,"\"")+2,strlen($post_string)-(strpos($post_string,"\"")+2));
}
$temp[]=$post_string;
$new_post_string=implode("",$temp);
$new_post_string=addslashes($new_post_string);
$update_query="UPDATE post SET pagetext='$new_post_string' WHERE postid=".$myrow["postid"];
$update_result=mysql_query($update_query);
if(!$update_result)
die("Couldn't update: ".mysql_error())."<br><br>";
echo "Post updated successfully... <p>";
}
echo "SCRIPT COMPLETED";

function connectToDB()
{
$link=mysql_connect("dbserver","username","password");
if(!$link)
die("Couldn't connect to MySQL");
mysql_select_db("dbname",$link)
or die ("Couldn't open forum: ".mysql_error());
}
?>

Obviously change the database information in the connectToDB function, including the dbname in the mysql_select_db statement.

Hope it works OK.

Cheers

Z

frozen
03 Aug 2002, 06:45
How would I go about using this script if I have two seperate logins for mysql. ie:

phpBB2
username: phpBB
database: phpBBforums
passwd: phpBBpass

Vbulletin
username: vbulletin
database: vbulletinforums
passwd: vbulletinpass

As you can see when I try to perform the import It can not connect to my phpBB database because it uses a different username/pass then what is listed in vbulletin's config.php

thanks in advance

stuuu
12 Aug 2002, 16:06
I have tried this 3 times now, I keep recieving this error!

PostID 2418 DONE (1 OF 15) PostID 2420 DONE (2 OF 15) PostID 2424 DONE (3 OF 15) PostID 2454 DONE (4 OF 15) PostID 2455 DONE (5 OF 15) PostID 2456 DONE (6 OF 15) PostID 2459 DONE (7 OF 15) PostID 2461 DONE (8 OF 15) PostID 2462 DONE (9 OF 15) PostID 2464 DONE (10 OF 15) PostID 2465 DONE (11 OF 15) PostID 2476 DONE (12 OF 15) PostID 2527 DONE (13 OF 15) PostID 2533
Fatal error: Maximum execution time of 30 seconds exceeded in /home/webhost/xxx/dnbforum.com/importers/bbimport_phpbb2.php on line 167

Help!

stuuu
12 Aug 2002, 16:26
Oh, I get the error while importing topics!

Chad Beattie
12 Aug 2002, 18:48
Here is what I suggest. First make a backup of your phpBB database. Then find the topic that it is hanging on and delete it. On my main site which I am getting ready to convert, I have had to delete at least 4 topics now to get it working. Once I make sure everything is ok, I will then wipe out my vb database and start from scratch. When I tested this on another one of my test boards, I had 2 topics that needed removed before the script would run. But after getting rid of those 2 topics, it worked fine.

wstahlhut
18 Aug 2002, 04:47
seeing a weirdness, I am getting timeouts errors also... I am not sure it is the same topic... digging more

***
Edit
***

Same post... going to dump it and see how it goes...

Nebula
23 Aug 2002, 21:12
Sorry I've been away for so long.

Or, you could set the amount of topics it parses per cycle even lower...

Nebula
25 Aug 2002, 17:15
Version 0.9.5 is out. This version fixes the problem with avatars not importing. They now import without a problem, though if you choose to import avatars, it may take extra time during the process, since vBulletin has to grab every image file, which can take some time ;)

I also updated the BBCode routine to support the 'reply with quote' tag. Basicially, it now converts [ quote=Nebula] into [ quote]Topic originally posted by Nebula.

Also, I submitted this version to JelSoft, and they are considering merging this with their official one. We'll see how it goes ;)

wstahlhut
29 Aug 2002, 21:17
Originally posted by Nebula
Sorry I've been away for so long.

Or, you could set the amount of topics it parses per cycle even lower...

the lower post count is not working in the new version, I had 7 post I had to remove last time before I got tired of doing that...

thanks

William :banana: :bunny:

Nebula
29 Aug 2002, 22:12
...I'm curious what the posts were that you had to delete...did they have anything in them, like a poll or something?

Chad Beattie
30 Aug 2002, 22:21
Great to hear about the avatars. I am getting ready to convert my production board over this weekend so I will be doing another test run on it probably tomarrow. I will post links to the threads which cause any hangups so you can check them out.

Thanks again for all your work :)

p.s. Has anyone figured out how to transfer user groups over yet?

Nebula
30 Aug 2002, 22:37
good luck, I hope everything goes well. Also, if you have a lot of announcements, BBCode is not parsed (little bug I found today. Doesn't mean BBCode won't work, but some may not show up correctly.)

I may release a new version soon.

Nope, haven't figured out how user groups work. Too stupid of a system ;)

JdS
06 Sep 2002, 22:57
OK, I actually read through all 7 pages and I figured out that I am NOT the only person getting timed-out. Seems to be something occuring recently or what?

Anyway, this importer does a much better job than the official one; if only it didn't time out like it does... :)

wstahlhut
06 Sep 2002, 23:47
nope mine are bad... and Nebula was looking at a copy of my database, but I have not hear back in a while...

JdS
07 Sep 2002, 00:26
mine worked eventually... it was just one post with bbcodes for [color] and [size]

wstahlhut
07 Sep 2002, 01:03
the problem is that I have 75% of my post are like that...

Nebula
07 Sep 2002, 03:46
The [size] convert routine has been bad since the start...and I've been considering removing it. It appears I will have to, since it's causing problems for people.

wstahlhut
07 Sep 2002, 03:52
there anyway you can just strip it and the color tags out?

Nebula
07 Sep 2002, 03:56
That's what I was planning on having it do. I will see what I can do ;)

wstahlhut
07 Sep 2002, 03:58
GREAT!!!! that will help as lot as the old phpBB tags are just garbage after being imported to vB

geniuscrew
21 Sep 2002, 17:16
I have a problem with this script - although it worked perfectly from phpBB to vB 2.2.7, the end moderator column has assigned every moderator to every forum.

Also I used the same username when setting up my vB, as the one I had on phpBB, so now there are "2" of me - which one is safe to delete?

Thanx for a great hack btw

geniuscrew
21 Sep 2002, 17:48
Actually no need!

Works like a Charm! - Thanx!

minodsy
23 Sep 2002, 20:46
Nebula: this hack just r0x! :D i need to thank you a lot for this work and for distribuiting it freely. great!

I report only a problem with the [size] translation: in large posts it timeouts at the row with the main regexp :( (as reported by other people in these pages). So i had to comment that line and re-import.

Thx anyway

BenJohnson
06 Oct 2002, 20:50
This hack doesn't work too well.

When converting posts, it is not counting them correctly.

For instance, I had 875 threads & 6100 posts. However, the converter makes it say 875 threads & 875 posts.

How does one fix that?

Nebula
06 Oct 2002, 21:30
first off, you probably didn't update counters. And if you did, then maybe you have a hacked phpBB??? it's worked fine for me countless times...

Marshalus
10 Oct 2002, 05:19
I keep coming up with this error:

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: DELETE FROM session WHERE sessionhash=''
mysql error: Table 'eclipse_phpbb.session' doesn't exist

mysql error number: 1146

Date: Wednesday 09th of October 2002 11:21:15 PM
Script: http://ADDRESS/bbimport_phpbb2.php?s=&action=dothreads&idbname=eclipse_phpbb&iprefix=&doPerPage=1000&offset=200&pause=0&anncExpire=30
Referer:


But the thing is, there is not session table in phpBB. Where does it script get this?

pdatoon
15 Oct 2002, 18:17
did someone try the importer on a production VB board?

I want to fusion a PHPbb board with mine and i was wondering if there is any kind of problem. I know it's better to import to a blank VB board.

suggestions?

Nebula
15 Oct 2002, 21:15
Marshalus: that bug has to do with database switching...some versions of PHP/mySQL do not handle it well. It works fine for me, and I can't reproduce that error, though people seem to have it.

pdatoon: Importing into a board with users/posts already there works just as well as when you're importing into a blank board. There is only one concern: say a user registered on your phpBB as 'Nebula'. Then, you shut the phpBB down, move to vBulletin for a few weeks. Nebula creates a new account on the vBulletin. If he names that account 'Nebula', then my script will link all the old phpBB posts to his new username. However, if he registered as 'NebulaDJ', then my script would create a new user 'Nebula', instead of 'NebulaDJ'. The official importer has a step called 'Associate Usernames', where you specify a username on the phpBB, and it can link it to the current vBulletin one. All my script does is check if the usernames are the same. So, if this is important to you, use the official one. If this doesn't matter, you can use mine or the official one...;)

Marshalus
18 Oct 2002, 07:54
What versions of PHP and MySQL are you running?

Also, on the autodetection of usernames, if they have different caps on them, like "marshalus" instead of "Marshalus" will it still compare them as the same user?

Nebula
18 Oct 2002, 23:42
I'm running the most recent versions of everything (OmniHTTPd (Apache doesn't work well for me), PHP, & mySQL). PHP is 4.2.3, and mySQL is 3.23.53.

Also, no, it is case sensitive. Sorry :ermm:

A-handreas
25 Oct 2002, 19:21
Hello!

I will switch from phpbb2 version 2.02 to the newest vbb. But in the process of importing the post on most of the post it stops with the following problem message:

Fatal error: Maximum execution time of 20 seconds exceeded in /usr/local/httpd/htdocs/***/***/forum/importers/bbimport_phpbb2.php on line 160

and my forum had 80.000 post, no way to do it post by post or skip it.

Please help, the rest before works better then the official importer, this sucks more.

I stand by, because I want to open my forum tomorrow again
Andreas

Nebula
26 Oct 2002, 14:51
your server has an execution time limit on how long a process can be alive (processing). You should try lowering the amount of threads it processes each cycle.

A-handreas
27 Oct 2002, 22:14
Hi Nebula!

I had tried this, but some thread's are to big. I want to convert the problem post every single alone, but the same result. The time is ticking away before it is convert. With the official importer I had this problem not, but there are very more other problems. Huuh, what I can I do...I have send an email to my provider. Is there any chance that there is an problem from your importer, because with the official I had not this problem.

Thanks
Andreas

Nebula
28 Oct 2002, 11:31
OK, I have a good idea why it is causing all these timeouts...the [size=*] routine. Now, it just strips size tags off, instead of trying to properly change them from phpBB sizes to vBulletin sizes.

So, go download 0.9.5.2, and let me know if it works ;)

A-handreas
06 Nov 2002, 20:38
Hello!

Yeah it works :-)
Thanks for your quick help

Bye
Andreas

350Chevy
17 Nov 2002, 04:14
Still had bugs for me.

PM's were not imported correctly, user's passwords were still scrambled, no attachments imported, no avatars imported, and post counts were all off.

It's still a better upgrade file than the "official" one but this one needs much work. ;)

Showtime
17 Nov 2002, 17:25
Sorry 4 the n00b question, but i can't figure it out. LOL

http://fun4gamers.nl/BEWARE/zooi/phpbbport1.jpg

Gives this error:

mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Couldn't Select DB DAF
mySQL Said: Access denied for user: 'fun4gamers@localhost' to database 'DAF' (Error Number 1044)
Date of Error: November 17th, 2002 at 6:25 PM
URL of Script: /BEWARE/importers/bbimport_phpbb2.php
Referring Page:

Where do i fill the login/pass for the phpbb database?

Friendly regards

vbb: http://www.fun4gamers.nl/BEWARE
phpbb: http://www.fun4gamers.nl/daf

fury
08 Dec 2002, 18:49
Nice importer!

I've made a few modifications to it and the bb_import functions so that the original ID's were preserved, and I plan on adding IMG codes linking to the current phpBB attachments at the end of each post that contains them, if you have any ideas on the best way to go about this (e.g. fastest, safest way) I would appreciate it.

Question: Why are some avatars converting and some aren't? And is this importer supposed to convert the avatar gallery? Because it didn't.

Nebula
08 Dec 2002, 22:42
Showtime: You need to have the mySQL Username and Password for the vBulletin database be the same as the phpBB database.

fury: No, I don't really have any ideas about the IMG thing...probably because I don't completely understand :ermm:

I'm not sure why all the avatars aren't importing...hmm. And no, it's not supposed to convert the avatar gallery, that's up to you ;)

cinq
20 Dec 2002, 06:27
How can I resolve the problem of jumbled up Private Messages ?
Everything else seems to be working fine though other than the pm glitch :)

Pls advise

Cheerios ! :)

Zenith
20 Dec 2002, 09:33
Read this whole thread and you'll find the answer. You have some user ids missing in your phpbb database. e.g. userid 20,21,22,25,26,27.... 23 and 24 are missing, so userid 25 in the phpbb database will become 23 in the vbulletin database, so the wrong users end up with the pms.

leozh
25 Dec 2002, 00:42
It seems the poll conversion is screwed up.

It tried to run the SQL arguement ... WHERE vote_id =

(without anything after =)

leozh
25 Dec 2002, 01:46
Oh yeah, and it seems that locks didn't get converted.

sunrunner_pei
09 Jan 2003, 01:50
Originally posted by Nebula
Showtime: You need to have the mySQL Username and Password for the vBulletin database be the same as the phpBB database.

I'm having the same issue as Showtime... I also ran into the same issue as well with the "official" importer. No matter what I try, I can't assign the same userID and password to the 2 databases on the same server. I contacted my hosting company and they confirmed that it wasn't possible.

Any suggestions as to what I can do?

Nebula
09 Jan 2003, 02:39
lol, it is very possible, they're just lazy (no offence, of course).

I use CPanel on my server, and it's the best by far. As for that, there's not much I can say. Some webserver panels are just more flexible than others.

As for the poll thing, I will look into that. I am very busy, as exams are coming up next week. But I'll see what I can do ;)

sunrunner_pei
10 Jan 2003, 02:30
Originally posted by Nebula
lol, it is very possible, they're just lazy (no offence, of course).

I use CPanel on my server, and it's the best by far. As for that, there's not much I can say. Some webserver panels are just more flexible than others.

As for the poll thing, I will look into that. I am very busy, as exams are coming up next week. But I'll see what I can do ;)

We're using Plesk as a control panel, I have no other option than that. :tired: Is there no way to modify the importer to allow someone to specify a user and password for the target database? Or am I out of luck on importing my existing users? (I only wish to import the users, nothing more)

Nebula
10 Jan 2003, 03:05
try this one. I changed it in 5 minutes, so I might have missed something. It might work though. No guarantees, as it was never really designed for this. Good luck. I can look at it more tomorrow if it doesn't work.

BTW...many of you that are having problems with this, JelSoft will have fixed them (and probably ones that people haven't found), and will release it with vBulletin3...at least that's what they told me.

sunrunner_pei
10 Jan 2003, 03:20
Originally posted by Nebula
try this one. I changed it in 5 minutes, so I might have missed something. It might work though. No guarantees, as it was never really designed for this. Good luck. I can look at it more tomorrow if it doesn't work.

BTW...many of you that are having problems with this, JelSoft will have fixed them (and probably ones that people haven't found), and will release it with vBulletin3...at least that's what they told me.

Thanks so much!!! I'll give it a try! :classic:

sunrunner_pei
10 Jan 2003, 03:27
So very close...

Now I'm having the opposite problem. It is trying to use the user and password I entered for the phpBB2 database for the vBulletin database. D'Oh!

Thanks so much for your help so far!! I'm so close I can taste it. ...

Nebula
10 Jan 2003, 22:45
sorry, PHP doesn't handle mulitple mySQL connections very well...either that, or I don't ;)

Try this. Also, if you're getting queries being executed on the wrong database, try this one too.

cyc
19 Jan 2003, 22:41
Great hack, I converted from yabbse => phpbb => vb

everything went pretty good except alot of my posts contain the html tag ' <br /> '

Its displaying where a line break would normally appear, you can see an example here http://www.cyclingforums.com/t1274.html

Does anyone know of a quick fix to make these posts display properly?

cheers!

Wells
23 Jan 2003, 12:19
Hello! This message to all vBulletin great hackers and simply hackers at all :)
vBulletin board has a really great problem - it can not restore db itself!
Ok, my hoster always do backup for me and he can restore it, but it much more easily to do it myself.
!! Do you know some script as in phpBB to restore db?
in phpBB admin has link "RESTORE DATABASE"
! May be someone could? Heh. It 'll be realy GREAT!

Sketch
23 Jan 2003, 13:01
um, er....

This is a vB group, not a phpbb one. I think it would be inappropriate to try to support phpbb. I recommend you check at www.phpbb.com and www.phpbbhacks.com for phpbb support.

Danka.
Aaron

Molok
20 Feb 2003, 10:16
i have a vb2.2.9 with over 200 000 posts.
another board that use phpbb2 will join my board and take alle the posts, threads and users into my vbb2.2.9

can i do this with this script ? i dont want lose my datas in the vb229

Nebula
22 Feb 2003, 13:36
Cyc: hmm...my copy of phpBB never did that...on the other hand, I don't exactly keep it updated ;) Maybe they do that in the newer versions.

Wells: try phpMyAdmin (http://www.phpmyadmin.net/).

Molok: yes you can. My importer can merge databases. But, as always, back up your database(s) first.

Joe Page
22 Feb 2003, 19:57
mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Couldn't Select DB (I didn't leave it here for security reasons)
mySQL Said: Access denied for user: '@localhost' to database '(removed for security reasons)(Error Number 1044)
Date of Error: February 22nd, 2003 at 2:50 PM
URL of Script: /board/importers/bbimport_phpbb2.php
Referring Page:

That's the error I get.

Nebula
22 Feb 2003, 20:47
in your vBulletin config.php file, you need to specify a mySQL username ;)

Joe Page
22 Feb 2003, 21:18
I have.... What should I do now?

Nebula
23 Feb 2003, 00:13
run the importer again ;)

Joe Page
23 Feb 2003, 01:18
I have used the importer a few times and I still get the same error :(

Nebula
23 Feb 2003, 01:42
oh...sorry, I think I know the problem. Use the file in the first thread, not the one towards the end. The one (v0954) is experimental.

Joe Page
23 Feb 2003, 16:38
The importer worked but it keeps randomly deleting threads :(

All of the threads disappeared, so I ran it again and the same thing happened :(

Nebula
23 Feb 2003, 16:46
...woah...hmm...were there any errors? do you use hacks on your phpBB2 board?

TeEq
26 Feb 2003, 21:16
sorry where im find conventer invision board to phpbb2...can you give me links...becouse im dont find this in www.phpbb.com....

Nebula
26 Feb 2003, 21:32
this is not the place to post that. This is a vBulletin forum. The thread is for support on an importer that converts phpBB2 data to vBulletin data.

But, the answer to your question is that one doesn't exist. I'm guessing the reason is (and this is my opinion, no flames please) that I personally like Invision a lot more than phpBB. Apparently, there isn't enough demand for one to merit the developers to make one.

Short and sweet response: There is no IPB->phpBB2 importer. And next time, post a question like this at phpBB.com.

Cyricx
06 Mar 2003, 08:01
OMG WTF BBQ. I thought this was going to be so much damn work it isn't even funny. Thank you for making my upgrade to vBulletin a breeze.

Zhin Jio
06 Mar 2003, 08:11
Ok, that post from Cyricx was really me. Duh. In any case, thank you so very much for making my life simple. I was dreading the hours of potential work an import was going to be. Whoosh, its in.

- ZJ

Nebula
06 Mar 2003, 20:40
uh...no problem ;)

kaotic
16 Mar 2003, 05:06
Will this be able to convert a phpbb 2.0.4 message board?

Nebula
16 Mar 2003, 13:54
After looking at the phpBB 2.0.3 -> 2.0.4 upgrade script, it looks like the mySQL schema (layout) doesn't change much. The changes that are made would not be affect the importer (I hope). All that is changed is the search match, user, and prune tables. The user table would be the only one I would be worried about, and the changes that were made are just changing the default row values.

So it should work fine, unless I missed something ;)

xs1
01 May 2003, 14:57
Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /usr/l***l/***/***/***/fc-factor/httpdocs/***/importers/bbimport_phpbb2.php(1157) : eval()'d code on line 1

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /usr/l***/***/***/***/fc-factor/httpdocs/***/importers/bbimport_phpbb2.php(1157) : eval()'d code on line 1
We're sorry, but there seems to be a problem with the database. You can try refreshing this page. If after you refresh the page, you still see this error, do not refresh anymore times. We have been notified of the error, and will work to fix it soon.
An email has been sent to the Technical Staff.
If you feel that you would like to tell the Technical Staff more about this problem, please feel free. There is no need to simply tell them there was an error, as they have been automaticially notified.

We are sorry for any inconvienience this may have caused you. We are working to resolve the issue.

Below is a copy of the email sent to the Technical Staff:
mySQL Database Error!

Script That Crashed: phpBB2 Importer
Script Returned: Couldn't connect to mySQL
mySQL Said: Nothing
Date of Error: May 1st, 2003 at 3:08 PM
URL of Script: /forum/importers/bbimport_phpbb2.php?s=&action=styles&idbname=Cron&iprefix=phpbb2plus_&iusername=&ipassword=
Referring Page:

Nebula
01 May 2003, 22:17
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?

xs1
01 May 2003, 23:50
yes ofcource !!!
it showed some me like
...sucessesfull
....succsesfull
....done

then when the page is forwarded

then it showes the ^ above thread error

Nebula
02 May 2003, 00:12
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?

xs1
02 May 2003, 10:05
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:

Nebula
02 May 2003, 20:15
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.

xs1
03 May 2003, 04:03
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...

dOuBLe_J
20 May 2003, 07:28
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 -

Nebula
25 May 2003, 02:59
Will the latest phpBB2 converter work from phpBB 2.0.4 to vBulletin 2.3.0?

Yes.

Does it convert both user accounts and threads?

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

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

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.

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

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.

dOuBLe_J
25 May 2003, 03:09
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 ::

Zenith
25 May 2003, 04:20
Nebula... did you ever address the following problem?

Thanks for the script.07-23-02 at 09:27 AM ZenithRS said this in Post #82 (http://www.vbulletin.org/forum/showthread.php?postid=275713#post275713)
I've worked out the problem with the Private Messages import. At some stage in the history of my phpBB2 I've deleted a user which left a gap in the sequence of userid's. In this case it was userid 18. The import script doesn't allow for this so phpbb userid 19 gets entered into the vbulletin as userid 18 as 18 is the next available spot...the field must be set to auto increment and the script doesn't "notice" the jump in phpbb's userid's.

I created a dummy user on the phpbb2, and then changed it's userid to 18 to fill in the gap in the sequence. Then ran the import script again. All the private messages are now associated with the correct user ids.

This explains why some had problems with the PM import while others didn't. I haven't delved into Nebula's code to find out why it does this, but I'm sure it will be a simple fix.

Hope this helps.

:banana:

Z

dOuBLe_J
25 May 2003, 05:21
Cool info to know Zenith. Thanks for the post.

:D

Buczilla
05 Jun 2003, 08:10
I'm getting ready to do it on my 62.5 mb database. And i sure hope it works!!!

[Fx]AssAssiN
03 Jul 2003, 05:29
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

0versight
03 Jul 2003, 06:04
Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /home/username/public_html/bbs1/importers/bbimport_phpbb2.php on line 14


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

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

Nebula
03 Jul 2003, 12:09
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 ;)

0versight
03 Jul 2003, 14:14
Today at 12:09 PM Nebula said this in Post #176 (http://www.vbulletin.org/forum/showthread.php?postid=414934#post414934)
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.

[Fx]AssAssiN
03 Jul 2003, 19:53
Today at 07:09 AM Nebula said this in Post #176 (http://www.vbulletin.org/forum/showthread.php?postid=414934#post414934)
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 ;)
Alright, I'll ask em. :lick:

[Fx]AssAssiN
08 Jul 2003, 03:54
I'm trying to update the thread counters but I get this error...Please help Nebula!

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1057631447,replycount=3,postusername='Placebo', postuserid='2', lastposter='GreyDeath',attach= WHERE threadid=807
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=807' at line 1

mysql error number: 1064

cyber nerd
11 Jul 2003, 00:29
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...

mudanoman
19 Jul 2003, 20:47
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)

tomspics
20 Jul 2003, 16:00
Can't seem to get it to show up in CP either. Does this work with the new 3.0 beta vb?

mccollin
24 Jul 2003, 06:36
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.

mccollin
24 Jul 2003, 14:32
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).

mccollin
24 Jul 2003, 22:54
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.

Nebula
25 Jul 2003, 15:15
[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.

mccollin
28 Jul 2003, 07:29
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.

Nebula
02 Aug 2003, 22:02
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.

mccollin
02 Aug 2003, 23:28
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.

Nebula
03 Aug 2003, 02:53
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.

isaracing
31 Aug 2003, 02:50
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?

Nebula
31 Aug 2003, 20:57
hmm...I don't know what to say about that...

you are using vB2, right? ;)

Soriead
08 Sep 2003, 18:12
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?

deathemperor
24 Sep 2003, 14:46
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 ?

maximus761
30 Sep 2003, 13:59
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

lyle84
07 Oct 2003, 14:49
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

Zachery
07 Oct 2003, 15:45
fyi an offical db importer from vbulletin.com is avliable

Nebula
07 Oct 2003, 20:39
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.

SnakeInc
23 Jan 2004, 19:45
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)

SnakeInc
23 Jan 2004, 19:46
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.

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

SnakeInc
23 Jan 2004, 20:11
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.)

Nebula
23 Jan 2004, 20:42
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...

TeUtZ
24 Jan 2004, 16:06
thanks

manguish
29 Jan 2004, 18:02
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/importers/bbimport_phpbb2.php?s=&action=dothreads&idbname=minim_xmb1&iprefix=phpbb_&doPerPage=25&offset=150&pause=0&anncExpire=30
Referer:

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

manguish
30 Jan 2004, 01:23
Bugger it.

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

Evelyn
01 Feb 2004, 01:04
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/importers/bbimport_phpbb2.php
Referer: http://www.timeslipforums.net/importers/bbimport_phpbb2.php


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

manguish
01 Feb 2004, 07:10
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/importers/bbimport_phpbb2.php
Referer: http://www.timeslipforums.net/importers/bbimport_phpbb2.php


If anyone can help me it'd be appericated.
:)
Give up and use the official one, its easier, and works first time.

Cap'n Steve
27 Feb 2004, 09:39
Any chance of supporting the (very common) attachment mod for phpbb? Pleeeeeease...

Bryan Ex
02 Mar 2004, 23:52
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.

Bryan Ex
07 Mar 2004, 00:05
Good luck. I hope it works out for you ;) If you encounter any problems, post them here.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.

phenomenon
19 Mar 2004, 18:28
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!

A-handreas
19 Mar 2004, 18:54
@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

phenomenon
19 Mar 2004, 23:10
oh... interesting ok. Thanks Andreas

Skyrunner
09 Apr 2004, 18:11
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

TonTon
16 Apr 2005, 14:58
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?

Marco van Herwaarden
16 Apr 2005, 15:10
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.

TonTon
17 Apr 2005, 12:39
Oh, I hadn't noticed this was for vB2

Ok thanks.

Sevo
01 Dec 2007, 20:59
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

Marco van Herwaarden
02 Dec 2007, 11:34
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.