Skip to:
Content
Pages
Categories
Search
Top
Bottom

delete tables start over

  • 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

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

  • chrishajer
    Participant

    @chrishajer

    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.

    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

    @chrishajer

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

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

    Thank you chrishajer,

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

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

You must be logged in to reply to this topic.