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.

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?

The first entry in database table “wp_users” is the log in of the administrator. The default is admin, but you could have chosen a different one.

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.

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