Widgets page missing from WPMU member blog admin

dexternica – Did you check the user permissions for each user?

I know there’s a string of stuff (like a:blahblah) in there, and THAT is what I referred to ages back as being what MIGHT be out of whack.

Of course, knowing what’s right is a challenge.

Just to make sure, no one has been able to make ANY admin account for this sub-site with access to widgets and users? Correct?

Ok so we just created a brand new blog – with a brand new user…the widget menu *was* available for this user.

What I’ve now just done is made this new user an admin user on a previously existing blog (that was having the menu error). As expected, when logged in as the new user on the old blog, it still didn’t display the widget menu. I guess that’s in answer to you ipstenu!

The old version of WPMu used to generate an individual table for each blog – that’s correct yeh? But 3.0 has everything in one table?

I’ve tried changing user roles to Admin (even if they were already admin) but that hasn’t helped. Running out of ideas now!

Out of interest @terjefevaag have you ever used any plugins in the past that have manipulated the databse to allow it to scale better – or is yours a relatively fresh install/upgrade?

The old version of WPMu used to generate an individual table for each blog – that’s correct yeh? But 3.0 has everything in one table?

The db structure is *exactly the same* as it was for mu.

Maybe something hiding in the old blog settings, hrm.

The old version of WPMu used to generate an individual table for each blog – that’s correct yeh? But 3.0 has everything in one table?

No, it’s the same. Each blog has it’s own table.

If I look at wp_usersmeta for my ID, I see this for wp_1_capabilities
a:1:{s:13:"administrator";s:1:"1";}

Check those for your admins who don’t have access to the blogs (you’ll obviously need to match up wp_#_capabilities per blog). I think you can force this in.

Cheers for the clarification on the tables/db – it’s been a long day of trying to fix this (and the server crashing for no less than 5 hours!!) we just got a bit lost for a second!

We will try your idea ipstenu

thank you both so much for your help.

I don’t know whether this has any bearing whatsoever, but should we also be seeing a ‘Custom Menu’ option panel (also under appearance?)

Ok well we checked
a:1:{s:13:"administrator";s:1:"1";}

And they were all as they should be – with administrator roles

In an attempt to eliminate other factors – should we upgrade all our themes and plugins?! I know, it’s bad hygeine not to have done them already!

Andrea_r mentioned in another place that some themes had function files that mucked with capabilities… Damn, brain is done.

always a good idea when troubleshooting picky issues like this is to disable all plugins (even mu-plugins) and revert to the default them (in this case, twentyten).

FIXED IT!!!

We’re currently celebrating in the office. Allow me to calm down before I post the solution!

ok…

We updated user role in wp_BLOGID_options table where
option_name = ‘wp_BLOGID_user_roles’ and checked the role for each and every entry to update the option_value parameter for that table; similar to what was suggested by ipstenu but had to write the whole query for every individual blog….

Thank you so much guys for your help – you’ve been quality

I hope that this is helpful in hopefully getting to the root of the problem (if of course it is a WP issue rather than one our end – the fact someone else is reporting the same issue suggests it could be WP)

Sam

Ah! I knew there was another one and just couldn’t get my head around it.

Ipstenu – do you have an amazon wishlist?

I know you do andrea!

We updated user role in wp_BLOGID_options table where
option_name = ‘wp_BLOGID_user_roles’ and checked the role for each and every entry to update the option_value parameter for that table;

Love to see what one was and what it needed to be switched to.

Hi @ sam_h1

Could you please be more descriptive of exactly what you did? What did you update the option_value for wp_#_user_roles to?

Having this same issue right now and would love to use your fix!

Well worryingly it isn’t just a quick change to one line but i’ll do my best to explain it!

We compared an old user (who didn’t have the menu) with a brand new user who did.

Following changes are made to the wp_BlogId_options table where option_name = ‘wp_ BlogId _user_roles’;

This was missing from the old user but existed in the new user. So we added them

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;

These didn’t exist in the new blog, but did exist in the old. So we removed them

s:22:"update_options_general";b:1;
s:22:"update_options_privacy";b:1;

It was my tech guy (rather than me personally) that found this solution. So apologies if my desctiption doesn’t quite make sense – I hope you get the gist!

Sam