phpBB2 to SMF user problem

[chipster]

I have a small forum, only 34 members.  The conversion utility get's all the topics, posts, and polls, but appears to stop in the middle of the sixth user.  This user has no special characters in their name or anything else strange for that matter.  It gets their avatar and post count, but not their ID/username and then quits importing the rest of the users.

Any ideas?   

[ThomasJ]

Seems to be related to http://www.simplemachines.org/community/index.php?topic=33300.0

[[Unknown]]

Can you post or send me the results of this query?

SELECT *
FROM phpbb_users;

What is phpMyAdmin?

It may be caused by another member's username.

-[Unknown]

[chipster]

Thanks for your help, and pardon my ignorance if this is not the best way to get you this info.

[chipster]

Thanks for editing that post [unknown], and thanks for the heads up ShadowMaster.  I have since removed the link and changed all the important things.  I'm fairly new to some of this, but this is how we learn, right?  [unknown], if you  would like access to anything on my server, I'd be happy to let you use me as a guinea pig.

Chipster

[chipster]

well, unlike other users who have had success after the 7th time running this script, I am getting the same problems after about 200 times over the past two weeks.  Can anyone tell me what special characters in a phpBB users profile may or may not cause problems with the conversion?  Since I have hinted to my users that we may switch to SMF, they are hounding me to get it done.  It's rather unfortunate, if you ask me, that there are a few minor issues and I can't seem to get any answwers.

[[Unknown]]

I'm sorry, I really don't see anything wrong.  Are you sure you've tried Admin -> Forum Maintenance -> Recount all forum totals and statistics?

-[Unknown]

[Oldiesmann]

This happened recently to someone else when I was helping them convert their phpBB to SMF. It only picked up 33 of the 71 members. I ended up hacking up the converter quite a bit to get the rest of the members without messing things up. I've attached that version to this post. Try it and let me know if it works. (Developers: I cut out steps 1, 2, 4-21 and 23-26, cut out the part in step 3 that empties the members table in SMF, changed the INSERT in that step to INSERT IGNORE and updated steps 0, 3 and 22 to point to the next remaining step instead of one that I cut out).

[[Unknown]]

But, did you change anything other than the INSERT IGNORE, really?

-[Unknown]

[Oldiesmann]

No. I didn't change any of the functionality of that step other than changing INSERT to INSERT IGNORE and getting rid of the code that clears out SMF's members table before converting members from phpBB. For whatever reason though, it worked perfectly for this person and got all the rest of the users.

[chipster]

Well, after a bunch of trial and error, I believe I finally found what was causing the problem.  For some reason my phpBB installation had a completely blank user (UID1).  I tried to remove that user early on in my testing with no luck, but when I went back to check the phpBB database, i noticed it was re inserted.  I removed him a second time, and before phpBB had the chance to insert that record back into the database, I ran the conversion script and it worked great. 

It appears phpBB requires that user and automatically inserts it if it is missing, though I'm not sure why.  I hope that gives you guys some useful info for modifying the conversion script.  Thanks for the help, I couldn't be more excited about the switch to SMF!!!

Al
www.campchip.com