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
Cannot Access Back-end settings from wp-admin
Avatar
nomis78
Guest
Guests
Mar 8, 2012 - 4:05 pm

Hi hope you guys can help

 

the master admin account is unable to access the back end settings of the sp-forum installation from the wp-admin dashboard.

 

the only option that it is showing is \"Admins - Your Admin Options\"

 

this means all users are lockout of the forums because none of the admins including the master can change any of the settings.

 

please help as were completely adrift because of this

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Mar 8, 2012 - 9:21 pm

master admin account??? what is that??  a wp admin or sp admin?? they are not the same thing...

at install of sp, only the wp admin that did the install can access the sp admin panels...  to add more sp admins, the main sp admin (the one who installed) can go to forum - admins - manage admins and make anyone an sp admin...

Avatar
Phil Robins
Member
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 9:24 am

I have a problem similar to this - I've taken over a site developed by someone else and it is a bit of a mess.  I am new to Simple Press.  I understand that in the MySQL DB there is a table called wp_sfmembers with a field called admin and if I set this to 1 for my account, when I click on the Forum within the WP admin my admin options are very restricted  - to only Admins -> Your Admin  and ->Options (see screenshot).

 

If I take out the 1 and set it to 0 - I have no admins (only WP admins) and I see all the options.

Any ideas how to fix this?sp_admin_options.pngImage Enlarger

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 9:48 am

No, setting your admin column in sfmembers is not enough to get you admin access... So you do not have access to one of the SP admin accounts?? if you do, you could set up additional SP admins on forum - admins - manage admins... as you are seeing, a wp admin is not an sp admin by design... this allows you to have regular wp users (ie subscribers) be sp admins but not have access to any of the wp admin stuff...

if you cannot access the sp admin via a true sp admin account, in addition to the admin column in sfmembers, you need to set up some wp capabilities... in the wp usermeta table, for your user id, for a meta key of wp_capabilities (your prefix might not be wp_), add this entry for meta_value:

a:14:{s:13:"administrator";s:1:"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:15:"SPF Manage Tags";b:1;s:16:"SPF Manage Users";b:1;s:19:"SPF Manage Profiles";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:18:"SPF Manage Plugins";b:1;s:17:"SPF Manage Themes";b:1;}

Avatar
Phil Robins
Member
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 10:07 am

Thanks - I found that suggestion on another post - but it still doesn't work for me.  I get the same result.  I have entered the meta_value into the meta table where meta_key = <myprefix>capabilities which has no effect, that I can see.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 10:28 am

sorry... result being?

are you sure you entered the user meta data correctly?? key is the point I mentioned about wp_... that should match whatever you wp db prefix is... so if you have wp_options table, wp_ is correct... but if its xxxx_options (the actual db table name), then it would be xxx_capabilities...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 10:28 am

sorry... result being?

are you sure you entered the user meta data correctly?? key is the point I mentioned about wp_... that should match whatever you wp db prefix is... so if you have wp_options table, wp_ is correct... but if its xxxx_options (the actual db table name), then it would be xxx_capabilities...

Avatar
Phil Robins
Member
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 10:37 am

 thanks again for helping out on this - my prefix is iropi - so my table is iropiusermeta - my meta_key value is iropicapabilities

It doesn't seem to make any difference at all - I still get the restricted section of the forum admin within WP.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 10:58 am

just to be clear, it would be iropi_capabilities... you did not have the underscore in what you posted...

Avatar
Phil Robins
Member
Free Members
sp_UserOfflineSmall Offline
Sep 5, 2012 - 12:18 pm

The person who setup Wordpress omitted the underscore - so no tables have an underscore - nor any other WP related data - I added the underscore to the meta_key and refreshed the screen - but it makes no difference either.

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: 17366
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626