Thanks very much
It’s a tiny database 455KB, the forum has only one forum, 70 topics. So it seems I can safely assume it’s just not working.
I have all the correct vales, exactly as on the config.php
This is what I see:
“Delete users WordPress default passwords (0 – 99)
Converting users (0 – 99)
Deleting previously converted data (0 – 99)
Starting Conversion”
After an hour or so of this (with the spinning wheel thing) I can go to Forums in the admin dashboard and sometimes there will appear to be a forum with 70 topics, but on the fornt page only a forum with 0 topics.
Other times I try the import and there is just no forum at all.
Is there a premium support for this? I would be happy to pay for some help.
I just found out yesterday that one of the issues I’m having might indeed have something to do with the phpBB3 mod, Kiss Portal. I did take your advice, @netweb, and attempted to install it on a Wamp (this is why it’s taken awhile to get back, my Wamp crashed and I’m troubleshooting), and in the process I’ve discovered that there is a file calling for a phpbb3_k_vars_config table on my Wamp server, even though there is no phpbb3_k_vars_config table in my running board’s database and it’s working fine. The Wamp board crashes saying it cannot find this table. I’m trying to get answers from the Kiss Portal crew, since during the search I discovered this is the same error I was getting when I first installed the portal. They actually went into my database and got it working at that time. But if I’m not mistaken, something in their files is looking for this table. Both boards have phpbb_k_vars_config table, without the “3”. So I might be getting closer to figuring this thing out.
Here is the error, in case anyone has seen this before and knows what it means:
General Error
SQL ERROR [ mysql4 ]
Table ‘*******.phpbb3_k_blocks_config_vars’ doesn’t exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
It depends on the size of your old bb, but should take less than 30 minutes for any install.
@robin-w Not quite true, typically yes, when importing boards with up to a few thousand topics/replies it should be done in under 30 minutes.
Get into the tens of thousands, hundreds and even millions this does take a bit of time. 😉
At what point do I give up and start again. Should it take over four hours?
You should see it start and offer you some sort of notice that it has within seconds.
Via FTP or your web host cPanel admin etc, open your phpBB config file /public_html/phpbbv3/config.php and make sure these are the values you are using on the bbPress importer screen.
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysqli';
$dbhost = 'localhost';
$dbport = '3306';
$dbname = 'my_phpbb_database';
$dbuser = 'my_user_name';
$dbpasswd = 'abcdefgh';
$table_prefix = 'phpbb_';
(The $dbhost & $dbport may be blank as thats the default so use the settings I list above which are the default on the bbPress importer anyway)
Everything is still going fine, I ran some phpBB imports yesterday whilst implementing a few minor updates.
Details are here https://bbpress.trac.wordpress.org/ticket/2467
Feel free to download the latest from here:
https://bbpress.trac.wordpress.org/browser/trunk/includes/admin/converters/phpBB.php
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.
I’m also having a problem importing from phpbb, can you please tell me where I find the phpbb recount tools?
Thanks
You should find it on the first page of your phpBB ACP, scroll down a little.
phpBB3 has had some updates in the last year, I wonder if those updates are making the bbPress importer not be able to do it’s job? Maybe different coding now?
It depends on the size of your old bb, but should take less than 30 minutes for any install.
I am having no luck importing from phpbb (latest version 3.0.12) The importer just seems to hang for hours and hours on “Starting Conversion”
At what point do I give up and start again. Should it take over four hours?
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.
I’m also having a problem importing from phpbb, can you please tell me where I find the phpbb recount tools?
Thanks
Stephen, no luck so far. It seems the problem is with the usermeta data.
Not sure why phpbb to bbpress has issues with passwords. I am able to login to phpbb board seamlessly but the migration is not importing useful passwords.
I can give you access to my cpanel for a closer look the tables you requested. How do I contact you.
I have been trying to import phpbb for several days now. I have 87000 members and the script is so slow. It would seem to be easier to just do it directly in the db. I am having no luck with the import script. First it takes a day to import users. Second the restart script seems to have problems “Deleting previously converted data (6694000 – 6694999)”. I have no clue what it is deleting but there are not 6 million records. No where near.
So is there a guide to doing a manual import directly through db scripts?
Thanks
I’d suggest looking up how phpBB deals with imported vBulletin user passwords, some importers convert the password after the fact, so until userxyz logs into phpBB the password isn’t converted to the phpBB forums format.
Stephen, I was able to convert from phpbb to bbpress and that was really smooth sailing, but now all my migrated usernames’ passwords don’t work. Ironically, for the earlier vbulletin conversion, the passwords were working fine but the threads and usernames were out of sync.
Now, the thread/posts/username relationship is fine, but all my passwords don’t work. I am not sure what the issue is. Hopefully you can direct me in the right direction to get this minor issue resolved.
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
