All Posts view kills dashboard

  • Resolved bretweir

    (@bretweir)


    11 years, 5 months ago

    Hi folks –

    Here’s what I did – changed the number of posts that display per page in the All Posts view in the dashboard from 50 to 999 (to get all posts to be listed so I can do a bulk edit)….. The resultant list (800+ posts) never displayed… my browser waited for more than 15 minutes before I forced an exit.

    Now – I have to have a clean login to the dashboard to post – and I can’t try to access the post listing or it locks up my dashboard access again.

    I’m not totally versed in database issues – so I am not going to tinker too much without guidance, so I don’t break it worse. I did log into my hosting cPanel and do a “check” and “repair” on the database … returned no errors.

    URL is https://www.marleysmutts.com … theme is ThemeForest’s “Continuum”

    Any guidance is most appreciated. I searched the posts here and either I’m not using the right search string, or I’ve created a unique problem (most likely the former).

    Thanks in advance.

    …forgot to add – If I try to access posts (or anything thereafter)…. after a while, it now returns “MySQL server has gone away”…

    sorta sad return. ??

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

  • Well, that was a bit daft of you. ??

    Using Phpmyadmin (or another MySQL management tool), first backup your database. Then navigate to your wp_options table and locate the option_name called “posts_per_page“. Change the option_value for this record to something more reasonable – like 10.

    Actually – scratch that. This will only affect the front end of the site. Thinking…

    Try deleting all of your WordPress cookies.

    Thread Starter bretweir

    (@bretweir)

    Haha – yeah… totally bonehead move… but nevertheless.

    I tried the cache – no joy. same result.

    Thread Starter bretweir

    (@bretweir)

    No joy on the cache – same result

    Try putting this in your functions.php

    function admin_pagination(){
        global $wp_query;
        $per_page = 5;
        $wp_query->query('showposts='. $per_page);
}
add_action('admin_head', 'admin_pagination');

    Found in this post

    Thread Starter bretweir

    (@bretweir)

    Thank you WPRanger! That worked like a charm.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘All Posts view kills dashboard’ is closed to new replies.