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…

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?

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;}

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.

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…

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…

 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.

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

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.

if there really is no underscore in the wp db prefix, than you would want to remove it also in the meta_key… and you did if for your user id? and set the admin column to 1 in sfmembers for this user?

can you post your entire usermeta entry?

and if that is not working, please explain the issue again – perhaps I have misunderstood you…

to be clear, not the entire usermeta… just the single entry you added…

umeta_id = 12

user_id = 4

meta_key = iropicapabilities

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;}

I’ve set admin to 1 in iropisfmembers for user_id = 4

I get a very restricted set of options in WP for the Forum plugin 

The below screenshot is what I see…

if I set all rows to admin = 0 in in iropisfmembers (so that I have no SP admins – but only WP admins) I get the below screen which is what I want.

One other thing –  through another plugin Admin Menu Editor – the menu in the left column of WP changes from Course Forum (with admin set to 1) to Forum (with admin set to 0) – actually as I type this – I realise that this was probably the issue – I deactivated that plugin as well as another Advanced Access Manager – Hey presto it works now…  Thanks a lot for your help – I got there in the end.

good news… actually, the other day we had an issue with the advanced access manager causing problems with some plugins, including Simple Press where they were managing admin capabilities… Need to remember about that one…