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
WP admin not SP admin
Avatar
Kevin Willis
Member
Free Members
sp_UserOfflineSmall Offline
Sep 21, 2012 - 11:48 am

After installation, it says that my WP admin account isn't my SP account .. okay, I can understand that .. HOWEVER, it says I need to speak with a SP admin to allow access and then it gives me the name of the account to ask ... 

But the account it tells me has SP admin access and to request access from IS THE ACCOUNT I'M LOGGED IN AS??

I'm logged in with the account that SP says has admin access but the account doesn't have access  ... HELP??

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 21, 2012 - 2:39 pm

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Kevin Willis
Member
Free Members
sp_UserOfflineSmall Offline
Sep 21, 2012 - 4:36 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 22, 2012 - 3:16 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Kevin Willis
Member
Free Members
sp_UserOfflineSmall Offline
Sep 24, 2012 - 1:07 pm

where do I find these databases?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 24, 2012 - 2:05 pm

Ah sorry - was hoping you would know. It's always good to know about your database smile

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Kevin Willis
Member
Free Members
sp_UserOfflineSmall Offline
Sep 26, 2012 - 11:52 am

WORKED! ... thanks for your help ... 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 26, 2012 - 12:23 pm

Ah good news. Thanks for the update.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
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: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625