WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. philpeeps
    Member
    Posted 9 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 9 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 9 years ago #

    bump

  4. philpeeps
    Member
    Posted 9 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 9 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.