• Resolved Christian

    (@christiankramer)


    Hi,

    since yesterday in every admin page the user roles pulldown is empty. Existing users have a role, but roles can not be assigned to new users.

    This small script tells me all roles are ok.

    <?php
    include("wp-config.php");
    global $wpdb;
    $wp_user_roles = get_option($wpdb->prefix."user_roles") or
      die ("Die Option '".$wpdb->prefix."user_roles' is broken.");
    echo("Die Option '".$wpdb->prefix."user_roles' is ok.");
    ?>

    How can I repair this error without re-install?

    Thanks for a hint.
    Please help me!
    CK

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter Christian

    (@christiankramer)

    Thread Starter Christian

    (@christiankramer)

    I deactivated all plugins, but no effect: The user roles pulldown is still empty.

    Thread Starter Christian

    (@christiankramer)

    Also I tried the solution here: http://wordpress.stackexchange.com/questions/11725/help-why-my-roles-are-not-showing-multi-site-network/23471#23471

    No effect. 🙁

    BTW: Only one subsite is affected. In all other subsites the pulldown comes with the roles.

    Thread Starter Christian

    (@christiankramer)

    Ok, maybe it helps to paste the wp_user_roles content to find the error:

    a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:143:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:26:”view_all_aryo_activity_log”;b:1;s:16:”edit_tribe_event”;b:1;s:16:”read_tribe_event”;b:1;s:18:”delete_tribe_event”;b:1;s:19:”delete_tribe_events”;b:1;s:17:”edit_tribe_events”;b:1;s:24:”edit_others_tribe_events”;b:1;s:26:”delete_others_tribe_events”;b:1;s:20:”publish_tribe_events”;b:1;s:27:”edit_published_tribe_events”;b:1;s:29:”delete_published_tribe_events”;b:1;s:27:”delete_private_tribe_events”;b:1;s:25:”edit_private_tribe_events”;b:1;s:25:”read_private_tribe_events”;b:1;s:16:”edit_tribe_venue”;b:1;s:16:”read_tribe_venue”;b:1;s:18:”delete_tribe_venue”;b:1;s:19:”delete_tribe_venues”;b:1;s:17:”edit_tribe_venues”;b:1;s:24:”edit_others_tribe_venues”;b:1;s:26:”delete_others_tribe_venues”;b:1;s:20:”publish_tribe_venues”;b:1;s:27:”edit_published_tribe_venues”;b:1;s:29:”delete_published_tribe_venues”;b:1;s:27:”delete_private_tribe_venues”;b:1;s:25:”edit_private_tribe_venues”;b:1;s:25:”read_private_tribe_venues”;b:1;s:20:”edit_tribe_organizer”;b:1;s:20:”read_tribe_organizer”;b:1;s:22:”delete_tribe_organizer”;b:1;s:23:”delete_tribe_organizers”;b:1;s:21:”edit_tribe_organizers”;b:1;s:28:”edit_others_tribe_organizers”;b:1;s:30:”delete_others_tribe_organizers”;b:1;s:24:”publish_tribe_organizers”;b:1;s:31:”edit_published_tribe_organizers”;b:1;s:33:”delete_published_tribe_organizers”;b:1;s:31:”delete_private_tribe_organizers”;b:1;s:29:”edit_private_tribe_organizers”;b:1;s:29:”read_private_tribe_organizers”;b:1;s:10:”copy_posts”;b:1;s:18:”wysija_newsletters”;b:1;s:18:”wysija_subscribers”;b:1;s:13:”wysija_config”;b:1;s:16:”wysija_theme_tab”;b:1;s:16:”wysija_style_tab”;b:1;s:22:”wysija_stats_dashboard”;b:1;s:10:”list_roles”;b:1;s:12:”create_roles”;b:1;s:12:”delete_roles”;b:1;s:10:”edit_roles”;b:1;s:16:”restrict_content”;b:1;s:18:”hide_my_wp_trusted”;b:1;s:34:”wpml_manage_translation_management”;b:1;s:21:”wpml_manage_languages”;b:1;s:41:”wpml_manage_theme_and_plugin_localization”;b:1;s:19:”wpml_manage_support”;b:1;s:29:”wpml_manage_media_translation”;b:1;s:22:”wpml_manage_navigation”;b:1;s:24:”wpml_manage_sticky_links”;b:1;s:30:”wpml_manage_string_translation”;b:1;s:33:”wpml_manage_translation_analytics”;b:1;s:25:”wpml_manage_wp_menus_sync”;b:1;s:32:”wpml_manage_taxonomy_translation”;b:1;s:27:”wpml_manage_troubleshooting”;b:1;s:31:”wpml_manage_translation_options”;b:1;s:36:”wpml_manage_woocommerce_multilingual”;b:1;s:37:”wpml_operate_woocommerce_multilingual”;b:1;s:13:”groups_access”;b:1;s:19:”groups_admin_groups”;b:1;s:20:”groups_admin_options”;b:1;s:22:”edit_un_feedback_items”;b:1;s:16:”edit_un_feedback”;b:1;s:18:”delete_un_feedback”;b:1;s:19:”publish_un_feedback”;b:1;s:25:”publish_un_feedback_items”;b:1;s:29:”edit_others_un_feedback_items”;b:1;s:26:”edit_published_un_feedback”;b:1;s:15:”wpseo_bulk_edit”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:82:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;s:16:”edit_tribe_event”;b:1;s:16:”read_tribe_event”;b:1;s:18:”delete_tribe_event”;b:1;s:19:”delete_tribe_events”;b:1;s:17:”edit_tribe_events”;b:1;s:24:”edit_others_tribe_events”;b:1;s:26:”delete_others_tribe_events”;b:1;s:20:”publish_tribe_events”;b:1;s:27:”edit_published_tribe_events”;b:1;s:29:”delete_published_tribe_events”;b:1;s:27:”delete_private_tribe_events”;b:1;s:25:”edit_private_tribe_events”;b:1;s:25:”read_private_tribe_events”;b:1;s:16:”edit_tribe_venue”;b:1;s:16:”read_tribe_venue”;b:1;s:18:”delete_tribe_venue”;b:1;s:19:”delete_tribe_venues”;b:1;s:17:”edit_tribe_venues”;b:1;s:24:”edit_others_tribe_venues”;b:1;s:26:”delete_others_tribe_venues”;b:1;s:20:”publish_tribe_venues”;b:1;s:27:”edit_published_tribe_venues”;b:1;s:29:”delete_published_tribe_venues”;b:1;s:27:”delete_private_tribe_venues”;b:1;s:25:”edit_private_tribe_venues”;b:1;s:25:”read_private_tribe_venues”;b:1;s:20:”edit_tribe_organizer”;b:1;s:20:”read_tribe_organizer”;b:1;s:22:”delete_tribe_organizer”;b:1;s:23:”delete_tribe_organizers”;b:1;s:21:”edit_tribe_organizers”;b:1;s:28:”edit_others_tribe_organizers”;b:1;s:30:”delete_others_tribe_organizers”;b:1;s:24:”publish_tribe_organizers”;b:1;s:31:”edit_published_tribe_organizers”;b:1;s:33:”delete_published_tribe_organizers”;b:1;s:31:”delete_private_tribe_organizers”;b:1;s:29:”edit_private_tribe_organizers”;b:1;s:29:”read_private_tribe_organizers”;b:1;s:10:”copy_posts”;b:1;s:22:”edit_un_feedback_items”;b:1;s:16:”edit_un_feedback”;b:1;s:18:”delete_un_feedback”;b:1;s:19:”publish_un_feedback”;b:1;s:25:”publish_un_feedback_items”;b:1;s:29:”edit_others_un_feedback_items”;b:1;s:26:”edit_published_un_feedback”;b:1;s:15:”wpseo_bulk_edit”;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:35:{s:12:”upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;s:22:”delete_published_posts”;b:1;s:16:”edit_tribe_event”;b:1;s:16:”read_tribe_event”;b:1;s:18:”delete_tribe_event”;b:1;s:19:”delete_tribe_events”;b:1;s:17:”edit_tribe_events”;b:1;s:20:”publish_tribe_events”;b:1;s:27:”edit_published_tribe_events”;b:1;s:29:”delete_published_tribe_events”;b:1;s:16:”edit_tribe_venue”;b:1;s:16:”read_tribe_venue”;b:1;s:18:”delete_tribe_venue”;b:1;s:19:”delete_tribe_venues”;b:1;s:17:”edit_tribe_venues”;b:1;s:20:”publish_tribe_venues”;b:1;s:27:”edit_published_tribe_venues”;b:1;s:29:”delete_published_tribe_venues”;b:1;s:20:”edit_tribe_organizer”;b:1;s:20:”read_tribe_organizer”;b:1;s:22:”delete_tribe_organizer”;b:1;s:23:”delete_tribe_organizers”;b:1;s:21:”edit_tribe_organizers”;b:1;s:24:”publish_tribe_organizers”;b:1;s:31:”edit_published_tribe_organizers”;b:1;s:33:”delete_published_tribe_organizers”;b:1;s:15:”wpseo_bulk_edit”;b:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:20:{s:10:”edit_posts”;b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;s:16:”edit_tribe_event”;b:1;s:16:”read_tribe_event”;b:1;s:18:”delete_tribe_event”;b:1;s:19:”delete_tribe_events”;b:1;s:17:”edit_tribe_events”;b:1;s:16:”edit_tribe_venue”;b:1;s:16:”read_tribe_venue”;b:1;s:18:”delete_tribe_venue”;b:1;s:19:”delete_tribe_venues”;b:1;s:17:”edit_tribe_venues”;b:1;s:20:”edit_tribe_organizer”;b:1;s:20:”read_tribe_organizer”;b:1;s:22:”delete_tribe_organizer”;b:1;s:23:”delete_tribe_organizers”;b:1;s:21:”edit_tribe_organizers”;b:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:5:{s:4:”read”;b:1;s:7:”level_0″;b:1;s:16:”read_tribe_event”;b:1;s:20:”read_tribe_organizer”;b:1;s:16:”read_tribe_venue”;b:1;}}}

    Thread Starter Christian

    (@christiankramer)

    Another try: Installing the Members plugin to add new roles to the user roles table.
    I open the roles panel in Users (appears after activation the Members plugin) and see the default wp-roles with the count of wp-users and three more roles from Members with 0 wp-user. I can edit all roles and the capabilities.

    But after adding a new role all default roles are gone. Only the new added role appears.
    I checked the wp_4_options in the database. The new role overwrote/deleted all default roles (see post above).

    Thread Starter Christian

    (@christiankramer)

    Installed new plugin User Role Editor didn’t brought a solution. The role pulldown is still empty.

    Please, does anyone have a hint?

    Thanks a lot,
    Chris

    Thread Starter Christian

    (@christiankramer)

    User Role Editor didn’t brought the solution.

    Another way: I took the content of wp_options field name wp_user_roles of a fresh install and pasted it into the affected field. Now it works again.

    (It think it is important, that no additional user role was defined in the affected data field to take the original assignments.)

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘User Roles Pulldown is empty’ is closed to new replies.