Skip to:
Content
Pages
Categories
Search
Top
Bottom

repair buddypress database


  • andricor
    Participant

    @andricor

    Hi there!
    I noticed that after the latest update of buddypress, I could not create groups anymore.
    After investigating a bit, I realized that my user didn’t have ALTER permissions on the database and some database tables were altered in the latest release including the groups table.
    The situation now is that I have the latest version of buddypress but I’m not able to align the tables to what they should be now.
    This is how the table looks now:

    mysql> desc wp_23bp_groups;
    +————–+————–+——+—–+———+—————-+
    | Field | Type | Null | Key | Default | Extra |
    +————–+————–+——+—–+———+—————-+
    | id | bigint(20) | NO | PRI | NULL | auto_increment |
    | creator_id | bigint(20) | NO | MUL | NULL | |
    | name | varchar(100) | NO | | NULL | |
    | slug | varchar(200) | NO | | NULL | |
    | description | longtext | NO | | NULL | |
    | status | varchar(10) | NO | MUL | public | |
    | enable_forum | tinyint(1) | NO | | 1 | |
    | date_created | datetime | NO | | NULL | |
    +————–+————–+——+—–+———+—————-+
    8 rows in set (0.00 sec)

    mysql>

    but there should be a “parent_id” column there and that’s the reason I cannot create groups.

    Is there a way that I can repair the database? I tried to remove and reinstall the plugin but it didn’t help.

    Thanks a lot!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.