Support Forum

Simple:Press 6 General Topics

no admin user has total access

no admin user has total access

Tony Bandalos

Member

Free Members

Offline

Jul 20, 2012 - 11:30 am

Hi,

I believe the user that originally installed simple press has been deleted. Regardless, no one has full access to all areas of the backend. I know my way around MySQL but can't seem to figure out how to make a user have complete master access. Can you tell me where to look in MySQL and what to put in there to make this happen?

Yellow Swordfish

Glinton, England

SP Master

Offline

Jul 20, 2012 - 2:46 pm

If there are NO forum admins defined at all then access is granted to WP admins so if this is not happening there must still be an SP admin defined on the system

To create an admin through the back door you need to look in the Usermeta table for that particular users capability settings. The following will set them up for WP admin and SP Admin caps. If there are any other plugins that set new capabilities we are unable to include these of course:

a:14:{s:13:"administrator";s:1:"1";s:18:"SPF Manage Options";s:1:"1";s:17:"SPF Manage Forums";s:1:"1";s:22:"SPF Manage User Groups";s:1:"1";s:22:"SPF Manage Permissions";s:1:"1";s:21:"SPF Manage Components";s:1:"1";s:15:"SPF Manage Tags";s:1:"1";s:16:"SPF Manage Users";s:1:"1";s:19:"SPF Manage Profiles";s:1:"1";s:17:"SPF Manage Admins";s:1:"1";s:18:"SPF Manage Toolbox";s:1:"1";s:24:"SPF Manage Configuration";s:1:"1";s:18:"SPF Manage Plugins";s:1:"1";s:17:"SPF Manage Themes";s:1:"1";}

Then for that same user you need to locate their row (using their user_id) in the sfmembers table and set to 1 the value in the column 'admin'