what tables do I need to delete to start a fresh install. I have these errors:

These are the errors I got when trying to integrate the two:

SQL ERROR!

>>> Database: username (localhost)

>>>>>> ALTER TABLE wp_posts ADD COLUMN post_id bigint(20) NOT NULL auto_increment;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: database (localhost)

>>>>>> ALTER TABLE wp_posts ADD PRIMARY KEY (post_id);

>>>>>> Key column ‘post_id’ doesn’t exist in table

and the nonce key is missing in bbconfig

[@chrishajer Participant 15 years, 11 months ago]

It looks like you used wp_ (instead of bb_) as your table prefix, and WordPress was already installed, which means bbPress tried to install into the WordPress tables?

By default, WordPress uses these tables (in 2.7):

wp_comments

wp_links

wp_options

wp_postmeta

wp_posts

wp_terms

wp_term_relationships

wp_term_taxonomy

wp_usermeta

wp_users

And bbPress uses these in the alpha version:

bb_forums

bb_meta

bb_posts

bb_terms

bb_term_relationships

bb_term_taxonomy

bb_topics

bb_usermeta

bb_users

bbPress 0.9.0.* versions used different tables:

bb_forums

bb_posts

bb_tagged

bb_tags

bb_topicmeta

bb_topics

bb_usermeta

bb_users

And when you integrate, bbPress uses the wp_users and wp_usermeta tables instead of its own bb_users and bb_usermeta.

[@famous Member 15 years, 11 months ago]

what can I do? I tried integrating bbpress with buddypress/wordpress and was unsuccessful. I don’t want to damage my database. What can I do to get it working? Best solution??? Thanks

[@chrishajer Participant 15 years, 11 months ago]

Do you have a backup of the database before trying integration? Did you indeed use wp_ for the bbPress table prefix?

[@famous Member 15 years, 11 months ago]

yes, I used wp instead of bb. And my backup would be too old by now.

[@famous Member 15 years, 11 months ago]

Thank you chrishajer,

For showing me which tables are involved, it helped me make a decision…