User roles broken after upgrade, suspect WordPress Wiki plugin

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.

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.

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!

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

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.