Self-inflicted BP Tables Madness
-
Hello!
I am having an issue with BP, that I caused myself. I intentionally deactivated, then deleted, BP (on a 5 day old site) thinking that I wasn’t going to use it. Then I ran ‘WP Optimize’ which removed all the unused tables from the plugins I had installed, and removed unused transients, etc… This is what caused the problem.
Some time later, I went to re-install BP – which succeeds with no issues. Here’s where the issues crop up… Next, I went to create a new Group on the BP front-end, and it reports an error:
There was an error saving group details. Please try again.
Enabling WP debug mode in “wp-config.php” reports this:
WordPress database error: [Table 'wordpress.wp_bp_groups' doesn't exist] SELECT id FROM wp_bp_groups WHERE slug = 'create' WordPress database error: [Table 'wordpress.wp_bp_activity' doesn't exist] SELECT id, user_id, date_recorded FROM wp_bp_activity WHERE component = 'members' AND type = 'last_activity' AND user_id IN (1) LIMIT 1 WordPress database error: [Table 'wordpress.wp_bp_activity' doesn't exist] SELECT id, user_id, date_recorded FROM wp_bp_activity WHERE component = 'members' AND type = 'last_activity' AND user_id IN (1) LIMIT 1 WordPress database error: [Table 'wordpress.wp_bp_activity' doesn't exist] SHOW FULL COLUMNS FROM <code>wp_bp_activity</code> WordPress database error: [Table 'wordpress.wp_bp_notifications' doesn't exist] SELECT * FROM wp_bp_notifications n WHERE user_id IN (1) AND component_name IN ('friends','messages','activity','groups','blogs') AND is_new = 1 WordPress database error: [Table 'wordpress.wp_bp_messages_recipients' doesn't exist] SELECT SUM(unread_count) FROM wp_bp_messages_recipients WHERE user_id = 1 AND is_deleted = 0 AND sender_only = 0 WordPress database error: [Table 'wordpress.wp_bp_friends' doesn't exist] SELECT id FROM wp_bp_friends WHERE (initiator_user_id = 1 OR friend_user_id = 1) ORDER BY date_created DESC WordPress database error: [Table 'wordpress.wp_bp_groups_members' doesn't exist] SELECT COUNT(DISTINCT m.group_id) FROM wp_bp_groups_members m, wp_bp_groups g WHERE m.group_id = g.id AND m.is_confirmed = 0 AND m.inviter_id != 0 AND m.invite_sent = 1 AND m.user_id = 1 WordPress database error: [Table 'wordpress.wp_bp_messages_notices' doesn't exist] SELECT id FROM wp_bp_messages_notices WHERE is_active = 1
I have been trying to find a solution for this online, for the last 4+ hours… and I have gotten nowhere… So, I am humbly asking for help here, on how to recreate these tables – WITHOUT DELETING AND RECREATING MY ENTIRE SITE. I have nearly 100 hours into this site so far, and I am NOT starting over. Starting over is NOT an option, so please save everyone’s time and skip suggesting this.
I have reviewed all of these links, and followed all of their respective directions, when applicable:
https://buddypress.org/support/topic/reinstall-should-i-delete-old-tables-from-db/
and, many many many many more links, that I am not going to go back and try to find…Any help with this would be great – I’d really like to use BP again… I have seen a number of other people online with this issue, so I know I am not the only one. There has to be some elegant solution to re-create the required SQL tables for the plugin, right?
I have tried running this, after I reinstalled BP the 4th time (with my TDL inserted, ofc):
https://xxxxxx.com/wp-content/plugins/buddypress/bp-core/bp-core-update.php?f=bp_update_to_2_7_4
But, it didn’t seem to do anything…Ubuntu 16.04.1
Apache 2.4.18
PHP 7.0.13
WP 4.7.2
BP 2.7.4
no other BP extension/plugins have been installed since the 1st time removing BPI am more than happy to provide any requested log files!
Thank you a TON in advance!! I look forward to getting this working again.
- You must be logged in to reply to this topic.