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.
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?
@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 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”
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.
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.
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! 🙂
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
Depends on what you are looking for. What’s your site?
Copy all the files to your themes root directory and it should look something like this:
/wp-content/themes/my-theme/bbpress-functions.php
/wp-content/themes/my-theme/bbpress
/wp-content/themes/my-theme/css
(Where ‘my-theme’ is the name of your theme, there is nothing you need to activate.)
Now I am *really* confused! Because the file I downloaded for this theme is called “default”, and none of those files are in it 😀
Hello, thank you for creating this theme! I am trying to install it and have copied the “default” file into my theme’s root. Was I supposed to only copy the files inside the default file? I don’t see any difference in my bbPress look.
Or is there somewhere on my dashboard I have to activate it?
Thanks 🙂
For anyone else looking for this info:
First forum page (if using [bbp-forum-index] shortcode): wp-content>plugins>bbpress>templates>default>bbpress>content-archive-forum.php
Second forum page (if using forum categories and click on a category): wp-content>plugins>bbpress>templates>default>bbpress>content-single-forum.php
I just want to know which files in bbPress create the layout on the first page of a forum and which files create the layout on a forum category page, can anyone tell me?
Sorry about that, all my websites crashed shortly after I posted that 🙁
I don’t know why the bbPress forum page took you to registration, but I made it so anyone can post, so you should be able to see it now, thanks.
Well, I’ve created a page and am using the shortcode and it seems to bypass the issue. For anybody having this layout trouble, the shortcodes can be found here:
https://codex.bbpress.org/shortcodes/
Thank you for your quick response, I guess what I’m trying to convey is my uncertainty whether or not I can just plug that code in and rename “foo” anything? I don’t understand why I have to rename the foo, so I thought perhaps there was another step as well it was assumed I would know. (aka: you also have to put “” into your html)
Sorry I’m such a “foo” when it comes to coding 😉 I’m learning as fast as I can!
Wait, I might understand! We rename “foo” so we can recognize what it does when we’re looking at the code?
Nope, I had tried that and something weird was happening, can’t remember what it was. But it seems to be auto generated, even putting itself in my menu bar after I’ve elected to put my own custom menu there.
Interesting. Any idea how that happened?
I can easily get any file via ftp and edit it, put it back, but I’m fairly new to coding. Can you tell me where I would find bbp_forums? This is in an html file…?
I’m just recently testing bbPress, my theme is dark and the default editor doesn’t look well with it. Perfect solution? The editor color options available through Ultimate Tinymce! 😀
So, my question is: Do I have to rename “foo”, or will it work if I just paste that into my functions.php?
Signed,
Complete and Utter php Newb
Ok, it looks like it’s converting. Here is what I had to do for 1and1 hosting:
In Import Forum settings, make sure your “Database Server” is filled in, use the Database User attached to your database, not your FTP User Name, and you should be good to go 🙂
Now to have someone take a look at my first forum page and tell me if that’s what it’s supposed to look like…
Thanks for your encouragement, Stephen, the “well, it’s supposed to work” is what kept me at it!
Yeah, I made sure that phpBB was selected. I was just now re-checking over everything again and I see that my database has two User ID’s, one attached to the database and one for FTP. Assuming this process works like FTP I then made sure to run it again with the user name I have for accessing via FTP and I get the first message:
“Repair any missing information: Continue
Conversion Complete
No replies to convert
No tags to convert
No topics to convert
No forum parents to convert
No forums to convert
No passwords to clear
No users to convert
Starting Conversion
”
I’ve even tried it by replacing “localhost” with my database’s Host Name. Same result. I double-checked that Database Port is the default, 3306, yep.
Do you know which User Name I’m supposed to be using? The one that has my database id in it, or the one I use for FTP?
Also, does anybody know what it does if your FTP password is incorrect?
