[heroyouwi]

hello, about phpbb 3.2.9, i mapped the corrent column in the script convert : phpBB.php
i have a heavy phpbb forum : 16 forums, 3000 topics, 95000 posts, 3000 users, all successfully imported in bbpress 2.5
here my fix :

phpbb 3.2.9 fix bbpress import

enjoy it

[heroyouwi]

hello, about phpbb 3.2.9, i mapped the corrent column in the script convert : phpBB.php
i have a heavy phpbb forum : 16 forums, 3000 topics, 95000 posts, 3000 users, all successfully imported in bbpress 2.5
here my fix :

phpbb 3.2.9 fix bbpress import

enjoy it

[heroyouwi]

hello, about phpbb 3.2.9, i mapped the corrent column in the script convert : phpBB.php
i have a heavy phpbb forum : 16 forums, 3000 topics, 95000 posts, 3000 users, all successfully imported in bbpress 2.5
here my fix :

phpbb 3.2.9 fix bbpress import

enjoy it

[telium]

(I also tried converting all of my phpBB tables to utf8mb_unicode_ci but that didn’t help).

The onscreen status is very high level. Is there an import log somewhere that might provide more details- pointing to something I can fix? I’m comfortable altering the MySQL structure of phpBB if needed.

[telium]

I had the same problem (with phpBB 3.2.4) and no users importing. I tried creating a new founder and downgrading everyone else to standard accounts.

It still won’t work. Was there anything else you did?

[telium]

I have a fresh bbPress install and want to import everything possible from my phpBB version 3.2.4 installation. The import runs and step 8 is importing lots of anonymous topic authors.

However, why aren’t my users importing? Based on other posts I ensure no topics/threads are attributed to founders/moderators/admins. (I created a single founder account and downgraded everyone else).

I see some references to a 3rd party import script, and other references saying its not needed. Can someone help? It’s Jan 15 2020 and I have the latest bbPress. Note sure hot to proceed.

Excerpt from log:

6.No forum subscriptions to import
5.All forum parents imported100%
5.Calculating forum hierarchy (0 through 11 of 11)0%
4.All forums imported100%
4.Converting forums (0 through 16 of 16)0%
3.No passwords to clear
2.No users to import
1.Skipping sync-table clean-up

[forumhierarchyhangs]

All right, I’ll make a post. Usually try everything under the sun to troubleshoot things myself, and I’m usually successful, but this one is giving me fits. I’m importing a phpbb 3.1.9 database into the current release of bbPress. I plugged the MySQL database into my local server (it’s my box, I have full access) and pointed the importer at it. No problems up to that point. It creates users, deletes their default passwords, converts the forums, and then just continually tries the “Calculating forum hierarchy (X of X)” step over and over and over. I’ve tried restarting it, clearing previously-imported data, etc. – no dice.

I can get at whatever files might be necessary to get this working. This is a cluster of a migration on a few levels, so any assistance would be appreciated immensely. 🙂

[kriskl]

I know about aravatars. when I turned them on after migration fro phpbb – lost of users got pissed off, and left to other similar forums which provide what our forum does…

But at least buddypress allows uploading the avatar..

IMHO not being able to upload their own avatar.. but having to register and use aravatars.. is a major drawback in otherwise great BBPress

[jdgmedia]

I am trying to migrate from phpbb.

However, I have a very large phpbb forum that has hundred of thousands of rows to migrate (and obviously pressing continue every 5000 rows is tedious).

Is there a better way of doing this?

I am only really that bothered about keeping the users and the posts.

[tomijolkkonen]

phpBB version is 3 but not the newest version of it. I’m doing this for another person, who has custom code on the site and he said that he is unable to update the version.

The row amount. I get the same results with either 100 or 1000.

The problem is just that it doesnt recognize the forum folder to get the top parent forums. 2nd problem. The importer changes posts into replies and now every post is a reply.

[John James Jacoby]

Which version of phpBB?

1000 rows at a time is pretty high. Make sure you have quite a bit of RAM/memory available for that many at once.

[tomijolkkonen]

I am trying to import from an old phpbb forum to bbpress using the tool. I run it with row limit 1000, I have used 100 and it worked with the database. The problem is that it turns every post into a reply. They are in the same folder when importing from the phpbb database. Also it does not recognize the forums folder.

