Lost Admin Privileges

robing
(@robing)

16 years, 9 months ago

I moved a blog from a MU installation to a standalone WordPress 2.84. I dumped the sql, made the changes so that all the files were addressed properly and the site (http://gtvrc.shermanlaws.com) works. The problem is that despite my user_capabilities (a:1:{s:13:”administrator”;b:1;}) I cannot edit the existing pages on the site. And when I create a new page, I am not allowed to publish it, only Submit for Review. So somewhere I have lost my admin privileges and after spending days trying to fix it, I’m stuck. I even downgraded to 2.71 (which is the version running now) on the assumption that this was some anomaly with 2.84.

I can’t create new users either and I tried various plugins to edit roles none of which worked.

Any assistance/advice would be very much appreciated. 😉

Cheers,

Robin.

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

esmi
(@esmi)

16 years, 9 months ago

Do you have any plugins running? Have to tried deactivating them all? Or resetting the plugins folder by FTP or phpMyAdmin? Sometimes, an apparently inactive plugin can still cause problems.

You could also try switching to the default theme to rule out any theme-related problems.

Brance
(@brance)

16 years, 8 months ago

I’m having this same trouble.

I tried switching to the default theme, and deactivating all plugins. nothing worked.

I can do everything else I need to do, but with Pages, all I can do is “submit for Review”

Any answers?????

kperrone
(@kperrone)

16 years, 8 months ago

I can’t create new users either and I tried various plugins to edit roles none of which worked.

Did you try creating them via phpmyadmin instead of the WP interface?

Brance
(@brance)

16 years, 8 months ago

I got it fixed, here’s how.

I logged in to phpmyadmin on a working instal of WP 2.8.4
went to the wp_options table
found the option with option_name = wp_user_roles
opened that record and copied the option_value field

then went to the database for my fouled instal (still in phpmyadmin)
went to the wp_options table
found the option with option_name = wp_user_roles
opened that record and pasted into the option_value field what I had copied from the other database

The only thing I had to do after that was login to the faulty WP install as the admin
turn off all the plugins
turn them back on

That gets all the plugin settings pages working properly.

And it’s all good now. I can edit/publish pages again!

amomandherblog
(@amomandherblog)

15 years, 11 months ago

I’m helping a friend with a very similar problem. I tried this solution (along with some others I’ve found on here), but now I’m having a problem with PhpMyAdmin. Everything I do on there comes up with an error, access denied. I searched that one, and came up with a couple of different things that could be causing it. The one that is NOT causing it is the database being full, there appears to be plenty of room. It’s more like the privileges are not set correctly. The site is hosted through Network Solutions, I called them to find out how to set the privileges via PhpMyAdmin, and got a wonderful person who told me he didn’t know how. I am currently waiting for a supervisor to call me back. Any ideas?

donpaolo
(@donpaolo)

15 years, 10 months ago

I have the same problem.

I autoupgraded to 3.0 it_IT a wordpress installation on a windows server, and I can’t publish any more. I tried deactivating the plugins -> nothing.

I have another wordpress installation on a linux server, I autoupgraded it to 3.0, and on that server all is ok.

Help for the windows installation needed!!!