[ Closed ] Converter: PhpBB2 -> PunBB1.1 v2.0b3 (Page 2 of 4)

Probably yes :)

And that was, as I assumed, the problem. Though, it's from user_id -1 to 1:) Fixed it now, and uploaded a new file to PunRes. There's also a fix for the guest-problem at the same page... hopefully I've not forgot anything :)

it's too late for me now, because i already deleted my phpBB database , but it's good you fixed it.

Thanks man! You saved me!

edit: it works! IT WORKS!

The problem occurs when the converter tries to copy a user from PhpBB with userid 1, the same as punbb guest account. Try changing the file: _users.php so the first lines look like this:

<?
    $start = (int)$_GET['last_id'];
    $start < 2 ? $start = 2 : null;
    echo "\n<br>Converting users...\n"; flush();

Though, the user with id=1 will not be converted now. I have to do some major changes for it to work otherwice...maybe I'll look at it in a few days.

Well, so did I... don't know what went wrong though =/

We discussed the problem with the guest account... that it has userid -1 in PhpBB and 1 in PunBB, and that's fixed. Though, no one else had this problem (hopefully), maybe id 1 isn't used for some reason?

I'm gonna look closer at this...

Sorry, I've missed this post completely :(

The converter can be placed anywhere, it has no connections to PunBB (don't use PunBB's database class). It seems like you've entered some info wrong when MySQL reports that cpayk_punforums.punbb_users doesn't exist :/

Although, it seems right if you have a database named cpayk_punforums, with the PunBB-prefix punbb_.

A possible problem with BBCode could be that all BBCodes in PunBB are lowercase (to speed up post parsing). If you enter an uppercase BBCode it will be converted to lowercase automatically by PunBB.

In your case, I believe you will have to do a search and replace in all posts and update the BBCodes.

Edit: Come to think of it, doesn't Chacmools converter do that?

No problem for me if you want my database SQL dump. Nothing confidential (passwords are encrypted, of course) But I can also make some test, as you wish.

I've made some tests, here are the results...

IPB database :
- for topics started by unregistered users, ipb_topics.starter_id = 0 and ipb_topics.starter_name = "any guest"
- for posts written by unregistered users, ipb_posts.author_id = 0 and ipb_posts.author_name = "any guest"

phpBB database (by conversion) :
- for topics started by unregistered users, phpbb_topics.topic_poster = 0
- for posts written by unregistered users, phpbb_posts.poster_id = 0 and phpbb_posts.post_username IS NULL

This was a problem even in the phpBB forum so I made updates :

UPDATE phpbb_topics
SET topic_poster = -1
WHERE topic_poster = 0;

and

UPDATE phpbb_posts
SET poster_id = -1, post_username = 'z0rglub_guest'
WHERE poster_id = 0;

... now it's better, I can see topics and posts from guests (but they are all called "z0rglub_guest", I've lost this info during conversion from IPB to phpBB)

punBB database (still by conversion) :
I can see Anonymous topics, but Anonymous posts are not shown :-/

- for topics started by unregistered users, punbb_topics. poster = "Anonymous"
- for posts written by unregistered users, punbb_posts.poster = "Anonymous" and punbb_posts.poster_id = 0

after trying to post as guest directly in punBB forum, I see that anonymous users have poster_id = 1, so

UPDATE punbb_posts
SET poster_id = 1
WHERE poster_id = 0;

and now, I can see anonymous posts :-) (still having lost username informations, but this is due to IPB to phpBB conversion)

Conclusion : problems for phpBB to punBB converter concerning guests on posts. If the phpbb_posts.poster_id = -1, the converter has to create a post with punbb_posts.poster_id = 1 and punbb_posts.poster = phpbb_posts.post_username.

Hope it helps

One small issue: the converter choked on importing forums with an apostrophe in the Forum Name, e.g., John's Discussions.

In _forums.php I changed line 18 to read:

\''.html_stuff($ob['forum_name']).'\',

and then the conversion worked like a charmed.

Thanks!

Any idea about the date of the first beta test release of your IPB to PunBB converter ?

z0rglub:

I've rewritten the conveter so it have the nice PunBB-style (it's the same "system" as the InvPB-converter now). As PunRes doesn't work, the file can be downloaded here. Please report any bugs... hopefully there much less problems with ' and " now.

Edit: Found something I must change... removed the url temporary.