User Roles Pulldown is empty
-
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
-
This solution doesn’t solve my problem: http://paulstamatiou.com/how-to-quickie-repair-mysql-tables-in-phpmyadmin/
I deactivated all plugins, but no effect: The user roles pulldown is still empty.
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.
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;}}}
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).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,
ChrisUser 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.)
The topic ‘User Roles Pulldown is empty’ is closed to new replies.