Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.
  • WordPress 3.5.1
  • Web Host: Windows Azure Cloud
  • Database Host: Cleardb
  • Web Server: IIS 7.5

I've built a custom child theme that runs on the Genesis Framework and it has multiple custom post types and metaboxes. Multiple plugins installed on the site as well.

Since yesterday my admin user can no longer perform the following tasks:

  • Add new posts or pages (I can update existing ones). When I add a new page, I get a "Publish for Review" option only.
  • Update posts.
  • Enable / disable plugins (I get all the success messages like "Plugin activated successfully", but nothing seems to register on the db).
  • Activate / deactivate themes.

I read that one cause for this is the database being full, which results in losing admin privileges, but have checked and the database is not full.

I have access to the source code and have tried to manually install plugins like 'wp-optimize', or manually add another admin user but no luck. Nothing gets written to the database.

Does anyone have any other tips or suggestions on other things I can try?

Many thanks!

share|improve this question
1  
Well, as usual in these cases, check the articles debug and troubleshoot. –  brasofilo Mar 16 '13 at 22:21
    
Thanks brasofilo - have been checking those out. Meanwhile looking forward to any specific tips from users here on SE. –  IntricatePixels Mar 16 '13 at 22:25
    
If you could post some of the debugging info that brasofilo mentioned that might help. Otherwise, this looks very server specific, which makes it hard. –  s_ha_dum Mar 16 '13 at 22:48
    
WP_DEBUG and WP_DEBUG_DISPLAY always on but no errors. just turned WP_DEBUG_LOG on as well and will troubleshoot some more and come back here with any useful info, hopefully. –  IntricatePixels Mar 16 '13 at 23:12
    
Been doing some more debugging and now writing to the file and seeing: 17-Mar-2013 01:23:11 UTC] WordPress database error INSERT,UPDATE command denied to user 'my_db_user_name'@'168.62.52.141' for table 'wp_options' for query INSERT INTO wp_options –  IntricatePixels Mar 17 '13 at 1:48

1 Answer 1

up vote 0 down vote accepted

For anyone else running into a similar issue with Azure Cloud hosting and ClearDB ... read below (even though this is very specific to my site and db config):

Fixed the issue. This was a database specific issue with Azure and ClearDB and not pointing to the correct database. I was using a free version of the ClearDB MySQL (20MB, up to 4 connections). Upgraded to the next paid version (1GB, up to 16 connections), but even though I was pointing to the new database tables were the old ones.

For the free version, ClearDB removes admin privileges when you reach the 20MB limit (which I did). That's why I couldn't save, publish or do anything a regular admin can do.

Fixing the database tables and making sure the site is pointing to the upgraded one fixed my issue.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.