Active
Project:
Live Discussion
Version:
5.x-1.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Nov 2007 at 07:45 UTC
Updated:
21 Jan 2008 at 08:39 UTC
Some users see all entries doubled in the Live Discussion block. I am user #1 and I cannot duplicate the issue, I have also created myself a dummy regular user, but everything seems fine.
Unfortunately, many users reported the problem, and I don' t know how this could be traced and fixed.
Any suggestions?
PS: drupal 5.3, and a bunch of modules… :-)
| Comment | File | Size | Author |
|---|---|---|---|
| Live Discussion Block with doubled entries | 32.71 KB | gabble |
Comments
Comment #1
gabble commentedDoesn't matter, I have removed Live Discussions from my website and created a view with the Views Module.
Much better… :-)
Thanks anyway,
Gabriele
Comment #2
ruyakar commentedi have the same problem.
is there any solution other than removig live discussions module?
i saw that, users who has node administration permisions don't see doubled entries. but, normal authenticated users see all entries doubled in the block.
Comment #3
ruyakar commentedin live_discussions.module;
// create the SQL
$query = "SELECT DISTINCT cs.nid, n.title, cs.comment_count, cs.last_comment_timestamp
FROM {node_comment_statistics} cs
LEFT JOIN {node} n on n.nid = cs.nid
WHERE n.status = 1
$select_blog
ORDER BY cs.last_comment_timestamp DESC";
we should add "distinct" to the sql query.