Skip to:
Content
Pages
Categories
Search
Top
Bottom

Problems using same tables for wordpress and bbpress


  • darkling235
    Member

    @darkling235

    I’m trying to use the same database and tables for wordpress and bbpress but they don’t merge painlessly.

    I set the table prefix in bbpress’s config to wp_ and set the database to be the same as wordpress’s. I also set the wp_prefix in bbpress’s config.

    Then I tried to start bbpress but it threw a bunch of exceptions and now it will not save new posts. Can anyone help me?

    I enclose it’s exceptions

    Now we’re going to create the database tables and fill them with some default data.

    bbPress database error: [Incorrect table definition; there can be only one auto column and it must be defined as a key]
    ALTER TABLE wp_posts ADD COLUMN post_id bigint(20) NOT NULL auto_increment

    bbPress database error: [Key column 'post_id' doesn't exist in table]
    ALTER TABLE wp_posts ADD PRIMARY KEY (post_id)

    bbPress database error: [The used table type doesn't support FULLTEXT indexes]
    ALTER TABLE wp_posts ADD FULLTEXT KEY post_text (post_text)

    1. Created table wp_forums
    2. Created table wp_topics
    3. Created table wp_topicmeta
    4. Created table wp_tags
    5. Created table wp_tagged
    6. Changed default value of wp_posts.post_status from publish to 0
    7. Added column wp_posts.post_id
    8. Added column wp_posts.forum_id
    9. Added column wp_posts.topic_id
    10. Added column wp_posts.poster_id
    11. Added column wp_posts.post_text
    12. Added column wp_posts.post_time
    13. Added column wp_posts.poster_ip
    14. Added index wp_posts FULLTEXT KEY post_text (post_text)
    15. Added index wp_users UNIQUE KEY user_login (user_login)

    bbPress database error: [Field 'post_content' doesn't have a default value]
    INSERT INTO wp_posts (forum_id, topic_id, poster_id, post_text, post_time, poster_ip, post_status, post_position) VALUES ('1', '1', '1', '

    First Post! w00t.
    ','2008-02-22 15:10:39', '127.0.0.1', '0', 1)

    bbPress database error: [Unknown column 'post_id' in 'field list']
    SELECT post_id, poster_id FROM wp_posts WHERE topic_id = 1 AND post_status = 0 ORDER BY post_time

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

    Finished!

Viewing 2 replies - 1 through 2 (of 2 total)

  • chrishajer
    Participant

    @chrishajer

    DON’T do that!

    You want bbPress and WordPress to have different table prefixes in their respective config. bb_ and wp_ , the defaults, are fine. If you try to use the same table prefix, some of the WordPress tables get destroyed due to a collision between table names because both software packages now use the same table prefix (posts , usermeta and users tables, I believe.)

    What are you trying to accomplish that requires you to use the same tables for WordPress and bbPress? If you are looking for integration, this is not how you do it. With an integrated install, you still use a different table prefix for bbPress but you insert your WordPress table prefix in the bbPress config.php a little further down in the file. Then, bbPress modifies the existing wp_users and possibly wp_usermeta table.


    darkling235
    Member

    @darkling235

    Ok I get it now thanks

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.