phpBB Importer Ready!

UPDATE: Please make sure to read the last posts. The beginning of the thread is kinda old, so please don't think this is how it works. Read the last posts.

----------------------------------

Hello. This is my first time posting here, so I hope I make a good first impression

Anyways...I just finished my phpBB 1.4.0 Convertor Utility, allthough I don't have an actual phpBB 1.4.0 DB to test it on. All I did was use a DB with 2 forums, one topic, and one post . Anyways, if you have phpBB 1.4.0, or any other kind of phpBB (Convert it to 1.4.0, of course ), please please help me test this.

If you find an error or some way of crashing or messing up the process, please tell me what happened. Also, if you could send me a copy of the database you are using, that would be greatly appreciated. Please don't think I'll steal your PWs, because they are MD5 encoded.

Known Bugs:

• Does not make private forums private while converting

When it is converting, all the user passwords are changed to a different md5-encoded string. I plan to change this later.

I know it isn't very user friendly. Also, please don't take any part of this code without my permission. I worked really hard on it. Thanks a bunch.

Please post anything you have to say about this below.

[Juan]

I have tested the latest version several times.

The import went very well, no errors. After the import, some membernames were duplicated, reports the same number of threads and posts in every forum and the dates are all wrong "Year 2036"

Posts have been assigned to membernames which are different from the people who actually posted them.

Here is the sample:

http://www.christopherleeweb.com/for...?s=&forumid=36

And the titles of the threads are different from what is being discussed.

[Nebula]

::sigh::

Well, I guess I have some more work to do.

Juan, could you please send me a copy of your phpBB database? Email it to Nebula_DJ@SoftHome.net. Anyways, I'm sorry about that. I have no clue what is wrong. Before you send me the database, could you try running the conversion one more time? And also, make sure you are running the newest version.

If the convertor still doesn't work, and you are using the newest version, send me your database. I'll find out what's wrong.

Thanks.

[Juan]

I've e-mailed you the database. I hope there is something wrong with it and not the script.

[Nebula]

Well, the dump you sent me has all the forums labled 1, 2, 3, etc...

I've looked at the results...and the dump you gave me is converting it exactly what it is being given.

Anyways, I think this is an error on your forums, and rather not mine. I don't know why the forums are labled 1, 2, and 3, and so on.

Anyways, I don't think this is a problem with my script. If you want to send me a newer dump, you can.

For everyone else, keep testing.

P.S. Juan, please let me know what you think...

[Juan]

Nebula, it could be a problem with my phpBB database as you stated. I've moved from IB, guess I need to make sure everything is bug free at phpBB before importing.

The forums are labelled 1,2, 3, 4, etc because it would be easier for me to merge the posts in the appropiate forum afterwards.

[Nebula]

Well...check it out. I'm glad it isn't something wrong with my script. Not that I'm happy that it is your problem...just...you know

Also, you guys, keep testing. I really need feedback.

[Nebula]

Well, since nobody is replying to this, I guess I'm just gonna send this to Jelsoft. If anyone finds any problems with it, please contact me immediately.

I have email notification enabled, so just reply here. Thanks.

