Support » Fixing WordPress » Screen Options in page "Posts". Too high "number of posts"…

  • Resolved astalidis

    (@astalidis)


    Hi,

    In the Number of posts to be shown in “Posts” page (under “Screen Options”), I have put a ridiculously big number (999) and now I can’t see the page at all due to Fatal Error and Memory exhausted.

    Does anobody know where is this specific setting saved, so that I can change it manually?

    I suppose it must be saved either in a file or in the database. Please, be specific.

    Many thanks.

    Andreas.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Bill

    (@chubbycrow)

    Check the database table wp_options and find the option name posts_per_page.

    kmessinger

    (@kmessinger)

    You log in here http://www.korshjafarniamd.com/wp-admin

    Does that not work for you?

    Thread Starter astalidis

    (@astalidis)

    Thanks, but this is something different. Maybe I wasn’t very clear. The posts_per_page in wp_options gives the number of posts when the user selects a category of the wordpress.

    My question is for the admin page. When I select “All Posts” in the admin page, there is a “Screen Options” at the top. One option there is the number of posts to appear in the “All Posts”. This is what I am looking for. Specifically, this page: …/wp-admin/edit.php

    kmessinger

    (@kmessinger)

    And you can’t go to that page and enter a new number?

    Thread Starter astalidis

    (@astalidis)

    I was on that page …/wp-admin/edit.php,
    I clicked on Screen Options and I wanted to buld edit many posts, so I put 999 as the number of posts to appear on this page.

    When it tried to update the page, it couldn’t do it because of memory problems.

    This is the error message:

    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1048576 bytes) in /……/wordpress/wp-includes/wp-db.php on line 1981

    I think that the number of 999 posts is too high to be processed, so I am looking for alternative ways to change it back to a normal, smaller number.

    Now, the page ../wp-admin/edit.php doesn’t load at all, giving the above error message.

    Thread Starter astalidis

    (@astalidis)

    The only thing I ‘ve found out was that it is not related to files of the theme.

    I changed the theme, tried again, and still didn’t work.

    Also, I tried searching in the database for the term “999” and didn’t find much there either.

    So, the setting must be saved in one of the files. But which one?

    Bill

    (@chubbycrow)

    OK, I misread your original post. Look in the wp_usermeta table for your user ID and find the option-name edit_post_per_page. I think that’s what you’re looking for.

    Thread Starter astalidis

    (@astalidis)

    Perfect! Many thanks!

    Basically, wp_usermeta had too many entries, so I searched the term edit_post_per_page in the database, found it, and fixed it.

    Bill

    (@chubbycrow)

    Great. Glad you got it worked out.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Screen Options in page "Posts". Too high "number of posts"…’ is closed to new replies.