Bug in page of comments

Hi,

I have found a bug in WordPress 2.9.2. A broken function to created a link to a comment about several pages of comments.

If you are on the page of /wp-admin/options-discussion.php and set it up for page breaks after every, e.g., 50th comment.

On the page of dashboard (recent comments) or edit comments you can click on “#”-Link. But it shows wrong url of comment page. The calculation of page from comments is wrong. But the permanent-link in the frontend of wordpress works clearly.

I go to the source code /wp-includes/comment.php into the function get_page_of_comment() (near line 647).
There are a database query:

$oldercoms = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_parent = 0 AND comment_approved = ‘1’ AND comment_date_gmt < ‘%s'” . $comtypewhere, $comment->comment_post_ID, $comment->comment_date_gmt ) );

If I remove in the sql-query “comment_parent = 0 AND”, so it works perfectly for me. But it has got many other problems with calculation of page about comments in the backend of wordpress:

@the developer of wordpress:
These options must consider the calculation of page comments:
– get_option(thread_comments)
– get_option(thread_comments_depth)
– get_option(page_comments)
– get_option(comments_per_page)
– get_option(default_comments_page)
– get_option(comment_order)

I hope, the issues will be fixed soon.

Regards,

Freespacer