display all posts in wordpress admin crashing after 999 screen option

by

I decided to change the option on wordpress > posts > screen options > show posts to 999.

now the page crashes when i open it .

it loads for a little bit and then it crashes. how can i undo the changes . please help.

4 Answers
4

That option is held in the wp_usermeta table with the edit_posts_per_page meta key.

Using PhpMyAdmin (or straight up MySQL) you can make that change for your specific user.

User Meta to change

Some notes of caution:

  1. Depending on the number of users on your website, there will likely be more than one edit_posts_per_page meta key available. Make sure you change the one that corresponds to the correct user ID.
  2. DO NOT CHANGE umeta_id, user_id, or meta_key. BAD THINGS COULD HAPPEN.

It probably goes without saying, but wherever possible options should be changed via the WordPress interface with a fall back of editing the database directly in cases like yours where WordPress (really it’s the server memory) just can’t handle the load 😉

Leave a Comment