I am trying to import my phpbb forum into bbPress. I put all the correct values in for the database but it comes back and says:
Conversion Complete
No reply_to parents to convert
No replies to convert
No tags to convert
No topics to convert
No forum parents to convert
No forums to convert
Starting Conversion
The tables are loaded with forum data. Any suggestions?
Apologies, snow & under are a couple of terms that come to mind.
I just imported your data into a clean MySQL database and everything imported correctly.
(The one side note is a couple of BBCodes, [align & [flash weren’t converted to WordPress ‘safe’ HTML, but that is another issue.)
Where to from here I am not sure as ‘your’ content appears fine at my end and isn’t causing the importer to miss/fail etc.
I think the next step would be for you to try this on a local install:
MAMP if you use Mac http://www.mamp.info/en/mamp-pro/index.html
XAMPP if you use PC http://www.apachefriends.org/en/xampp.html
Setup and install WordPress & bbPress in this install.
Export your entire phpBB database and import it into your local setup and give that a go.
https://www.phpbb.com/kb/article/transferring-your-board-to-a-new-host-or-domain/
My theory here is there could be ‘something’ going on with your web hosts configuration and if the local import works we can then export this data from WordPress on your local host and then import this into your remote host.
@netweb I’m not sure if you’ve missed the post or if you’re understandably busy, but thought I’d give this a “bump”.
Thanks for the feedback and as time goes on more and more bits keep getting added 🙂
If you do decide to give bbPress another shot the phpBB importer is pretty awesome so it shouldn’t be too hard to have a play in a dev site now and then either 😉
I had a custom php site running phpbb, and I’m designing a WP site to replace it. I was planning on using forum software that would integrate with WP and settled on bbpress as the only free (or inexpensive) option.
But now I’m planning on sticking with phpbb, even though it won’t integrate with WP like I want it to. I was willing to install a handful of plugins, but it looks like I’m going to need 20 or 30 plugins just to get some basic functionality for users and the admin. That’s even considering that my user base is not technically oriented and many phpbb features are unnecessary. My site has a single column layout with a header navigation, so the login and other widgets aren’t very useful for me. It looks like it’s possible to get bbpress set up the way I want with enough coding, but I guess I was just hoping for more of a plug and play solution to get my new site up and running with.
I hope you will keep developing bbpress to be a more complete solution.
Thanks for your continued effort at trying to help problem solve! I don’t understand “There are two export labels” or see a “Query results operations’ section” so apologies if I’m missing something. Here are the steps I’m doing, let me know if I need to do something different and I’ll redo (using second query as example)
Run SQL query:
I choose “Export” on bottom right:
I leave Export option “SQL” button selected in upper left, I’ve left all other options as 1and1 default, and saved as “zipped”
OK, turns out the CSV won’t cut the mustard in this case, so these two queries match the results of the last dataset you send me.
SELECT * FROM phpbb_topics WHERE phpbb_topics.topic_id > 330 AND phpbb_topics.topic_id < 338
SELECT * FROM phpbb_posts WHERE post_id IN (3810,3819,3840,3851,3862,3863)
Can you run both of those queries and this time when you click export (There are two export labels, click the one in the ‘Query results operations’ section)
This time you only need to select ‘quick’ and format ‘SQL’ and zip both thos files and attach a link here.
Topic 333 was the last Topic to be posted that will import over, but several Posts made after that make it from the next day, from that topic and others.
Yeah, once you directed me into my phpadmin, I looked at the tables of those posts (had never done that before) and they all look exactly the same. It must be another table that’s throwing the bbPress importer off.
Edit: I just noticed they’re in a weird order:
331
333
—————————————
332
335
336
337
The two above the line will import over, nothing after will. Notice how “332” is under the line, even though it would fall in between Topics 331 and 333. Not sure if it’s a clue or if this is totally normal.
I have the file (and removed the link in your post above).
Which of those topics are and are not getting imported as all 6 (331-337) look fine to me and ‘should’ import without issue.
Alrighty, thanks so much for your help! I was thinking “no way someone’s going to want to help with this mess” and didn’t rush to check back (think I needed a small break too.)
Thanks too for the detailed “how to”! I followed your instructions as well as I could, some discrepancies in options available, so hopefully I’ve got the info you need to take a peek at what’s going on. If gzip doesn’t work for you let me know and I’ll zip or not, upload another version.
With some luck after we work out what is going on in that other thread you won’t need to do this, that said it does need doing a simple UPDATE query is all that will be needed.
This is a good query to have a look around and see the data matches based on what the IP was of the post and the users last known IP address, this no doubt is not going to be accuate if the users IP changed from their first post to their last post and maybe every post in between.
SELECT
phpbb_posts.post_id, phpbb_posts.poster_ip, phpbb_posts.post_text,
phpbb_users.user_id, phpbb_users.username, phpbb_users.user_ip
FROM phpbb_posts
LEFT JOIN phpbb_users
ON phpbb_users.user_ip = phpbb_posts.poster_ip
It would be much better to do an update query using phpbb_posts.poster_id if your database tables are not in a mess but that won’t be known until the other thread is resolved.
The best idea I have at the moment would be for you to post on http://pastebin.com or http://gist.github.com an excerpt of your phpBB table with a couple of entries either site of this mysterious ‘5 month mark’
Fire up phpMyAdmin and open your phpBB database:
Run the following query substituting > 5 & < 15 values with appropriate values from a couple of rows that shows what data IS being imported and also what is NOT.
SELECT *
FROM phpbb_topics
LEFT JOIN phpbb_posts ON phpbb_topics.topic_first_post_id = phpbb_posts.post_id
WHERE phpbb_topics.topic_id > 5
AND phpbb_topics.topic_id < 15
Now at the results of that query at the bottom of the page is export click that and select Custom - display all possible options select the format as CSV and check the Put columns names in the first row check box.
Upload that file somewhere and post the link here (or send me a DM on Twitter) and I can have a look at exactly what is going on.
Edit: fixed mysql code formatting
Anybody know of a way I can assign posts to authors by their ip? All my imported posts are being assigned to the admin 🙁 but they have the correct ip’s attached to them. I did opt to import users with the posts.
WP Version: 3.6.0
bbPress Version: 1.8.1
I’m importing from phpBB3 and yes I synced everything in phpbb3 first and then in bbPress after 😉 I am also having other issues that I’m trying to get support for in another thread (posts only import up to five months ago)
Now I have disabled Kiss Portal, purged the cache in phpBB3, resyncronized in phpBB3, imported to bbPress, and resynced there and still upon import only get posts up to five months ago.
Anybody have a clue what the issue might be or know of a resource that might show me how I can retrieve my posts from phpBB3 into bbPress by hand?
I have followed WP-United author’s instructions for removal by disabling in WP, removing the code (by hand to be sure) from all phpBB3 files and deleting WP-United files from phpBB3, deleting the plugin in WP. I then purged the cache in phpBB3, resyncronized in phpBB3, imported to bbPress, and resynched there – – Still only get posts up to five months ago 🙁
Maybe it’s the Kiss Portal that’s causing the issue? Maybe it puts a difference in the database that the importer doesn’t recognize?
Yep, as mentioned, I tried it with WP-United disabled and recalculated in phpBB3 first then in WordPress bbPress after the import, each one. My next step is removing it altogether and trying it then. I’m not sure what changes WP-United might make on the database, but phpBB3 does have an Auto Mod package that is part of the process so I’ll have to remove it from phpBB3 too before I can try again. I’ll try to come back and report what I learn! 🙂
Are you running the ‘Repair Tools’ after importing to recalculate the counts?
As the importer is running SQL queries grabbing ‘all the things’ directly from the phpBB MySQL database this should not be an issue.
It should not be missing anything, but, thinking about this for a moment, do you know if WP-United alters any phpBB or WordPress database tables? If so do you know what changes it makes?
What happens if you disable WP-United plugin before importing?
What happens if you delete WP-United plugin? Does it uninstall any changes it made?
(If you try deleting WP-United make sure you have website and database backups)
I’ve resychronized the phpbb3 forums and begun the conversion process by “Purge all information from a previously attempted import”. I then reimported also bringing the members this time and… still only up to five months ago 🙁 Wait, I wonder if that’s when I installed WP-United. I disabled the plugin, but maybe it’s somehow messing with the import process. Is there any way to import some phpbb3 tables into bbPress “by hand”?
You may be surprised to see my bbPress forum
“Internal Server Error” 😉
Yeah, another issue I was having is my phpBB3 private forums copied over public, and when I’d go into bbPress and choose “Hidden” and save it would refresh as “Open” again :/ so I deleted the forum. When I did that all hell broke loose for several hours. Server company said that phpBB3 was putting too much of a load on the shared server. I guess the import process put me close to the limit and the deletion process put me over.
I’ll try your suggestion, thanks.
Here’s a screenshot of the forums, Gyazo’s finally back up: http://gyazo.com/ef928ad4738251e1bd6ab1c39a0b710b.png
First up, make sure you have run the phpBB recount tools which ‘should’ make sure phpB database is in good shape before you get started.
The importer is designed to import your users from phpBB and that is where your problems will now be as you already have some users in WordPress…
During the import the importer if it finds a username already exists eg ‘username’ it will create a new user with a prefix ‘imported_’ eg ‘imported_username’.
After the import is finished you can use WordPress’ user admin panel to delete (one by one) each ‘imported_’ user and as you do you are presented with the option to reassign all posts to another user, select the user you want from the dropdown list and your done.
This gets painful very quickly if you have 1,000 users to do this to one by one.
You may be surprised to see my bbPress forum
“Internal Server Error” 😉
Hello, I am once again seeing if I can switch over to bbPress, since WP-United does not play well with so many phpBB3 and WP social extras, and upon import I am only getting posts up to four months ago, with nothing for the last four months. Also, somehow the import process is switching some authors. I’m not sure if I should be importing the users or not (I think I’ve tried both), or what the best practice is since I already have a WP userbase of the same people who made the posts that I’m importing from phpBB3. In fact, because of WP-United, they are linked in some way.
Any help would be appreciated! I’ve been at it for a number of days. My WordPress version is 3.6.0 and my bbPress version is 2.4.
You may be surprised to see my bbPress forum: I’m currently altering the css to make it look like my phpBB3 one, using @Lynq’s bbPress starter theme and Daniel St. Jules’ CoDFaction phpBB3 theme.
Forums
About a week ago, I asked how to change the directory of the forum I’m setting up in dev. At the time, I had a bare install, and the response I received seemed to meet my needs.
However, this simply moved the index page. At this point, my database guy has started importing the data from my existing phpBB3 forum, and what seemed to be an elegant fix has left me with the same problem I had before. The index page looks great, but when you click through to ANY category or forum, the board immediately takes you from:
Home/Classrooms/Forums
Which is the setup I need, to…
Home/Forums
Which is going to dump my signed-in students outside of the classroom when they use the breadcrumbs.
Basically, I need to find a way to have my forum and topic posts and their hierarchy recognize the Classroom page as their parent. Or something that will give me the same result when my users try to navigate the breadcrumbs back to their classes.
A hierarchy function like phpBB is not yet possible, without hacking your theme. You can find that hack here on the forums.
I have been looking around & i do not know if it’s some thing I am doing wrong or if it just the Layout of the plugin.
I am trying to get a layout like…
{Forum Name}
Forum Objects “Forums”
{Topics}
It is hard to place an image into words.
But like PhpBB.
Sorry for the bad description.
Thanks.
Is there any way to bulk-move topics?
I run a Once Upon a Time podcast and forums with bbPress. We have a spoiler section for each episode of the TV show. After that episode has aired, I like to move the spoiler topics into the main discussion for the TV show. This was easy with phpBB, but bbPress doesn’t seem to offer this feature.
When I go to Admin > Topics and filter the list by a forum parent, I have no options for changing that forum parent or moving the topics in any way.
How can I do this easily on a regular basis? Editing each topic individually is not practical.
