Support Forum
Support Forum
Offline
Just curious about something here... I was doing some routine db maintenance and noticed a new table titled "sftempmembers" at the top of the list (in PHP MyAdmin).
The table has no prefix like all my other SimplePress tables do (e.g.; wp_1_sfgroups, wp_1_sfposts, etc.).
I don't recall seeing this table before, and don't believe I made any updates recently so I'm not sure exactly how or when the table was created. I did implement a hack or two recently that Steve provided for better user & SF member account management upon blog deletion, but wasn't aware of any new tables being created.
The table currently holds only four records, three of which are forum moderators, and another previous moderator.
The fact that it's missing it's prefix is my only concern—well, that and the notice above it's structure—otherwise I may have never noticed it. Remember, we run a multisite network, so I wonder if a prefix should have been applied.
What is this table? Should I leave it alone?
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
its a temp table that we create during the processing of membership actions (ie usergroup members)... its cleaned up after it done... so wondering if your mysql user does not have permission to delete these tables or perhaps at some point it had an error and died before it was removed...
you can safely remove it if you are not doing any of the those multiselect actions in the admin...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
...wondering if your mysql user does not have permission to delete these tables or perhaps at some point it had an error and died before it was removed...
Likely the latter. I actually removed one of the members listed in that table from our Moderators group yesterday. Shortly thereafter we did have a presumably unrelated issue and had to restart MySQL. Perhaps the cleanup just didn't occur because of that.
you can safely remove it...
Thanks!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
All RSS1 Guest(s)