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
Manually add new Simple:Press forum administrator
Avatar
Bluedrake42
Member
sp_UserOfflineSmall Offline
Jan 17, 2016 - 11:03 am

Hello. So. I'm stupid, and I deleted our only admin account for Simple:Press while setting up our website... before giving it to someone else.

Is it possible to login via FTP, or manage our database to manually add a new Simple:Press forum administrator? That would be fantastic if so, and would save us having to reinstall the forums entirely.

Thanks!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 17, 2016 - 11:26 am

We are awaiting a new hook in the WordPress delete user page to arrive (next update we believe) so that we can at the very least warn people of what they are about to do... It has been a long time coming!

So yes - find out the user ID of the person who is to become the new forum admin. You will need that. Then, in the xx_userrmeta table, locate the row where the user_id column matches and the meta_key is equal to xx_capabilities. In both instances here the xx_ is your WP table prefix.

To give the user a WordPress Administrator role and a full Simple:Press Admin status, paste the following into the meta_value column of the record:

a:20:{s:13:"administrator";b:1;s:18:"SPF Manage Options";b:1;s:17:"SPF Manage Forums";b:1;s:22:"SPF Manage User Groups";b:1;s:22:"SPF Manage Permissions";b:1;s:21:"SPF Manage Components";b:1;s:16:"SPF Manage Users";b:1;s:17:"SPF Manage Admins";b:1;s:18:"SPF Manage Toolbox";b:1;s:24:"SPF Manage Configuration";s:1:"1";s:19:"SPF Manage Profiles";b:1;s:15:"SPF Manage Tags";b:1;s:17:"SPF Manage Themes";b:1;s:18:"SPF Manage Plugins";b:1;s:22:"SPF Manage Integration";b:1;s:16:"SPF Manage Polls";b:1;s:13:"SPF Manage PM";b:1;s:19:"SPF Manage Warnings";b:1;s:17:"SPF Manage Emails";b:1;s:10:"subscriber";b:1;}

I can see has one or two plugins added but that is OK. If you need to modify anything go to the forum admin > Admins > Manage Admins and do it there,. If you have any other plugins that add capabilities you may need to then adjust this user to add those back in.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 17, 2016 - 1:05 pm

if all sp admins were deleted, then all wp admins would have access...  so must still be one hanging around...  andy's fix works fine regardless...

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