Forums

Join
bbPress Support Forums › Installation › bbPress 0.9.0.1 released
12

Info

bbPress 0.9.0.1 released

    • Posted 3 years ago #

    I need to find a way to fix the errors, not so minor, getting data base errors for posts.

    bbPress database error: [Unknown column 'post_id' in 'where clause']
    SELECT * FROM wp_posts WHERE post_id = 0

    • Posted 3 years ago #

    Looks like you got the $bb_table_prefix wrong when you installed, it should have been different to the wordpress prefix.

    Change $bb_table_prefix from "wp_" to "bb_" in bb-config.php then rename you bbPress tables thusly:

    wp_forums -> bb_forums
wp_tagged -> bb_tagged
wp_tags -> bb_tags
wp_topicmeta -> bb_topicmeta
wp_topics -> bb_topics

    .
    Do not rename wp_posts, wp_users or wp_usermeta!

    This will still leave you without a bb_posts table. So if you have a way to browse your database (e.g. phpMyAdmin) then go into the bb_topicmeta table and look for the row with a meta_key of bb_db_version. Change the meta_value of that row from 1234 to 1233. Login to your bbPress (hopefully it works) then go to the admin section. You will be asked to upgrade, do so and check the log. You should see a log entry where your bb_posts table is created.

    That should do it.

    • Posted 3 years ago #

    Posts work now.

    No longer have the admin option, I went to
    /forums/bb-admin/
    clicked upgrade, posts in forum now work
    I no longer have admin privileges
    Listed as member
    Thanks, getting closer.
    So when integrating with wordpress we use bb, not wp.

    I also lost admin priv. in wordpress
    I get: You do not have sufficient permissions to access this page. Doesn't even give me choice to log in. I had no problem logging in as admin either place before changing the tables, etc

    I did use the wordpress secret key phrase.

    Used 0.9.0.1 downloaded fresh copy yesterday

    • Posted 3 years ago #

    Working now. As this was a new data base with no content yet, I dropped the database, made a new one, installed wordpress, then bbpress. All seems to be working correctly. I must have put wp_ in step 1 the first time instead of leaving it at bb_. No problems with logging in like I had when I tried the upgrade. Thanks.

  5. You must log in to post.

12