Hi Nebula
Some remarks before you send your actual release:
- When you import style, add "phpBB_" for example before the name of the phpBB style, because phpBB and VB have the same name "default" for the default style, and after import we have 2 default style and it is difficult to know who is the phpBB an VB style;
- I have choose to conserve the password of the phpBB user: when i make importation, i put the old (phpBB) psw in the VB user base. In VB, i have change the lines where the psw is checked with the same method than phpBB (md5 function); for the Email psw, i must send a random psw, but it is not ready for this moment. With this modification, i can switch from phpBB to VB in 1 or 2 hours max, without any disagrement for users: it is transparent !
- I am not sure at 100% that your script is ok (i hope that it is ok!), but i have some problems like Juan, but for my test of importation, i work on a not very clean base of phpBB...(i have just a difference of 1 between posts and posts_text tables. And the result of the importation give me some stranges mixtes with bad name for posters and also, more strange, i have found privates messages in publics posts... and i am not sure that is only due to the fact that i use a not clean phpBB base... I am writing a litle script for import my real phpBB base from the web to my personnal server without changes or omissions. When this step will be finish, i will say: YES your script is OK or NO...somethings is wrong. That is the raison why i said nothing since some days, i wait to be sure before speaking...
That all for today, and your work is very nice !

I send you more informations when i have
(If you want my real clean base, it is 1,2Mo size...i can post it)
Bye

[Nebula]

Well Juan...you have some good ideas.

• On the Styles, that is a very good idea. I'll go add it now.
• Hmm, your Password idea is interesting. I'll go make it an option.
• When you say my script isn't quite ready to be released, please tell me more of what you mean. Also, please send me a copy of your not very clean database. I want to see what's wrong with this. Also, is it really my convertor's fault if you have a bad database As for PMs showing up in posts, that's just plain whacked. I really want to find out about that. Also, what do you mean by:

  I am writing a litle script for import my real phpBB base from the web to my personnal server without changes or omissions.

Anyways, please let me know ASAP. I really want to get this thing done...my vBulletin license expires 1 month from now, and I want to get it renewed by hopefully completing this script (JelSoft might give me a new license because I made this for them ).

Thanks. Please send me your not clean database in the email. My email address is: Nebula_DJ@SoftHome.net. Talk to you later.

----- The following recipients were processed by MTA adansonia.wanadoo.fr...

Nebula_DJ@SoftHome.net; Action: Failed; Status: 5.1.7 (bad sender's mailbox address syntax)

---- Message SMTP Diagnostic: 553 IP address 193.252.19.224 is an open mail relay or part of a multistage open relay - See http://www.orbl.org

[Nebula]

Well...I have no clue whatsoever what that means, but I got the email all right

I'll let you know how it goes...

[Nebula]

Hey. I would have posted this way sooner then this, but for some reason, I couldn't access vBulletin.com at all. Just last night, all I could access just the main page.

Anyways, here's the new verison. It includes style prefixes, and an option to insert the MD5 encrypted password, or generate a new one. Also, if you choose not to generate a new password for the users, it will not attempt to mail the users their new passwords. Those are the things I need tested.

Well, please get testing. Also, jyr, please tell me more of what you mean. As for a database that has one more entry in posts then in posts_text, I tested that, and found that it just omits the last post. And for private messages showing up as public posts, that would have to be a problem with the database, or vBulletin, but not the convertor script. It's literally impossible for it to take a PM, and put it in a public post. Anyways, correct me if I'm wrong.

I really need some help testing this script you guys. I don't want to send a bad version to JelSoft...

[Nebula]

Come on you guys. I've got lots of testers in the past. The only person that is testing this is myself (I think). I'm the only one posting here. If nobody posts in one day, I'll send it to JelSoft.

Oh yea, I made some little changes, so please, please, please test this. This will be sent tomorrow if nobody replies.

I have testing your preceding release (not the last just above) and i send you by email my results.

This a copy a my mail:

Hi
I have take your last version of "bbimport_phpbb.php" and i have try it:
- Same mixte in topics/messages/posters... (
- It seems that the mixte between post and authors is an offset of 1;
- When i am on the page "phpBB forums" of my imported site (in VB), i see
the same number of messages and topics. The date of last message is always
"Never". The number of topic is ok but the number of message is wrong
(because it the same than topics...).
- When i open a forum, titles of topics are ok. But in topic, messages are
not corresponding with the original.

In my phpBB user base i have:
ID NAME
-1 anonymous
1 Root
2 Upag38
3 Neodidier
...

And in VB users base, i have:
ID NAME
1 JYR (me for admin)
2 Root
3 UPAG38
4 Neodidier
...

and for this 3 users, all posts are affected with the id of the phpBB base
and not with th VB base, this is wy i have an offset of 1.May be you use the
order of the table and not the userid ?

Perhaps, all the problem come from this offset...i don't know...
The 2 changes for password and phpBB prefix style works very fine )
I hope i can help you with this explanation for fix the problem...
Email me when you have an answer.
See you ;-)
JY

I don't knows if you have receive my email (no answer and sending error...) and if you have make some important change on the problem of the mixte between posts/posters/topics but if you have not, you can't send this release to Jelsoft...
I can't test your last release today, but tomorow it is ok. I think that is't a big bug, and if you fix it, all is perfect !
I post my test result on your last release tomorow evening.
Have a nice day

[Nebula]

Here's yet another update.

Thanks for letting me know about the post username problem. I feel really stupid about this one. The script was using the users's old userID. It's changed so now it uses the new ones.

A List of what I've fixed/added in this release (Not much):

• BUG FIX: userIDs in posts
• NEW: Redirect code in some steps (used so you do not have to scroll down to the bottom of the page, it loads a new one with the step on it)

I was talking to JohnM about this. He said something about numeric arrays, and threads in the wrong forum. I am talking to him about this now, so I'll get it worked out.

Anyways, There isn't much to test in this version, only one thing was changed (the bug listed above). Test this new version, but there isn't much new stuff to test.

JYR, I did get your email, but I have been quite busy planning for my family's vacation in 6 days.

Send me any suggestions/problems right here. Thanks. Keep testing too.