Forum module: Discussion thread for converting PHPBB data

If you can post the bbcode that had troubles, I would try to squeeze in a moment to fix that up, at some point this week. Currently working on a Menalto Gallery G2 -> EE 1.6.x converter which is taking most of my spare time.

It was just the usage of quotes having no closing. No big deal in the whole scheme of things. I think that was the only thing we noticed right off the bat. Good luck with the gallery conversion.

Hi,

Thanks for posting this fantastic script. I’ve been working on a few improvements such as the adding of number of posts and topics to a user’s account. I’m having the trouble with the closing quotes though and am wondering what you did to resolve this?

For anyone interested the problem is that the current script uses the following code:

<pre><code>$postbody = str_replace(‘[quote=’, ‘[quote author=’, $postbody);</code></pre>

but in order for the quote to be closed it also needs the date=”” adding i.e.

<pre><code>[quote author=”Someone” date=”“]</code></pre>

I can’t work out how to do this…

I’ve converted a test forum of over 500k posts and 20k+ users and it worked a treat. Happy to post the finished script for my forum when I can iron out the final bugs :cheese:

Hi,

Just a quick question:

Thanks for posting this fantastic script. I’ve been working on a few improvements such as the adding of number of posts and topics to a user’s account. I’m having the trouble with the closing quotes though and am wondering what you did to resolve this?

That is automatically done EE if I am not mistaken. I know once I import that data, and then recount the statistics under utility, those numbers show up accurately on my site already. Would you be able to expand on your changes?

I have not fixed the closing quotes, but I have made a number of other improvements to the script, like being able to use it on an existing install of EE. Perhaps we need to congeal our efforts so we are not stepping on each other?

Just to add that this will do it, but don’t know if it will affect anything else (and there’s probably a nicer way!)

$postbody = str_replace('"]','" date=""]',$postbody);

Hi, Just a quick question: That is automatically done EE if I am not mistaken. I know once I import that data, and then recount the statistics under utility, those numbers show up accurately on my site already. Would you be able to expand on your changes? I have not fixed the closing quotes, but I have made a number of other improvements to the script, like being able to use it on an existing install of EE. Perhaps we need to congeal our efforts so we are not stepping on each other?

It didn’t do this for me. Maybe I did something wrong as am new to EE but everything else worked as it should. This is what I used to determine total topics etc… but clearly not needed if this works through EE. $row[‘user_posts’] is simply obtained straight from PHPBB database.

//Determine total_forum_topics for user from PHPBB
        $query_forum_topics = 'SELECT Count(`phpbb_topics`.`topic_poster`) AS forum_topics FROM '.$SQL['phpbb_db'].'.phpbb_topics WHERE `phpbb_topics`.`topic_poster`= '.$row['user_id'].'';
        $result_forum_topics = mysql_query($query_forum_topics);
        if (!$result_forum_topics) {
       die('<pre> Invalid query: ' . mysql_error().'
'.$query_forum_topics.'</pre>

<p>’);
        }</p>

<pre><code>    $row_forum_topics = mysql_fetch_array( $result_forum_topics );

    //Forum posts = user_posts - forum topics, so as not to be counted twice
    $forum_posts = $row['user_posts'] - $row_forum_topics['forum_topics'];</code></pre>

Also, working on private messages as only got inbox and not sentbox

This script worked great, thanks guys for working so hard at it.

I have a question however, I would love to make it so that my current Admin login in EE (screen name = Adam Beazley) can link to all of the posts that I made with the adambeazley username in phpbb. Is this possible?

Here is what I mean: In the phpbb forum I used my adambeazley account to make most of the posts and replies in the forum. That was my main moderator account and now that the forum is in EE and I am always logged in as Admin, making changes and writing stuff, I woudl love for all those posts made by adambeazley to link to the admin member (screen name = Adam Beazley).

Let me know if this is possible, Im sure it has something to do with making some changes in the database via phpmyadmin.

Thanks again,

Adam

Dear all–

originally we had to make a conversion from phpBB to EE forum and I had posted the script in PHP format. I have since removed the script from the server for two strong reasons:

1.) it was not supported and was an early prototype model 2.) we set up a small business dealing with issues like this: crazyhungarians.com

I hope this does not qualify as an obstrusive advertisement, if you think it does, then the thread moderator is asked for intervention.

Hi I ran the script and after the user user #1271 this error appear:

Warning: Missing argument 1 for forumImport(), called in /home/beatgnew/public_html/bg3/phpbb_to_ee_converter/convert.php on line 110 and defined in /home/beatgnew/public_html/bg3/phpbb_to_ee_converter/convert.php on line 257

Warning: Missing argument 2 for forumImport(), called in /home/beatgnew/public_html/bg3/phpbb_to_ee_converter/convert.php on line 110 and defined in /home/beatgnew/public_html/bg3/phpbb_to_ee_converter/convert.php on line 257

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/beatgnew/public_html/bg3/phpbb_to_ee_converter/convert.php on line 266

Invalid query: Unknown column ‘0x’ in ‘field list’ INSERT INTO beatgnew_eemain.exp_forums (forum_name, forum_description, forum_is_cat, forum_parent, forum_permissions) VALUES (0x4265617447616D696E67, “”, “y”, 0, 0x)

What can I do?

I appear to have been unsubscribed from this thread. Sorry about the long absence. What with work and all.

Which version are you running of the script that gave you that error. No guarantees, but I will try to take a look this week and see what is up.

Oh, and what version of phpBB are you upgrading from?

Thanks for your reply.

phpbb_to_ee_converter version: 0.2.1a phpBB version: 3.0.RC6 EE version: 1.6.7

The script won’t work on phpBB 3. It is intended for phpBB 2 only.

So.. Im f*cked.

Are u planning to make a new version for your script? I can donate you for your work.

Hey, guys. I’m astounded that this thread is still kicking so hard after all this time. I suppose there’s a lot of interest in moving from phpBB to EE Forums. I’ve had a similar experience migrating a PHP Nuke site to EE and maintaining the forums, and I’ve almost got all the pieces right. I’ve written my migration script directly in SQL (I’m an uber-nerd, I know), which so far has successfully imported all the users, forums, topics, and posts from the phpBB that Nuke uses. The only kink left is the manner in which EE handles forum categories, which differs from phpBB and is tripping me up. I may have the answer I need from the importer script, and I’ll certainly post an open-source version of the PHP Nuke migration. Anyone who’s still interested in the straight phpBB to EE Forums migration script, please PM me. I don’t get out to the forums, much. 😉

Seriously if it wasn’t for plattapuss and their amazing script I would have never made the transition to the EE forums from phpBB. It had some issues, but those were taken care of. I still follow this thread since it was the only thing that actually sold me on the EE forum module. On those notes go back a page or two in the thread and plattapuss’ attachment should still be there. It may not work as well as it did back in the day, but it should give hints at what you need to do.

Hey, all. Just giving some progress. I’m quite close to done with my migration script, and I’m in the “heavy testing phase”. The data that I’m using seems to import quite regularly, although I’m finding a few tweaks here and there that are necessary. I’m sure that I’d find more and improve the script immensely with a few more data sets. Does anyone have a phpBB2 SQL dump that I could try?

The approach that I’ve taken actually permits me to import data into an existing EE installation, even one with active forums, and produce the desired effects. I admittedly haven’t tried importing forums into a database pre-populated with users… Although that’s a reasonable next improvement. Any interest here, or should I open another thread?