thanks a million. i will test it out and see if i can get it to work.

rspowers - try this one http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release

<blockquote"mapping is maintained between old and new user/post/topic/forum ID values"

With that, you could create some simple redirects from old URLs to new URLs and those old links will work.

I was looking at this conversion again and one really useful thing it misses out is converting internal links - eg: if someone has posted a link to a certain topic within the forum, the link will no longer work.

If it could convert from the standard phpbb format eg: forum/viewtopic.php?t=7836
to the default bbpress format eg: forum/topic.php?id=7836

or does the smilies conversion only search for standalone text (ie: it wouldn't convert phrases within a string)??

would adding something like this to the smilies conversion section work?

'viewtopic.php?t=' => 'topic.php?id=',

I guess you could also write a new viewtopic.php file that could parse those links, although that's a bit of a workaround.

I just got a test conversion to work so will start to check out possible plugins etc next! Thanks for the help, hopefully bbpress can continue to grow!

For those interested in beta testing, the plugin (at present) is grossly inefficient as far as memory goes and now that it works at a basic level, I'm looking at optimizing & reducing memory footprint.

paulhawke - this sounds great for the future, having a more user-friendly way to convert will open the door for a lot more people to use bbpress. Any plans to copy of private messages?

The "Import" plugin needs beta testers who're willing to give it a run through and provide feedback.

The plugin reads data from the phpBB database, and rather than generate an enormous SQL file that is version specific, the plugin calls the same internal methods inside bbPress as occur when you manually create forums/topics/posts/users. A mapping is maintained between old and new user/post/topic/forum ID values, and referential integrity is maintained throughout.

So check your Apache error_log or your PHP error log to see if it is running out of memory... then give it as much as you can.

the script says it's connected to the server and exporting the forums/users etc but nothing comes up after 'Sending all your database e-mails to all major world-wide spam sending mafias...' - I'm waiting for it to say its exported the new db, or give me an error message, but nothing else happens.

Any ideas?

thanks in adance!

Still... I'd be eager to hear from anyone that has converted a 100,000+ post site with the script for any info or tips.

We’re trying to move from phpBB that we’ve had for 5 years to bbPress. obviously, the 2 databases don’t match at all. We found this script. Can someone please update on the best way to migrate from a very active phpBB forums to bbPress? Has there been any new updates to this script?

Thanks.

Follow the steps that come in the given file but make sure to:

1. Install bbPress 0.7 first, then upgrade to 0.8 when you have done the conversion. You can download 0,7 here: http://bbpress.org/forums/topic/download-previous-versions-of-bbpress#post-17770
Then you can go ahead and upgrade to the latest version (1.0.2). Make sure you update the settings in your admin panel (board path, name, etc) as you will need to get rid of your old config.php file when you upgrade to 0.8
2. If you're hosted on 1and1, switch EXPORT_TO_FILE to false and AUTO_IMPORT_EXPORTED_DATA to true. Also add teh following code to your .htaccess file: AddType x-mapp-php5 .php (not sure if this is necessary but it worked for me).
3. I got an error saying that some query was empty, but it seems that the conversion went without any problems.

after the script runs, isn't there an sql file that's supposed to be generated from the old board & saved into a /tmp/ folder?

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/public_html/bbs08/phpbb2bbpress.php on line 922

When I run the file I just get this message. There isnt a sql-file to download or a file created on my server.

1: I downloaded the file from: http://www.iteisa.com/phpbb2bbpress/

2: I edited the lines I have written in bold.

[code]
define('DB_PHPBB_USERNAME', '[strong]databasename[/strong]');
define('DB_PHPBB_PASSWORD', '[b]databasepassword[/b]');
define('DB_PHPBB_DATABASE', '[b]databasename[/b]');
define('DB_PHPBB_TABLEPREFIX', 'phpbb_');

define('DB_BBPRESS_HOSTNAME', 'localhost');
define('DB_BBPRESS_USERNAME', '[b]databasename[/b]');
define('DB_BBPRESS_PASSWORD', '[b]databasepassword[/b]');
define('DB_BBPRESS_DATABASE', '[b]databasename[/b]');
define('DB_BBPRESS_TABLEPREFIX', 'bb_');[/code]

I only have one database on my server, so the databasename and password is the same on the phpbb and bbpress part

[code]define('EXPORT_TO_FILE', true); // Should the converted DB be exported to a file ?
define('FILENAME', '/tmp/phpbb_imported.sql'); // Which one ? (Ensure this path is writeable by the server)
define('AUTO_IMPORT_EXPORTED_DATA', false); // Should the script automagically import the converted DB ?[/code]

3: I created the folder tmp at the root and used chmod on it.

4: I uploaded the file to the root and tried to open it but I couldnt. So I removed the s in .phps and it worked. But i only got this message - but nothing really happened. I cant download a file, and there is nothing on my server. What am I doing wrong?

[quote="Q!"]phpBB to bbPress database converter

This script can convert a PhpBB 2.0.X (www.phpbb.com) forum database to bbPress "Bix" 0.73 (www.bbpress.org) format.

Developed by Jaime GÓMEZ OBREGÓN from ITEISA, based on the previous work of Bruno Torres and The phpBB Group.

The latest version of this file can be found on http://www.iteisa.com/phpbb2bbpress/.
Starting conversion

1.
Connected to the phpBB database host
2.
Selected the phpBB database
3.
Exporting forums...
4.
Exporting users...
5.
Exporting user metadata...
6.
Exporting topics...
7.
Exporting posts...
8.
Sending all your database e-mails to all major world-wide spam sending mafias...[/quote]

'strong'dsfgds'strong'

Now I'm getting this error:
Unknown column 'topic_resolved' in 'field list'

This is the error I get:
Table 'khanlon_db3.henskebb_users' doesn't exist

And that makes sense, since I already set up bbPress to integrate with WordPress. Since bbPress is using the wp_users table, the script doesn't know where to put the phpbb users.

As it stands now, bbPress shows all the topic counts for each forum, but when you click on the forum, none of the threads are listed.

I tried exporting all the users using phpMyAdmin and importing into the WP table, but the threads are still missing.

Fatal error: Call to undefined function: file_put_contents() in phpbb2bbpress.php on line 383

Can anyone tell me how I can resolve this.

I also notice that this converter has not been updated, is it going to be anytime soon?

AND whilst converting WHY does it STATE that all emails are being forwarded to SPAMMERS? (Can't remember the exact words). Is this meant to be a joke?

Thanks in advance.

http://bbpress.org/plugins/topic/16?replies=7

Otherwise you could edit the php file and remove the bits about the topic_resolved column (remember to back up the original file in case it doesn't work!).

#
Warning, there was an error with the following query

#Exporting Topics: INSERT INTO bb_topics (topic_id, topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id, topic_status, topic_resolved, topic_open, topic_last_post_id, topic_sticky, topic_posts, tag_count) VALUES ( 4, 'Pravila!', 2, 'Zala', 2, 'Zala', '2007-02-13 16:13:01', '2007-02-13 16:13:01', 1, 0, 'no', 1, 765, 0, 2, 0)

Unknown column 'topic_resolved' in 'field list'

...

And a lot more of them. I don't know much about php really, so I have no idea what is wrong. It's probably a stupid mistake I made, but I don't know what it is. Help me, please?