Forums

Join
bbPress Support Forums › Installation › delete tables start over

Info

Tags

delete tables start over

    • Posted 3 years ago #

    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

    • Posted 3 years 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.

    • Posted 3 years 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

    • Posted 3 years ago #

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

    • Posted 3 years ago #

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

    • Posted 3 years ago #

    Thank you chrishajer,

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

  7. You must log in to post.