Support Forum

What do these tables do?

KV kvr28
kvr28
Member
Member since Mar 2014
804 posts
Apr 9, 2014 · 12:21 pm · Edited

_sfbuddies

_sfpmmessages

_sfpmrecipients

_sfpmthreads

I noticed when looking at my database how many tables were left behind by other plugins, buddypress,bbpress, mingle and woocommerce left a ton, so I ran the springclean plugin to delete unused tables and these 4 popped up on the list of unused tables, so I deleted them, as soon as I did I started getting database errors on the forum. God bless wp-engine and their staging server. So I recopied my live site to my staging site and ran again without deleting those tables and had no issues, just curious what they do

3 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Apr 9, 2014 · 12:32 pm

All four are the component tables of the Simple:Press Private Messaging plugin.

For easy reference note that ALL Simple:Press tables begin with the prefix ‘sf’.

KV kvr28
kvr28
Member
Member since Mar 2014
804 posts
Apr 9, 2014 · 1:04 pm

Thanks Yellow, any idea why they would show up as not being used? I know personally I have been pretty active with the private messaging system since we switched to simple press :(

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Apr 9, 2014 · 2:53 pm

Actually no idea. And it is odd that the list did not include the sfadversaries table which is the most likely to be empty.

But I am unfamiliar with this ‘spring clean’ pkugin – what it does and how it works. Clearly got this one wrong however.