Support Forum

Lost All users after reset auth cache

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 1, 2012 · 11:53 pm · Edited

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?

17 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 1, 2012 · 11:59 pm

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…

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 12:01 am

Yups that is what I did. Feel like hitting myself. embarassedyellcryeekconfusedfrown

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 12:06 am

I’ll restore those tables from the few hour old backup that I have.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 2, 2012 · 12:07 am

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…

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 12:11 am

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.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 2, 2012 · 12:20 am

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?

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 12:26 am

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.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 2, 2012 · 12:35 am

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?

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 12:39 am

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.

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 1:18 am

Just seem to be having a bad day.

 

Now all the forum links are again redirecting to website homepage. Old problem, keeps cropping up now and then, usually gets fixed if I re-save the forum permalinks in wp integration option. 

 

I am already balled…otherwise I would be pulling my hairs in despair! 🙂

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jan 2, 2012 · 4:32 am

Are you saying that something on your site changes the forum permalink? Or trashes it?

DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 4:33 am

The error logs show these errors since morning. Do they make any sense

 

Date Type Description
January 2, 2012

6:55 am

 database file: /problem-with-post-edit-buttonome/betahpat/public_html/wp-content/plugins/simple-press/sp-api/sp-api-class-user.php

line: 108

function: spdb_table

error: Table ‘betahpat_wp.SFUSERS’ doesn’t exist

SELECT * FROM SFUSERS WHERE ID=1618
January 2, 2012

6:55 am

 php file: /simple-press/sp-api/sp-api-class-user.php

line: 108

function: __construct

Notice | Use of undefined constant SFUSERS – assumed ‘SFUSERS’
January 2, 2012

6:55 am

 php file: /simple-press/sp-startup/sp-load-core.php

line: 151

function: include_once

Notice | Use of undefined constant SPTEMPLATES – assumed ‘SPTEMPLATES’
January 2, 2012

6:55 am

 php file: /simple-press/sp-api/sp-api-plugins.php

line: 41

function: sp_get_active_and_valid_plugins

Notice | Use of undefined constant SFPLUGINDIR – assumed ‘SFPLUGINDIR’
January 2, 2012

6:55 am

 php file: /simple-press/sp-api/sp-api-plugins.php

line: 41

function: sp_get_active_and_valid_plugins

Notice | Use of undefined constant SFPLUGINDIR – assumed ‘SFPLUGINDIR’
January 2, 2012

6:55 am

 php file: /simple-press/sp-api/sp-api-plugins.php

line: 41

function: sp_get_active_and_valid_plugins

Notice | Use of undefined constant SFPLUGINDIR – assumed ‘SFPLUGINDIR’
January 2, 2012

6:55 am

 php file: /simple-press/sp-api/sp-api-plugins.php

line: 41

function: sp_get_active_and_valid_plugins

Notice | Use of undefined constant SFPLUGINDIR – assumed ‘SFPLUGINDIR’
January 2, 2012

5:27 am

 php file: /simple-press/admin/library/spa-support.php

line: 205

function: Unavailable

Warning | opendir(/problem-with-post-edit-buttonome/betahpat/public_html/wp-content/plugins/simple-forum/styles/icons/default/custom/)[function.opendir]: failed to open dir: No such file or directory
January 2, 2012

5:27 am

 php file: /simple-press/admin/library/spa-support.php

line: 205

function: opendir

Warning | opendir(/problem-with-post-edit-buttonome/betahpat/public_html/wp-content/plugins/simple-forum/styles/icons/default/custom/) [function.opendir]: failed to open dir: No such file or directory
DO doctorb
doctorb
Member
Member since Dec 2011
87 posts
Jan 2, 2012 · 4:36 am

Yellow Swordfish said

Are you saying that something on your site changes the forum permalink? Or trashes it?

No. For no good reason, the forum starts redirecting all links to site home page.

 

I mean say the gereal forum links is shown as 

http://problem-with-post-edit-buttonpathy.com/forum/problem-with-post-edit-buttonomeopathic-discussion/

 

You click on the link and you get redirected to the site homepage instead of going inside that forum

 

Here are my forums

 

http://problem-with-post-edit-buttonpathy.com/forum/

 

Pls try to click on any forum name or post and u get redirected to home page.

 

This has happened many times so far. Usually gets resolved if I update the permalinks from wp-integration option in forum admin.

 

This time it aint helping.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jan 2, 2012 · 5:20 am

Could really do with separate topics here but we can try and deal with both.
First – the redirection. So- do you have any redirection set up on the site? Any redirection plugins? Yoasts SEO plugin?

The errors are somewhat confusing. Looks to me that the 6:55 errors are all down to php failing to load files. It’s easy to say this happens to us all from time to time but you can see form the messages that all the constants have not been loaded.

At the moment I am more concerned with the 5:27 errors because they are trying to access pre-V5 folders, folder names and locations. Do you have any idea why they would be trying to access the old ‘simple-forum’ folder used prior to V5?