I have had wordpress 2.2.1 up and running for a while. I just tried to install bbpress, using the table prefixes ‘wp_’, since I think that is necessary to have any authors registered on my wp site to be able to get on to bbpress, and vice versa. My bb’s config.php has the same database info as my wp’s config.

When I ran the install.php file for bb, I recieved some errors:

Second Step

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: [Multiple primary key defined]

ALTER TABLE wp_tags ADD PRIMARY KEY (tag_id)

1. Created table wp_forums

2. Created table wp_topics

3. Created table wp_topicmeta

4. Created table wp_tagged

5. Changed default value of wp_posts.post_status from publish to 0

6. Added column wp_posts.post_id

7. Added column wp_posts.forum_id

8. Added column wp_posts.topic_id

9. Added column wp_posts.poster_id

10. Added column wp_posts.post_text

11. Added column wp_posts.post_time

12. Added column wp_posts.poster_ip

13. Added index wp_posts FULLTEXT KEY post_text (post_text)

14. Changed type of wp_tags.tag_ID from int(11) to bigint(20) unsigned

15. Changed type of wp_tags.tag from varchar(255) to varchar(200)

16. Added column wp_tags.raw_tag

17. Added index wp_tags KEY name (tag)

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 = 114

Finished!

---

Now you can log in with the username “admin” and password “*Your WordPress password*”.

However, when I try to log in to my wordpress admin area as the ‘admin’ now, I receive the error:

“You do not have sufficient permissions to access this page.”

I am able to log into bb, but there are multiple errors on each page; this is repeated many times on the page:

“bbPress database error: [Unknown column ‘post_id’ in ‘where clause’]

SELECT * FROM wp_posts WHERE post_id = 0

Anonymous.”

I would just remove the bbpress completely, just to get wordpress login working again, but bb seems to have altered my wp user data?

thanks

[@trent Member 17 years, 5 months ago]

Did you get this working? If you have access to your database through myphpAdmin or something like that, we can make sure that your admin user has the correct privelages pretty easy by looking at wp_users and then browsing to the admin user. The install of bbPress should not have changed the admin capabilities of your WP admin backend access because it would have added a completely seperate ‘role’ entry to wp_usermeta and not touched the wp_user table at all.

Trent

[@suff Member 17 years, 4 months ago]

I have the same problem…

[@suff Member 17 years, 4 months ago]

Well…I’ve resolved my (and maybe also your) problem… the problem was that I’ve used the same db prefix for both bbpress and wordpress… I feel like an idiot I just didn’t read the instructions too carefuly

[@tlmchris Member 17 years ago]

I also failed to read the instructions carefully… how did you resolve the problem?

[@chrishajer Participant 17 years ago]

If you overwrote the wp_ tables with the bbPress installation script, I think the best (only?) solution is to restore your WP database from a backup, then install bbPress with a proper table prefix, like bb_.

Maybe the installation script should check for someone setting the table prefix in bbPress to wp_ and question it or warn that bad things can happen. Or possibly it could check for the existence of those wp_ tables already, and warn that they’re going to be modified or overwritten?