White Screen after changing screen options to show 999 posts

  • Resolved aitchison21

    (@aitchison21)


    9 years, 8 months ago

    Hi

    I was trying to bulk edit all my posts and changed the Screen Options to show 999 posts instead of 50, now I am getting the white screen, which I presume means there’s a database error of some kind.

    How can I change the screen options back to 50 in the backend?

    I looked in the post.php file in wp-admin, but couldn’t find anything there.

    Any help much appreciated.

    Steve

Viewing 2 replies - 1 through 2 (of 2 total)
  • Dave Naylor

    (@wpranger)

    9 years, 8 months ago

    If you have access to phpmyadmin, select the wp_usermeta table and then find your user ID within it. You’ll see a meta_key of edit_post_per_page with a meta_value of 999. Edit to show a lower number such as the default 20.

    If your hosts have wp-cli installed it’s even easier. In the terminal inside your WordPress installation, type the command:

    wp user meta update <your user ID> edit_post_per_page <your desired lower number>

    Thread Starter aitchison21

    (@aitchison21)

    9 years, 8 months ago

    Hi Dave

    You’re a star. I managed to get it sorted using your guide.

    Cheers buddy

    Steve

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘White Screen after changing screen options to show 999 posts’ is closed to new replies.