Widgets page missing from WPMU member blog admin
-
“Widgets” should appear under “Appearance” on the left side options of the wp-admin.
Appearance
> Themes
> Widgets“Widgets” is missing. I haven’t done any updates recently except upload 2 dozen themes. I have deleted all those themes, thinking they caused the problem, but this did not fix the problem.
You can see it for yourself:
https://totoymola.religioner.no/wp-admin/
username: *obfuscated*
password: *obfuscated*
-
Thanks Sam!
Can you reproduce the entire list of capabilities for the administrator — not just the additions and subtractions?
Really appreciate your help
I had an Amazon Wishlist (and then Amazon ripped me off and refused to take a DVD back that had broken in shipping because I ordered it 6 months prior … Pre ordering, you see) so I don’t Amazon anymore. I’m a shop-local girl as much as I can ?? But thank you (the closest I get these days is I have a paypal link off ipstenu.org ?? )
if we have to do this tedious task for every member tables that we have in our database, this is absolutely absurd. we have hundreds of members.
Are you experiencing the exact same issue, with the exact same table results?
Also, a SQL script can handle these changes en masse.
i have access to phpmyadmin. does anyone have that script?
i have this entry:
a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:48:{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: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:14:"edit_dashboard";b:1;s:12:"manage_email";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:33:{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: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:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{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:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{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:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}so where do i add this:
s:15:"unfiltered_html";b:1; s:17:"unfiltered_upload";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;hi
we having this same issue right now too
and we have 256 databases by multi-database plugin
and in each database there is hundreds of tables !
how can we update all of wp_BlogId_user_roles in wp_BlogId_options in 256 databases ?I have this same issue. Admins missing their widget areas ??
My upgrade path was:
WPMU 2.8.4 (EPEL) to 2.8.6 (EPEL) to 2.9.2 to 3.0.1
If I get a query sorted out I’ll certainly share it.
Hopefully I won’t have to update that tuple 150 times manually…Did you see the threads about how the most common reason for this was the theme?
@andrea_r I’ve tried activating twentyten but the widgets menu is still missing. I have not tried plugin deactivation yet but plan to on Monday when our serverhuggers can copy our VM somewhere.
On twentyten on a fresh install, I cannot reproduce the issue.
In other words, if I’m using a fresh installation, and I log in as an admin on a second site (and not super admin) I can see the widgets menu.
I have another fresh 3.0.1 install that does not have this issue as well. Maybe related to the upgrade path?
I’ve found that wp_###_user_roles tuples in the wp_###_options tables are also missing some permission directives. Newly created sites have 56 while all site created pre-upgrade have 49
a:5:{ s:13:"administrator";a:2:{ s:4:"name"; s:13:"Administrator"; s:12:"capabilities"; a:49:{ 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: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:14:"edit_dashboard";b:1; s:13:"manage_cforms";b:1; s:12:"track_cforms";b:1;} } s:6:"editor";a:2:{ s:4:"name"; s:6:"Editor"; s:12:"capabilities"; a:33:{ s:17:"moderate_comments";b:1; s:17:"manage_categories";b:1; s:12:"manage_links";b:1; s:12:"upload_files";b:1; ....Looks like I’ll end up doing what @sam_h1 did and copy wp_###_user_roles to all the old wp_###_options tables.
Also, here’s a link to the thread he started on
wptavern.Yep, you’ll probably have to do that.
I suggest the following for discussion, don’t run on a live site, backup yadayada. If old user_roles tables need to be upgrade/reset to reflect new upgrades why not just re-populate_roles?
Add following to mu-plugins, delete when used once.
<?php function ds_reset_roles_per_blog($blog_id) { require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); switch_to_blog( $blog_id ); populate_roles(); restore_current_blog(); } add_action( 'wpmu_upgrade_site', 'ds_reset_roles_per_blog' ); ?>Now when I click the SuperAdmin->Update, each site gets blasted with the default user_roles erasing any old tinkerin or plugin mods of the sites existing user_roles.
Any problems with this approach?
@dsader – That is so much more elegant the my brute-force php database update.
$new_value = 'a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:56:{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: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:14:"edit_dashboard";b:1;s:15:"unfiltered_html";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:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:34:{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: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:15:"unfiltered_html";b:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{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:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{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:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}'; for ($i=1;$i<195;$i++) { $query = "SELECT option_name FROM WORDPRESSDATABASE.wp_".$i."_options WHERE EXISTS (SELECT * FROM WORDPRESSDATABASE.wp_".$i."_options WHERE option_name = 'wp_".$i."_user_roles') AND option_name = 'wp_".$i."_user_roles';"; $result = mysql_query($query); echo $i.': '; if ($result) { while ($row = mysql_fetch_assoc($result)) { $query2 = "UPDATE WORDPRESSDATABASE.wp_".$i."_options SET option_value= '".$new_value."' WHERE option_name = '".$row['option_name']."'"; $result2 = mysql_query($query2); if (!$result2) { echo 'Invalid query: ' . mysql_error() . "\n"; //echo 'Whole query: ' . $query; } echo $row['option_name']; } } else { echo "<font color=red>WORDPRESSDATABASE.wp_".$i."_options does not exist</font>"; } echo ' <br />'; } mysql_close($link);
- The topic ‘Widgets page missing from WPMU member blog admin’ is closed to new replies.