Log In
Register
Home
Add Reply
Add Topic
Topic RSS
6:50 am
QuoteSo I run a website, and use the 4.0.2 version of simple press.
Today I was trying to fix the user group permissions set, and somehow erased all permissions sets : so that even though I am the admin I can no longer see things like Forum Options, Users, Admin Lists, etc etc.
How can I fix this ?
Suggestions ?
Thanks !
permission sets have nothing to do with viewing admin… do you mean you removed all the spf admin capabilities?
There must still be one admin account that has spf admin abilities or else you would see a notice to this effect and all wp admins would have access…
please clarify….
Visit 6:57 am
i have tried logging in with all the administrator accounts, and all 3 accounts get this same page :
http://peoplesbike.com/wp-admi…..ptions.php
no admins can see any of the forum options !
but you didnt answer my question…. and I will say it again, if no spf admins (not wp admin) exist, all wp admins will have access.
if you think you removed the spf admin capabilities (vs permissions that you stated), you can restore them via phpmyadmin or other db admin tool… find the wp_usermeta (your prefix might differ) table… and for your user id and meta_key of wp_capabilities (again, your prefix might differ), reset the meta value to
a:12:{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:17:"SPF Manage Admins";b:1;s:16:"SPF Manage Users";b:1;s:18:"SPF Manage Toolbox";b:1;s:24:"SPF Manage Configuration";b:1;s:19:"SPF Manage Profiles";b:1;s:13:"administrator";b:1;s:15:"SPF Manage Tags";b:1;s:18:"SPF Manage Options";b:1;}
this will give you all spf admin capabilities again… careful of single and double quotes as sometimes they get munged when copying…
If you upgraded to the latest spf version 4.1.2, it would prevent you from accidentally removing all admin caps too…
7:24 am
i defnitely removed all the spf admin capabilities, still not sure how i managed that . .
when trying to locate wp_usermeta i could not find it. nor could i find the wp_capabilities . .
ugh, im lost. sorry to be a pain, this whole world of wordpress is new to me.
any more suggestions ?
do you have access to phpmyadin on your server? if so, your blog MUST have a usermeta table… wp_ is the default wp prefix, but yours might be diff. then within the usermeta, for wp admins, you will have a meta_key of wp_capabilities (again, the wp_ part may differ)
10:57 am
ok so i finally found the meta_key and wp_capabilities – but not sure how to reset the meta value . .
attached is a link to the screenshot. can someone put me in the right direction?
thanks !
11:39 am
SP Master
Nov 9, 2008
Offline
Display the whole table (usermeta) in 'browse' mode – all columns. Order it by the user_id column. No need for a SQL query (especially not a count clause). Or – show all columns where the user_id is your user_id.
If you show all columns then you will see the row where the user_id is yours and the meta_key is wp_capabilities. You need to edit that row (there is normally an icon in the view against the row – maybe a pencil?) In the meta_value column paste the text that Steve gave you above and save.
Yellow Swordfish
Most Users Ever Online: 444
Currently Online: chucktho, SPQC
53 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
-Radio-: 1251
Lee H: 606
Luffer: 535
Conrad_Farlow: 485
jim: 478
neon: 263
ovizii: 240
Tal: 240
Member Stats:
Guest Posters: 2616
Members: 7328
Moderators: 1
Admins: 2
Forum Stats:
Groups: 5
Forums: 16
Topics: 10839
Posts: 79118
Newest Members: ordie69, mutha66, jawaulk, mastergalen, ikkiamonrah, OlafKS, js, Anne Wayman, vinzMtl, VikingBrent
Moderators: Brandon C (158)
Administrators: Yellow Swordfish (22131), Mr Papa (23580)
Privacy Policy
