repair buddypress database
-
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!
- You must be logged in to reply to this topic.