display all posts in wordpress admin crashing after 999 screen option

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 😉

Related Posts:

  1. how to update serialized options programatically?
  2. What’s the difference between Options & Settings?
  3. Why does WordPress use serialize rather than json_encode for the options table? [duplicate]
  4. Plugin options will not save in database
  5. No option to allow search engines to index my site in WP 4.3
  6. How to update an ‘array’ option using wp-cli [duplicate]
  7. How to Create a Custom WordPress Install Package?
  8. Confirmation before deleting plugin options via uninstall.php
  9. Set WordPress settings programmatically
  10. Submenu pages delete settings from options array when saved
  11. get_option() from another wordpress site
  12. How can I get all user options?
  13. register_setting() vs add_option()
  14. Settings API – save an array of options as one setting (array_push?)
  15. Where to hook register_settings for Settings API when also want to update options outside of Settings API?
  16. How much string content can I store in an option?
  17. Save Theme Options (options.php) From The Frontend
  18. Can’t output do_settings_sections . Can’t understand why
  19. checkbox with get_option not working
  20. Single callback with multiple setting fields
  21. Any way to partition wp_options?
  22. How do I add a value to a wp_options option that is an array?
  23. how can I detect that option value has changed?
  24. Can I use a space in an option name/key?
  25. How to display some settings for super admin user only using Settings API
  26. Is there a limit to the number of options you can store in one settings field of wp_options?
  27. wp_user_roles and Advanced Manipulation
  28. Settings API get_option best practices
  29. Deploy pre-configured database
  30. Tab from Settings API resetting all options with INSERT INTO [closed]
  31. Getting settings saved two times in settings page with tab
  32. Can’t save options
  33. Putting my site live
  34. Where is the submitted $_POST array stored after an option page submission?
  35. get_option array value defaults and best practices
  36. Add an option to a Child theme of Twenty Eleven
  37. The Settings API – What is the purpose of default value in register_setting?
  38. WordPress options page not saving
  39. How to store a value on WP_option table
  40. Two settings_fields in one form
  41. Custom blog settings
  42. Implementing action correctly
  43. wp_usermeta wp_usersettings
  44. Can’t save checkbox option
  45. How to set wp_editor to be email friendly?
  46. options-general.php page displays different sitename, home compared to wp_options table
  47. Work flow for multiple developers
  48. i changed my wordpress address url in SETTINGS – GENRERAL – wordpress address site url. cannot login anymore
  49. Functions to edit wp-config.php [duplicate]
  50. Cannot save using register_setting
  51. Saving plugin options page
  52. Transients API conditional
  53. Testing for addon plugin activated
  54. update a value in wordpress wp_options
  55. Where have the Privacy Settings gone in WordPress 3.5?
  56. Is there any other place – besides a theme, a plugin, or a mu-plugin – that an option page might conceivably be used?
  57. How to save custom settings api fields with custom section fuction
  58. problem with get_option in dashboard
  59. Custom options in plugin, register_settings not working as no options.php?
  60. Google fonts dropdown in Options Framework
  61. How can I increase the font sizes used by the WordPress visual and HTML post editors?
  62. How do I retrieve multiple values from a multidimensional array in wp_options?
  63. Which Hook can I use when creating unique post but not update/save/delete
  64. Updating just one option with update_option
  65. Upload file on pre_update_option_{option_name}
  66. How to use update_option() without replacing/losing the old value?
  67. how create an html table with all values from a serialized array in option_value
  68. Settings API and ‘type’ => ‘font’
  69. Accept code input into Options Framework
  70. WordPress Settings API settings not saving for some users
  71. Character \ appearing before ‘ after saving a settings page
  72. How to add a Reset to Defaults button with Settings API?
  73. How can I clear memcached WordPress site options by hand?
  74. PHP class to add pages and fields in admin panel
  75. Autopopulate a value
  76. get_option() and update_option() in a transaction (for an autoincrement value)
  77. display category name based on its equivalent id
  78. Save Plugin Options as Array
  79. Retrieve my custom settings in the settings/ API endpoint
  80. Multiple checkbox doesn’t work in wordpress settings api
  81. Move website from root to sub
  82. Is saving data to WordPress options as array bad thing to do?
  83. centralized alternative for get_option: get_site_option, get_network_option or get_site_meta?
  84. Editing a loaded WordPress option without updating the database
  85. add image in dropdown select
  86. User specific settings, limited by role
  87. Remove Edit Profile option but still have the profile viewable
  88. How do I create settings only used by my theme? [closed]
  89. Dynamically Update Key in Associative Array When Saving Settings
  90. Move one option value into another option
  91. Adding data to options table
  92. how can i add_option as array from a form with just a text input
  93. Incorporating the Settings API in WordPress Themes – by Chip Bennet
  94. WordPress options text format
  95. Caching of SQL queries
  96. $wpdb->update does not update, var_dump of data is correct
  97. Custom general settings (textarea field) don’t output HTML correctly
  98. Using get_option() for check box field
  99. Where to adjust presets for slider options “auto rotate” (3, 5, 10, 15 seconds)? [closed]
  100. change backend header options
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)