Moderator
James Huff
(@macmanx)
Volunteer Moderator
Access your database via phpMyAdmin (most hosting providers offer this in their control panel), go to the wp_users
table and find the row for your user_login
. Note the ID
of this row. Now, go to the wp_usermeta
table and find the wp_capabilities
row for your user_id
. Set the value of this row to a:1:{s:13:"administrator";b:1;}
So sorry to hear this. My sincere apologies. We’re doing research on the WordPress role and capability system, and a fix will be available within a few weeks with WordPress Wiki 0.9.
WordPress Wiki doesn’t write anything to the database as far as user roles, so I’m not sure that’s what caused the corruption, but in any case, a fix will be available shortly.
Thread Starter
nibb
(@nibb)
Got to admin Beatpanda I was confused as to what might have happened too. Hope its not the plugin to be honest, that its the only reference in the drop down hints at a possible, but lets face it, could be the interaction of a couple of plugins.
Thanks for the info James.
Thread Starter
nibb
(@nibb)
Strewth, looking like the capabilities table no longer exists! Which would of course answer everything.
Wonder if we can stitch one in from a virginal install.
No one recalls touching the tables either. Could possibly have happened during upgrade I guess, we were an original WPMU (i.e. the 2.x series offering before WP 3 amalgamated things together.
Apolos to the plugin team – might have nothing to do with you guys at all!
Thread Starter
nibb
(@nibb)
Hang on, sorry, spouting before I have caught up on myself, its been one of those weekends. Of course, there isn’t a table for wp_capabilities is there! Doh!
So – back to James, cheers for that, will have a go!
Back to plugin chaps – could still be the plugin thats changed matters, will contribute as much info to you as I can chaps
cheers all
Thread Starter
nibb
(@nibb)
Yup,
its looking like the correct data is still in the tables:
mysql> select user_id,meta_key,meta_value from wp_usermeta where meta_key like '%capabilities%';
+---------+--------------------+-------------------------------------+
| user_id | meta_key | meta_value |
+---------+--------------------+-------------------------------------+
| 1 | wp_1_capabilities | a:1:{s:13:"administrator";b:1;} |
| 2 | wp_1_capabilities | a:1:{s:13:"administrator";b:1;} |
| 3 | wp_9_capabilities | a:1:{s:13:"administrator";b:1;} |
| 4 | wp_2_capabilities | a:1:{s:13:"administrator";b:1;} |
| 5 | wp_3_capabilities | a:1:{s:13:"administrator";b:1;} |
| 2 | wp_4_capabilities | a:1:{s:13:"administrator";b:1;} |
However, the only value that appears within the admin functions (Site backend or edit when you get a list of your blogs/network) is Wiki Editor – no other options (Editor, Author, Subscriber etc) appear.