Support » Fixing WordPress » [1.5] Manage comments only shows partial list

  • 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)
  • That’s a really good question, I just looked again and there’s no next page or earlier comments link or anything.

    bump

    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?

    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.