bbPress

Simple, Fast, Elegant

bbPress support forums » Installation

bbPress 0.9.0.1 released

(34 posts)
  • Started 4 months ago by sambauers
  • Latest reply from txmom
  • This topic is not a support question
1 2

  1. txmom
    Member

    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 4 months ago #

  2. sambauers
    Key Master

    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 4 months ago #

  3. txmom
    Member

    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 4 months ago #

  4. txmom
    Member

    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.

    Posted 4 months ago #

RSS feed for this topic

1 2

Reply

You must log in to post.

Code is Poetry.