Support Forum
Support Forum
Offline
I made a post this morning in another thread that my site has about 3300 users but forums are showing 2800 users. What happened to the remianing 500.
I was wondering what happened to the other 500 and in that wonderment I clicked on 'Reset Author Cache' button, hoping that it would do some magic.
And it did. It removed all the user accounts (from the forum only not wp) except the 699 that were present before installing simple press.
The 27 people who registered at site after installing forums and had made posts are now being shows as Guests and they are not appearing in the Guest list in admin backend either.
sfmembers table is showing only 699 records now
What went wrong and how to correct it?
Simple Press is a great software working at Homeopathy Forums
Offline
reset author cache?? do you mean 'Reset the Auths Cache' on the toolbox housekeeping form? auths as in authorizations... that simply clears out the auths column of the sfmembers table... its a cache of user permissions on your forum... if you clear it, when the user visits the forum, it will have to rebuild the auths cache for that user...
it does not delete any users...
there is no guest list either... guests are not shown as members of any usergroup... you could though move users into that usergroup to give them the same permissions as guests...
Visit Cruise Talk Central and Mr Papa's World
Offline
Yups that is what I did. Feel like hitting myself. 
Simple Press is a great software working at Homeopathy Forums
Offline
I'll restore those tables from the few hour old backup that I have.
Simple Press is a great software working at Homeopathy Forums
Offline
did what? hitting that button wont delete any users... so you have me a bit confused... it will just slow down your users ever so slightly only the next time they visit...
its just a cache... no real effect...
Visit Cruise Talk Central and Mr Papa's World
Offline
I pressed the 'Reset the Auths Cache' on the toolbox housekeeping form.
Before that forum stats were showing 2800 users.
After that forum stats show 699 users. These 699 users registered before installing simple press. Rest of the accounts seem to have disappeared.
They are not there in sfmembers table and they do not show in any uerr group (guest, member, moderator, admin) in forum admin backend.
The 27 new members who were active at the forums and registered after installing sf, have their user status marked as 'Guest' in their posts. But their account is not visible n the admin backend in any user group or member list.
Simple Press is a great software working at Homeopathy Forums
Offline
I would suggest something else has occurred... the button runs this single query:
spdb_query('UPDATE '.SFMEMBERS." SET auths=''".$where);
$where will be empty string here... so just clears the column...
could you perhaps try going to phpmyadmin and repairing your db? perhaps something corrupted?
Visit Cruise Talk Central and Mr Papa's World
Offline
I did that (repairing db) before posting here. No effect. Am having the tables restored for now.
Also it is only the forums that were affected and the rest of the site has no issues with members etc.
Simple Press is a great software working at Homeopathy Forums
Offline
well, if you can easily restore, it would be nice for you to try that again... I just tried it on 5 sites with no issues...
is this standard mysql db?
Visit Cruise Talk Central and Mr Papa's World
Offline
Alright I'll do that once the tables are restored.
Even I am bewildered with what happened. never expected that. And didn't do anything else with the site to put blame on it.
Yes standard mysql db. wordpress multisite with buddypress. No membership plugins installed.
Simple Press is a great software working at Homeopathy Forums
All RSS1 Guest(s)