[drupal-devel] [bug] incorrect topics/replies count

[menesis]

Issue status update for http://drupal.org/node/19059

 Project:      Drupal
 Version:      4.5.2
 Component:    forum.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  menesis
 Updated by:   menesis
-Status:       active
+Status:       patch

I should have been more clear - this problem and patch is for
DRUPAL-4-5. In HEAD this is correct already.


menesis



Previous comments:
------------------------------------------------------------------------

March 17, 2005 - 17:09 : menesis

Attachment: http://drupal.org/files/issues/forum_fix_counts_with_node_access.patch (2.47 KB)

Similar problems with forum.module, when some node access module is
used, were already reported and fixed - see
http://drupal.org/node/11871
When using forum.module with taxonomy_access.module and multiple roles,
I've encountered two more places which need DISTINCT() in queries -
topic counts in forums listing, and new comments count in topic
listing. Here's a patch which fixes them.


------------------------------------------------------------------------

March 18, 2005 - 10:15 : Steven

This sounds like it needs to be fixed by calling db_rewrite_sql()
instead.