How to change 'number of items per page' for post display in back end

  • I made the error of changing the Posts / Screen Options for the ‘number of items per page’ to 999. Now, when I try to view Posts, the site times out.

    Can you tell me where to find this value and change it in the back end of the site, either the database table / field, or file / value?

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)

  • In wp_options table, seach by the key “posts_per_page” and it will retrieve the value associated with it which in your case is 999, change it, save the new value and you’re done, good luck!

    Thread Starter hleibac

    (@hleibac)

    Thanks for the quick response Motaz. When I run this query:

    SELECT *
    FROM wp_options
    WHERE option_name = “posts_per_page”

    it shows the option_value = 10, but I think it should be 999.

    Is there another place to check?

    It’s either this ,or hard coded in a template file, or a custom field related to the theme/plugin options you’re using, how exactly did you change this value?

    Thread Starter hleibac

    (@hleibac)

    I changed the value in the front end, online, by selecting the Screen Options and changing the Pagination = 999 (I think that was it; it was the value that controls the number of posts displayed per page).

    Maybe this is an issue with the theme…

    If this is a paid theme, the theme author is obligated to offer you support, if it’s a free one, the theme author would be your best option, I would have offered to take a look for you but that’s not allowed here.

    Thread Starter hleibac

    (@hleibac)

    I understand. Thank you for the help!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to change 'number of items per page' for post display in back end’ is closed to new replies.