Problem using same tables for wordpress and bbpress
-
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.