Warren

Hi Guys,

I just experienced the same problem and managed to fix it successfully. It seemed the database on my clients site had bloated to 123mb, which is probably too close to the default limit set in wp-config.php

This is what I did :
1) Increased the memory limit in wp-config.php (in your site root/base) to 228mb by changing

define(‘WP_MEMORY_LIMIT’, ‘128M’);
to
define(‘WP_MEMORY_LIMIT’, ‘228M’);

2) Then go back to http://www.yoursite.com/wp-admin/ and click update, it should take a little longer this time and then eventually take you to http://www.yoursite.com/wp-login.php where you should now be able to login as normal.

3) To stop this happening again next time, you will need to clear out your post “Revisions” to reduce the size of your database. To do this login to phpmyadmin and run the following SQL query DELETE FROM wp_posts WHERE post_type = “revision”; which should take less than a few seconds to run.

Note: Don’t forget to backup your database before and after you run this query. My first backup was 123mb, the second was 29mb!! So quite a saving hey.

4) Now FTP into your site and go to :
wp-includes/default-constants.php
Go to line 279 and change :
define(‘WP_POST_REVISIONS’, true);
to
define(‘WP_POST_REVISIONS’, 3);

Note: You could choose a higher number of revisions if you like but I really think 3 is enough.

5) Finally go back to wp-config.php and drop WP_MEMORY_LIMIT back down to 128mb

My site works again perfectly!

Hope this helps!
Cheers
Warren

Twenty Eleven Main Menu Problem Now Fixed thanks to bpmildh

Thanks bpmildh, you’re a star 🙂

Joshua thanks very much mate, I just followed the two steps and it worked Great!

My menu problem in Mystiqie 2.4.2 with WordPress 3.1.1 is now fixed and working perfectly 🙂

Cheers
Warren

Hi unseenmortal,

did you figure this out?

I’m having the same problem!

Thanks
W