Hi,
I have the same issue. Do you still remember what you did to fix it and to prevent it from crashing again with next update?
I missed that somehow. Thank you.
OK, I had a success!
Sort of.
What I did was…
- backup everything.
- in your current wordpress, export all data to xml file
- if your bbPress was deeply integrated like mine, you will not have a separate bb_users table. If so, export wp_users table via phpMyAdmin and save it.
- upgrade bbPress from v1.0.3 to v1.2 as per <fontadoni> instructions
- log into bbPress admin panel and let it upgrade the database. I got an error there, but whatever.
- install clean WordPress with same user/pass. Make sure to keep old wp-config.php file.
- if you had integrated users as per #3, go to phpMyAdmin, delete the only (admin) user from wp_users and import your original wp_users table. Check if you can log in. You should to.
- in WordPress admin page, import xml backup of your previous posts. Let it download all media… You will need to install importer plugin. You should be able to see all your blog posts now. On first run, some posts were missing… If so, delete all posts and repeat.
- install bbPress plugin.
- Go to admin page -> permalinks and set “date and name” (at least for me it was needed to be able to access forums at /forums/ instead of seeing 404)
- Go to tools -> Forums -> Import. Provide database login info. It should convert and import your old posts…
- Your forums and all users should be available now. Check if posts have corrects users.
- If this worked, thank me in comments below…
I am still all full at it. What I discovered is that converter DOES work on fresh wordpress and bbpress installations. Of course I have discovered that all imported bbpress posts are by “Anonymous”, because of lost user data… So now I am working on solving that.
OK, so here is what I get when upgrading database to v1.2:
The upgrade process seems to have failed. Check the upgrade messages below for more information.
Attempting to go to the admin area without resolving the listed errors will return you to this upgrade page.
Beginning upgrade…
>>> Modifying database: circuit_circuit (localhost)
>>>>>> Table: bb_forums
>>>>>>>>> Dropping index: PRIMARY
>>>>>>>>>>>> SQL ERROR! See the error log for more detail
>>>>>>>>> Adding index: PRIMARY
>>>>>>>>>>>> SQL ERROR! See the error log for more detail
>>>>>>>>> Dropping index: forum_slug
>>>>>>>>>>>> Done
>>>>>>>>> Adding index: forum_slug
>>>>>>>>>>>> Done
...
SQL ERROR!
>>> Database: circuit_circuit (localhost)
>>>>>> ALTER TABLE <code>bb_forums</code> DROP PRIMARY KEY;
>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key
(same for each table)
Something wrong with my sql import?
If I click Retry, I get this:
Nothing to upgrade. Get back to work!
And admin page loads as usual.
Yeah, I did this so many times that I developed an instinct… And it let me down this time 🙂 So disregard this error.
Maybe it is something with DB upgrade after v1.2 update, when I got error about “failed to drop primary index keys”? I will try to repeat whole 1.0.3 -> 1.2 process once again and report back.
Forum is quite small, around 5’000 posts.
I am trying to reproduce those errors for some time now, but only now I was able to get an error. It’s like something is wrong with my system, as it is too random…
I have lowered post data limit to 128M instead of 1G (it was so high to allow large sql dump upload).
The error is:
Repair any missing information: Continue
WordPress database error: [Unknown column 'forums.fid' in 'field list']
SELECT convert(forums.fid USING "utf8") AS fid,convert(forums.par_board_id USING "utf8") AS par_board_id,convert(forums.ntopic USING "utf8") AS ntopic,convert(forums.nposts USING "utf8") AS nposts,convert(forums.fname USING "utf8") AS fname,convert(forums.description USING "utf8") AS description,convert(forums.forum_order USING "utf8") AS forum_order,convert(forums.status USING "utf8") AS status FROM bb_forums AS forums LIMIT 0, 100
No forums to convert
Starting Conversion
Thanks Stephan. Each one ran fine, I got all the data.
While playing around with import tool yesterday, it sometimes did spit up some random errors, something about syntax… I did not save them and can’t recall what was that about unfortunately. But most of the times it just hangs there. Sometimes I get different results when I change delay time and rows limit.
Maybe it is possible to enable a verbose mode to see if there are any errors during import?
By the way, I’m running PHP v5.4.12, MySQL v5.0.10 and Apache v2.4.4.
By the way, I am also running bbpm plugin for private messaging, which has altered bbpress database quite a bit.
Sorry for doublepost, mobile opera does not show edit link.
Correct me if I’m wrong: after upgrade to v1.2, I logged in to admin panel and got a notice about database upgrade. It proceeded, however spit some errors that it could not drop primary index keys and create new ones. Other tasks went fine. When I visited admin panel po the second time, I did not get any notice and everything is still working fine. I did all recounts and they completed successfully. All forums seem intact and operational on v1.2.
But will not convert to v2.5.2…
Hi.
I am still running bbPress v1.0.3. I have not upgraded it since due to complexity and lack of time. I am now all full at it.
I am running a copy of my site locally (on WAMP2) due to obvious reasons.
I have tried as per <fontadoni> instructions to update to v1.2, which was successful. Now I am trying to import everything to newest bbPress plugin (v2.5.2) via included import tool. What I get is:
Calculating forum hierarchy (0 - 99)
Converting forums (0 - 99)
Starting Conversion
And it hangs there (on hierarchy calculation). When I check the forums, I can see that forum categories are there, but no subforums, no topics and no users present.
I do reset and recalculate everything before importing. I have tried various checkbox combinations …
I was running bbPress integration btw (common users between wp and bbPress v1.2).
help…
The theme, basically, is default “Kakumei” with altered header and footer.
It looks like I am missing something – when I changed post count on original thread from 81 to 80, all post numbers shifted and #24 is no longer missing. But anyway, I am OK with missing numbers, at least it lets people know where their posts are.
How can I check why my bbpress does not recount posts? Where is that function? I was messing around with some PHP and template codes (to ‘join’ forum to the page) so maybe I have done something…
So here it is:
http://e-motion.lt/bbpress/topic/31?replies=20#post-317
I have deleted post #3 from database. Same problem:
#3 is missing and it shows post count of 21.
After running your query post count is now correct (20), but #3 is still being skipped.
Yes, sorry, I saw your post when it was too late.
I will try to recreate this situation on new topic.
OK, so I was going thru the database and saw that bbpress holds post count in it. I just changed that to correct value and it seems like everything is good now. And post #24 is no longer missing, posts have shifted per one place.
Thank you for your help. 
Anyway now we have discovered one more bug to fix.
Query returns 80 posts. Definitely something is very wrong…
https://i.imgur.com/jslzY.png
So there are total of 80 posts in this topic with no ‘deleted’ posts. And that means I actually have removed post #24 physically from database.
Maybe I should just create a dummy post on database and problem would solve itself?
This query gave me an error:
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
So I just did this:
SELECT * FROMbb_postsWHERE topic_id=12
And the result is:
Showing rows 0 – 29 (80 total, Query took 0.0020 sec)
So now I’m wondering where is bbpress taking post count numbers from?
I do know how to use it. I just can’t recall if I messed with it relating bbpress before this happened.
Yes, I did. I have recounted everything again, just to be sure.
https://i.imgur.com/lc1Qv.png
I am now trying to recreate the problem. I was unable to do so on new topic and can’t remember exactly what I did last time. It just recounts all post numbers and everything works fine. It is stupid of me, but somehow I think that I may have tampered with the post physically – on phpMyAdmin. I am not sure about this, I do lots of stupid things.
I have now temporarily closed this topic (it is most active one in my whole forum) and added some posts to replicate the problem:
http://e-motion.lt/bbpress/topic/12?replies=80&message=closed
Forum says there are 81 posts and 5 pages. On page #2 post #24 is missing.
Page #5 is “empty”. If I unlock the topic, reply form is on page #5 and not #4, where the last post is.
Sorry, I am not so good with CMS-related stuff.. I do know some PHP and MySQL, but some basic help may be needed.
P.S. Very nice to hear you also have an e-bike! I have been riding this one for a while: http://www.youtube.com/watch?v=fXsE5NNfC7w
And hopefully will ride a DIY electric scooter in couple of weeks.
No, I do not. I have following plugins:
Akismet
Allow Images
Avatar Upload
BBcode Buttons Toolbar
BBcode Lite
bbPM
BBVideo
Bozo Users
Hello Louie
Human Test for bbPress
Instant Password
Skip Akismet
SourceCode Highlighter
_ck_,
Yes, I’ve tried to do a recount, but it had no effect on this issue.
For this example, unfortunately, the thread in given link is an active discussion and the problem vanished when one reply was written. It will reappear when someone writes a reply last on that page. I wonder how it will be with two deleted posts, not one…
I am having this problem too. You can check it at:
http://e-motion.lt/bbpress/topic/12/page/3
Go to page 4. The thread has one post deleted – #24.
I am using bbPress 1.0.2.
