So i can assume that you installed SP while logged in using this account? Is that correct?
And if so – did the install appear to go OK? If you are missing this account plus the page was not created (from other thread) then it suggests that this wasn’t the case so can you talk me though what happened?

And might you be running some sort of security plugin that might have stopped these items being created outside of the WP UI?

I installed SP a month ago but never activated it ..

when I went to activate it today so I could set it up it said there was an updated version – so I clicked auto-update and the update appeared to go fine

yes, I did use this WP admin user account to install the plugin  .. its the only WP admin account I use

I have WP membership software called Digital Access Pass (DAP) that integrates with SimplePress but I haven’t gotten far enough to run the integration settings that allow members to access forums

after I activated SP, it asked to update the database and I said ok – it appeared to run ok and said update successful

this is when I clicked the forum tab in WP and got the message that my WP admin wasn’t an SP admin and I should talk to the SP admin to get access – but I was logged in as the admin it suggested 

please advise

thanks in advance for your help

This is most strange. Your status as an SP admin is controlled by two items of data in your database and I am going to have to ask you to look at these and hope you are able to do so.

The first is in the forum table named ‘sfmembers’. Locate the row that equates to your own WP User_id. There is a column simply named ‘admin’ and for your row and in that column should be a number 1. If this is not the case then edit the row and change it and see if that is all that is needed.

If already a 1 – or if changing it to 1 makes no difference – then the other item is within the WP capabilities record.

This is held in the wp table ‘usermeta’ and again – look for the row with your user_id and in this case a meta_key name that is your WP table prefix plus the word ‘capabilities’. You need to be careful here as if you have other plugins that add capabilities you do not want to lose them. If the only capability shown is ‘Administrator’ (and the entry starts with something like ‘a:1’) then you should be safe to change it. If there are other capabilities listed then do NOT change it.

A full capabilities entry that contains both WP Administrator rights and SP Admin rights is:

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

which you should be able to copy and paste in to that column in the db. It is, of course, imperative that this is copied in exactly as shown.

where do I find these databases?

Ah sorry – was hoping you would know. It’s always good to know about your database

There is usually a link to phpMyAdmin in your hosting control panel. This is a web application that allows you to interrogate your database, edit, browse, import and export as well run various housekeeping tasks to keep your database healthy.

It is perfectly safe to open it up and browse the content. if you are worried about making changes to raw data then we can, of course, happily check that out for you but we would then need access to your phpMyAdmin tool.

WORKED! … thanks for your help … 

Ah good news. Thanks for the update.