WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Wiki
User roles broken after upgrade, suspect WordPress Wiki plugin (7 posts)

  1. nibb
    Member
    Posted 3 years ago #

    Howdy folks
    since we moved to WP 3.0 and then 3.0.1 our user roles are utterly corrupted, we only have one role now - Wiki Editor, this makes even changing peoples passwords impossible as the edit section on multiple sites has the drop down for roles fixed to the Wiki Role, which is not recognised when a new password is entered and the submit button hit.

    Getting to be a serious problem lads, even deleting your plugin seems not to restore matters.

  2. James
    Happiness Engineer
    Posted 3 years ago #

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

  3. Matthew Gerring
    Member
    Plugin Author

    Posted 3 years ago #

    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.

  4. nibb
    Member
    Posted 3 years ago #

    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.

  5. nibb
    Member
    Posted 3 years ago #

    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!

  6. nibb
    Member
    Posted 3 years ago #

    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

  7. nibb
    Member
    Posted 3 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic