• philpeeps

    (@philpeeps)


    I have 43 comments on my site, but only 20 of them are available in the admin manage comments section…

    How do I access the rest of them in the admin interface?

Viewing 4 replies - 1 through 4 (of 4 total)
  • oriecat

    (@oriecat)

    That’s a really good question, I just looked again and there’s no next page or earlier comments link or anything.

    Thread Starter philpeeps

    (@philpeeps)

    bump

    Thread Starter philpeeps

    (@philpeeps)

    on line 70 of wp-admin/edit-comments.php delete teh following code

    $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = "0" OR comment_approved = "1" ORDER BY comment_date DESC LIMIT $offset,20");

    and replace with

    $numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = "1"");
    if (0 < $numcomms) $numcomms = number_format($numcomms);

    $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = "0" OR comment_approved = "1" ORDER BY comment_date DESC LIMIT $offset,$numcomms");

    This, however, does not page the comments, so if you ahve a huge comments table, you might try other means….

    DEVELOPERS…is there another way to access previous commetns other than the previous 20 or to page the results?

    starritt

    (@starritt)

    You can search for them however it’d still be nice to have a big list.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[1.5] Manage comments only shows partial list’ is closed to new replies.