Deleted and entries remain in database.

This plugins leaves a whole lot of capabilities in the database, aside from anything else.

Run this code once (say, in your functions.php file) to get rid of them.

add_action( 'admin_init', 'clean_unwanted_caps' );
function clean_unwanted_caps(){
    $delete_caps = array(
		'delete_others_tribe_events',
		'delete_others_tribe_organizers',
		'delete_others_tribe_venues',
		'delete_private_tribe_events',
		'delete_private_tribe_organizers',
		'delete_private_tribe_venues',
		'delete_published_tribe_events',
		'delete_published_tribe_organizers',
		'delete_published_tribe_venues',
		'delete_tribe_events',
		'delete_tribe_organizers',
		'delete_tribe_venues',
		'edit_private_tribe_events',
		'edit_private_tribe_organizers',
		'edit_private_tribe_venues',
		'edit_published_tribe_events',
		'edit_published_tribe_organizers',
		'edit_published_tribe_venues'
	);
    global $wp_roles;
    foreach ($delete_caps as $cap) {
        foreach (array_keys($wp_roles->roles) as $role) {
            $wp_roles->remove_cap($role, $cap);
        }
    }
}

Thanks for posting that blogologist. That used to be our recommended code. However, there is an even easier method now. Install the Plugin Events Rocket and use its events cleanup features to remove absolutely everything from the DB. You can of course uninstall that plugin once you are done.

I hope that helps Ron. Cheers!

– Brook

Brook, thanks for the tip. I ran the Rocket and then searched for “tribe” in wp_options, wp-sitemeta, and wp-usermeta. Shouldn’t all “tribe” entries be wiped?

… that should have read:

“Brook, thanks for the tip. I ran the Rocket and then searched for “tribe” and found them still in wp_options, wp_sitemeta, and wp_usermeta. Shouldn’t all “tribe” entries be wiped?”

Hi ronr1999,

I’m afraid we aren’t able to provide any assistance with Event Rocket, but if you contact the developer he can probably shed some light on this.

Best,
Leah

Seriously! I posted specifically regarding your Events Calendar plugin. I don’t want assistance with Event Rocket – I want to know how to remove your leftovers in our database!

Your title is Modern Tribe Support Rep. After removing your plugin, I search for the term “tribe” in our database and find lots of leftover entries. I’m disappointed…!

Hey ronr1999. Thanks for the follow-up here; Leah brought your reply to my attention, and as the head of support at Modern Tribe, I naturally wanted to reach out here to apologize for your poor experience so far. It’s clear to me that we failed at being clear in our communications here.

At the moment, there is no “official” method for removing plugin leftovers from the database. It does make total sense that this is something a user would want – if you’ve moved onto another plugin, there’s no reason for TEC to leave data on your site. Leah pointed you to Event Rocket, which is a nice third-party solution that could help accomplish your goals, in light of an official solution. But the fact that we failed to properly set your expectations here – and to be clear that Event Rocket is really the only means for accomplishing what you’re requesting, at least insofar as support we can provide at www.remarpro.com – was a total failure on our end, and I apologize for that.

You should know that we are working on a solution for this very problem right now, as part of our 3.8 release. (Whether it ships in 3.8 or in a subsequent release has yet to be seen, but work is currently underway). For some context: we’ve been exploring the idea of removing all plugin configurations on removal for a while but haven’t acted on it until now. What first started off as an idea to automatically remove all plugin data from the DB evolved into doing it as a setting. Our rationale here was that people might not want all plugin data removed if they simply delete the plugin…letting them have a button to click so they know what they’re getting into is a nice safeguard against accidental embarrassment.

That feature got put on hold due to lack of interest from the community but has recently been picked up again; we’re now realistically planning on building this out as a free light add-on you can install and activate to remove all remnants of TEC. And as I mentioned, work on that started this month.

While it may not be of particular value to you, as I see you’ve already spent a lot of time on this, know that it will hopefully save others from your same level of disappointment down the road. We really appreciate your honest feedback here. If you have other thoughts or if there’s anything else we can do to make things right, please let me know.

Thank you for the thorough explanation and look forward to your latest releases.

To give you an update on what I’ve done: I’ve used Event Rocket and tried their tribe removal. It did not remove all of the tribe entries.

My question to you: Is there any problem simply going to the database and manually removing the remaining tribe entries?

Thanks again for your help, it’s much appreciated!

Hello again ronr1999,

I am sorry to hear that the Events Rocket did not remove all of the entries. A while back I wrote this snippet to cleanup some leftovers that were being left behind by event rocket, it is an improved version of what blogologist posted. When the developer of Event Rocket saw my code he modified it and included it in an updated version of Event Rocket. That is the reason why I recommended it to you, installing the plugin seemed easier than copy/pasting a snippet, then deleting it after it had run. My code was not meant to be a comprehensive removal, it was just filling in one of the gaps I saw in Event Rocket. There might be more gaps, I really would not know.

If you have found some things that Event Rocket has not deleted you might post in the Event Rocket forums and let the dev know. I am sure he would be interested to learn what they are. If you can post a copy of the entire DB rows that have straggled behind that would no doubt be helpful to him.

In response to whether you can safely delete those rows or not, I can not say for sure. Odds are yes you can. But, for all I know another plugin has created some rows with the word tribe in them for whatever reason. While you should be able to safely delete any rows from TEC, if you are no longer using it, it might be unsafe to delete other plugins rows that have a similar naming scheme.

I hope that makes sense. Unless there are thousands of entries left in the DB, generally there is no perceptible impact on performance.

You are welcome for the help, we are happy to provide it. I also apologize for the confusion earlier, I should have been more explicit. Cheers!

– Brook