WordPress.org

Forums

[1.5] Manage comments only shows partial list (5 posts)

  1. philpeeps
    Member
    Posted 10 years ago #

    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?

  2. oriecat
    Member
    Posted 10 years ago #

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

  3. philpeeps
    Member
    Posted 10 years ago #

    bump

  4. philpeeps
    Member
    Posted 10 years ago #

    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?

  5. starritt
    Member
    Posted 10 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.