• I made a big boo-boo. In trying to manually install bbPress (my server wouldn’t let it write to the config file), I accidentally set the database prefix to the same prefix as my WordPress installation thinking for some stupid reason that it was for the user integration. Idiot! So now my blog (https://ipfcubed.com– but I’ve made it so nobody can publicly access it as I don’t want people to see it in such a mess) has made all drafts and scheduled posts (and even non-approved contributor’s posts) all published. posts table is really messed up– and by the looks of the bbPress log, it could be that several tables are messed up. I need help badly! Will please someone advise me on what to do? I’m at a complete loss. I’ve no idea what to do. I’ve looked at the database tables and tried fixing some of them, but it’s not working. I thought it could be because it changed the ipf3_posts index as well as set every stinking post’s status to “0” instead of “published” or “draft” or whatever, but I don’t know how to change that back. Please help ASAP! I need to get the site up and running again for the readers! The bbPress installation log is below along with its errors:

    THE LOG (errors below it):

    Referrer is OK, beginning installation…
    >>> Setting up custom user table constants
    
    Step 1 - Creating database tables
    >>> Modifying database: jordan_wp (localhost)
    >>>>>> Table: ipf3_forums
    >>>>>>>>> Creating table
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_meta
    >>>>>>>>> Creating table
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_posts
    >>>>>>>>> Adding column: post_id
    >>>>>>>>>>>> SQL ERROR! See the error log for more detail
    >>>>>>>>> Adding column: forum_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: topic_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: poster_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: post_text
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: post_time
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: poster_ip
    >>>>>>>>>>>> Done
    >>>>>>>>> Setting default on column: post_status
    >>>>>>>>>>>> Done
    >>>>>>>>> Changing column: post_status
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: post_position
    >>>>>>>>>>>> Done
    >>>>>>>>> Dropping index: PRIMARY
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding index: PRIMARY
    >>>>>>>>>>>> SQL ERROR! See the error log for more detail
    >>>>>>>>> Adding index: topic_time
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding index: poster_time
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding index: post_time
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding index: post_text
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_terms
    >>>>>>>>> Changing column: term_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Changing column: name
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_term_relationships
    >>>>>>>>> Changing column: object_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Changing column: term_taxonomy_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Adding column: user_id
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_term_taxonomy
    >>>>>>>>> Changing column: term_taxonomy_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Changing column: term_id
    >>>>>>>>>>>> Done
    >>>>>>>>> Changing column: parent
    >>>>>>>>>>>> Done
    >>>>>> Table: ipf3_topics
    >>>>>>>>> Creating table
    >>>>>>>>>>>> Done
    
    Step 2 - WordPress integration (optional)
    >>> WordPress address (URL): https://ipfcubed.com/
    >>> Blog address (URL): https://ipfcubed.com/
    >>> WordPress cookie keys set.
    >>> WordPress "auth" cookie salt set from input.
    >>> WordPress "logged in" cookie salt set from input.
    >>> Fetching missing WordPress cookie salts.
    >>>>>> WordPress "secure auth" cookie salt not set.
    >>> User database table prefix: ipf3_
    
    Step 3 - Site settings
    >>> Site name: IPF3 Forum
    >>> Site address (URL): https://forum.ipfcubed.com/
    >>> From email address: [email protected]
    >>> Key master role assigned to existing user
    >>>>>> Username: admin
    >>>>>> Email address: [email protected]
    >>>>>> Password: Your existing password
    >>> Description: Just another bbPress community
    >>> Forum name: The General of Electric
    >>>>>> Topic: Your first topic
    >>>>>>>>> Post: First Post!  w00t.
    >>> Key master email sent
    
    There were some errors encountered during installation!

    THE ERRORS:

    SQL ERROR!
    >>> Database: jordan_wp (localhost)
    >>>>>> ALTER TABLE <code>ipf3_posts</code> ADD COLUMN <code>post_id</code> 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: jordan_wp (localhost)
    >>>>>> ALTER TABLE <code>ipf3_posts</code> ADD PRIMARY KEY (<code>post_id</code>);
    >>>>>> Key column 'post_id' doesn't exist in table
Viewing 2 replies - 1 through 2 (of 2 total)
  • do you have a database back up for blog? if not, ask your host. most usually back up at least weekly
    simply drop all the tables in the database and import the back up

    Thread Starter weildish

    (@weildish)

    I haven’t been able to get PHPMyAdmin to work because my server runs an older version of PHP or else I would have backed up. I’ve emailed my system administrator to see if he can’t help, so I hope he has a backup. Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Accidentally Gave bbPress the Same Prefix as WordPress Installation’ is closed to new replies.