• 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!

The topic ‘Problem using same tables for wordpress and bbpress’ is closed to new replies.