I'm having problems with my tracker not displaying the comment count correctly. For reference, I have been rebuilding my website due to corrupted tables at who knows where. http://drupal.org/node/323254 is that thread.

My tracker displays everything correctly except comment count, which it displays for everything as 1.0037 instead of the correct number (0, 1, 2, 3, etc). I copied the tracker view and made a similar view: recentForumPosts just for displaying recent forum posts. The query is:
SELECT node.nid AS nid,
node.type AS node_type,
node.title AS node_title,
users.name AS users_name,
users.uid AS users_uid,
node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
history_user.timestamp AS history_user_timestamp,
history_user.nid AS history_user_nid,
node.created AS node_created,
node.changed AS node_changed
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = ***CURRENT_USER***
WHERE (node.status <> 0) AND (term_data.vid in ('1'))
ORDER BY node_comment_statistics_last_comment_timestamp DESC

I looked at the table / values in node_comment_statistics.comment_count and they are integers, and look correct. Why is it displaying 1.0037? How do I fix this problem?

Thanks in advance.

Comments

Wolfflow’s picture

I got exactly the same Issue of yours. Still trying to find out what can have cause this.
I just did upgrade my view.module to the newest release: 6.x-2.0 - 2008-Oct-18

Signature:

If you look at word and nouns you do not clearly understand
take a look at Common Terminology
if is missing feel free to post a comment - ;-)

Contact me for drupal projects in English, German, Italian, Drupal Hosting Support.

ryooki’s picture

bumping in case anyone knows about this