admin管理员组

文章数量:1122832

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.

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.

Share Improve this question asked Apr 7, 2017 at 17:58 Mike HanMike Han 112 bronze badges
Add a comment  | 

5 Answers 5

Reset to default 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.

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 ;)

I'm on the same problem and I can't find the meta_key edit_posts_per_page on wp_usermeta table.

The problem happens when I try to see Products on Woocommerce.

Edit:

I found the solution myself, for Woocommerce Products:

  • table, 'wp_usermeta'
  • meta_key, 'edit_product_per_page'
  • meta_value, change to '20'

If it still doesn't work maybe you will need to clear all caches TOO.

If you have access to your phpMyAdmin panel, you can easily reset this manually inside your database.

[edit] as pointed out by Jack Johansson, I did not read the question carefully—my earlier value was incorrect.

I'm not sure if this has been updated since or is this is based on a different configuration or hook, but for me the meta_key value to change is edit_post_per_page

In my website, I found it as upload_per_page. I changed the value from 999 to 20 and the page started loading properly on my wp-admin.

本文标签: display all posts in wordpress admin crashing after 999 screen option