Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Accidentally deleted my SP Admin Account
Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 29, 2017 - 8:23 am

Well, during some preventative maintenance operations, I deleted my WP Admin account (because it had an unsafe username). I had already created another admin account to do the deletion. 

However, before the deletion, I forgot to make the new admin a SP Admin. So now I can not access my own Forum on the Dashboard with the error message: 

"Please note that while you are a WP admin, you are not currently an SP admin. By default, WP admins are not SP admins

Contact one of the SP Admins listed below to see if they want to grant you SP admin access on the SP manage admins panel."

I do have two other SP Admins, but neither of them can make my new user account a SP Admin; at best, they can only make me a Moderator of a group. Neither of them have WP Admin capabilities. 

One of them replied with the attached screenshot.

1) Is he looking in the proper place to make me an Admin again?

2) Does he need WP Admin privileges for that?

3) is there any "back door" way I can regain access to be a Forum Admin?

Thanks!!!

- Willspimage_2.pngImage Enlarger

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 29, 2017 - 4:53 pm

Yes if you do not mind getting into the database. The following links to a post where this was discussed - the details are in there although you can ignore the actual problem that user had.

https://simple-press.com/suppo.....r/#p158568

So are you definite that there are no other SP admins and the two people who were offered to help you were only moderators? It should not offer them so I may have to open up a ticket of you confirm this...

andy-signature.png
YELLOW
SWORDFISH
Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:10 pm

The other two guys are SP Admins, not moderators, but they are not WP Admins on my site. The screen shot above was from one of them; he couldn't find a way to add me - he wondered if he also needed to be a WP Admin in order to add me back - if so, that's easy. So that was the original issue. Hopefully I won't have to get into the database... 

- Will

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:22 pm

No, that is the beauty of the system...  you can make any user an SP admin and they wont get access to anymore of the wp backend then as regular user (except of course for the forum stuff)...

any SP admin with the manage admin capability can make users SP admins... its done on forum - admins - manage admins...  down towards the bottom, find the users in the Add New Admins section and then after moving to the right window, hit Add New Admins button at the bottom...

if you have no SP admins, then all WP admins can access the simple press admin pages...

Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:34 pm

OK thanks - I've pinged one of them again to see if he may have success. I will also send your instructions. Only problem is they are both on the other side of the pond...

- Will

Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:38 pm

also, I don't remember if I gave them "manage admins" capability... ugh : (

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:43 pm

Worst case, we can give you some data to load into your mysql database that will re-enable it for you...  but lets if they can first, since you mentioned not wanting to mess with database...

Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 29, 2017 - 7:48 pm

Thanks a ton - yeah, I will find out tomorrow what happened with them. And, I've never poked into a SQL database so that's something that is a last resort... 

Thanks again

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 29, 2017 - 11:58 pm

just let us know... we will be here...

Avatar
William Pirkle
Member
sp_UserOfflineSmall Offline
Jan 30, 2017 - 8:13 am

OK both Admins do not have the ability to manage other Admins. The second admin sent a screenshot with a lock next to "Manage Admins" so, although I do have 2 admins, they can't manage other admins and get me back in. 

So it looks like I am going to need to use the fix above.

However, I do not know what file he is talking about in that post, or how to open/get into it. I have never looked at SQL code (I'm a C++ programmer) so that looks as greek to me as Javascript...

Could you please provide some details on how to get into that database (which one is it? where is it located? what tool to use to open it?) and any other details about this fix? 

Thanks!

Will 

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626