The forum folder is named: phpbb_3forums and the folder that contains both posts and replies is:phpbb_3posts. So I dont know why the forums don’t get recognized and why posts and replies get clumped up together.

This was not the problem in the last version. Last time I was just getting timed out but the Forums worked and pulled about 5k posts and the parents were done right. I have tried running the repair tools but doesn’t work.

[wurkagency]

Hi All,

Had the same issue as described above. The default phpbb.php import script didn’t convert anonymous users of topics and replies and the Pixenated script looped infinately with the conversion of users.

I’ve fixed the script and uploaded to PasteBin. Feel free to share widely.
https://pastebin.com/0QQbxL4z

How To:
1) Upgrade phpBB to v.3.2.5+
2) Install BBpress 2.6 RC7
3) Upload to /wp-content/plugins/bbpress/includes/admin/converters/phpbb.php

Remember that real men don’t do backups. They cry a lot.

[nicely]

I got it to work. I updated my phpbb install to 3.2.8 and used wurkagency’s script (https://pastebin.com/0QQbxL4z).

[nicely]

I’ve tried to import my phpBB users using bbPress 2.6.1 and also the above fix from wurkagency and am getting…

3.No passwords to clear
2.No users to import

…during import.

I tried demoting any admin/founders with any content as HammyHavok suggested with the same results.

Any advice or suggestions would be greatly appreciated.

[wurkagency]

Here’s a fix.
https://pastebin.com/0QQbxL4z

– Paste into ‘phpBB.php’ file and save in /wp-content/plugins/bbpress/includes/admin/converters/phpBB.php

Remember to back up the old phpBB.php file first.

Godspeed…..

[Hammy Havoc]

When I try the fix on https://bbpress.org/forums/topic/fix-for-phpbb3-to-bbpress-conversion-script/page/2/#post-205592, I get this error on an endless loop:

Converting anonymous reply authors (100 through 100 of 100)

[Hammy Havoc]

Hi everybody!

I’m having some problems importing from the latest phpBB into the latest bbPress.

I get the following error:

1. No passwords to clear
2. No users to import

Everything else appears to import as expected.

[Chuckie]

Thanks for this Pascal. At the moment I can’t do anything because I have that stickies loop issue and the final imported topics don’t seem right. The primary list of topics is fine but then all the replies are not there. I can compare the existing phpBB forum against the results to know.

I will wait for a reply about the recurring loop issue first.

[Chuckie]

My phpBB database is 3.2.7

I was trying to look at your source code for the phpBB importer but I can’t quite follow the logic.

[Chuckie]

I was not able to use the previous phpBB importer as it was failing right at the start. This new version seems to work better! However, I have some comments about this.

1/ A possible problem.

Here is my log (which I paused in the end):

Import Stopped (by User.)

9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%
9.Calculating topic stickies (0 through 99 of 100)0%
8.No anonymous topic authors to import
7.All topics imported100%
7.Converting topics (900 through 928 of 928)90%
7.Converting topics (800 through 899 of 928)80%
7.Converting topics (700 through 799 of 928)70%
7.Converting topics (600 through 699 of 928)60%
7.Converting topics (500 through 599 of 928)50%
7.Converting topics (400 through 499 of 928)40%
7.Converting topics (300 through 399 of 928)30%
7.Converting topics (200 through 299 of 928)20%
7.Converting topics (100 through 199 of 928)10%
7.Converting topics (0 through 99 of 928)0%
6.No forum subscriptions to import
5.All forum parents imported100%
5.Calculating forum hierarchy (0 through 25 of 25)0%
4.All forums imported100%
4.Converting forums (0 through 30 of 30)0%
3.Skipping password clean-up
2.Skipping user clean-up
1.Skipping sync-table clean-up
Starting Import...
Ready to go.

The issue was step 9 where it seemed to be in a ever repeating cycle of:

9.Calculating topic stickies (7 through 100 of 100)100%
9.Calculating topic stickies (100 through 7 of 7)100%

2/ Feature Request

Because I was not able to previously import content I came up with a new simplified set of forum categories etc in my bbPress forum. Therefore, ideally I would love to be presented with a list of forums that are going to be imported so that I can map them to the existing forums I have created. So some would be merging several into one if that makes sense.

At the moment (even though I hit stop on point 9) I was able to view the forum and could seem many boards imported – a quick look it looked great. It is just that I wanted control over how the topics were imported. Thus my idea for the mapping from old forums to current forums.

Can this be done?

Please let me know if I need to give more info.

I don’t know if this should be a “trac ticket” or not.

Well done guys.

Andrew

PS. The related question (which can be closed and linked to this new one is: https://bbpress.org/forums/topic/importing-from-phpbb-5/).

[estefa37]

Hello everyone.
I am looking for some help here.
I am trying to migrate a rather large forum from phpbb to bbpress using the bbpress importer.
I filled the details with the right database information and started the import.
However, it keeps showing me an error and does not let me import anything.
When I click on “start” the import, it inmediately shows this text:

Repair any missing information: Continue
WordPress database error: [Unknown column ‘topics.topic_replies’ in ‘field list’]
SELECT convert(topics.topic_id USING “utf8mb4”) AS topic_id,convert(topics.topic_replies USING “utf8mb4”) AS topic_replies,convert(topics.topic_replies_real USING “utf8mb4”) AS topic_replies_real,convert(topics.forum_id USING “utf8mb4”) AS forum_id,convert(topics.topic_poster USING “utf8mb4”) AS topic_poster,convert(posts.poster_ip USING “utf8mb4”) AS poster_ip,convert(posts.post_text USING “utf8mb4”) AS post_text,convert(topics.topic_title USING “utf8mb4”) AS topic_title,convert(topics.topic_status USING “utf8mb4”) AS topic_status,convert(topics.topic_type USING “utf8mb4”) AS topic_type,convert(topics.topic_time USING “utf8mb4”) AS topic_time,convert(topics.topic_last_post_time USING “utf8mb4”) AS topic_last_post_time FROM phpbbli_topics AS topics INNER JOIN phpbbli_posts AS posts USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 0, 100
No topics to convertNo forum parents to convert

It only shows that text and does not import anything. All user accounts are existing inside my phpbb database.

Does anyone know why this is happening or how can I solve this in order to make the import?

Thank you.

[Robin W]

I’ve never used phpbb, but suggest you need to get the database loaded somewhere, which will then have access. You can then convert from there

[tomijolkkonen]

Sorry for the confusion. I did mean that I had no access to the old database but I got the sql.gz file of the old database backup that I transferred to a new phpmyadmin that the service provider had made with a wordpress site install. I’m not sure where to continue this anymore. Should I just whipe everything and start over or try to work it out. Again sorry for the confusion. So to put it simply so there is not confusion as I know I’m not the most clear when trying to explain something. I’m making a forum site for father-in-law. He has a old forum still on that is running phpBB. I need to transfer the forum posts etc from sql.gz file to the new site. I don’t know how the transfer tool works and couldn’t find a tutorial. Also if I did get it right I have no idea how to make it show up in bbPress.

[tomijolkkonen]

Ok yes, starting with I’m completely new to this and I need to redesign my Father in laws, forum website. This would be my first time doing this and he said that there is no hurry as he heard from my wife that I know how to code but the thing is I’m only at the basics of C# so not sure if any use here but on to the point.

So he is not able to connect to the old website host site because I dont think it really exists anymore and/or was transferred to another host service. But he has a backup from the old database that used phpBB and he is not really willing to part with everything that was stored in that forum as it contains over 10 years of garthered info on the matter which is central to the forum. So I don’t feel that copying every post would be really a good way as there are around 200k posts on it.
So I have a wordpress site setup with BBpress and have the basics and the serviceprovider has the database on phpmyadmin. I’m looking to use the backup to somehow have the posts etc showup without messing with the actual site but im ok even if it wipes the new design.

I have tried using bbPress import tool but to no avail. I have not found any info considering this. So the old site is still active but I have no access to the old database but I have the old backup. The import tool did not make much sense to me but I tried.For example I am not sure do I use the root name when typing in the database name in the import tool so I have tried to look for a deeper explanation.Also I dont know how the old posts would show up in bbPress.