Entries doubled in block?
gabble - November 10, 2007 - 07:45
| Project: | Live Discussion |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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… :-)
| Attachment | Size |
|---|---|
| Live Discussion Block with doubled entries | 32.71 KB |
#1
Doesn't matter, I have removed Live Discussions from my website and created a view with the Views Module.
Much better… :-)
Thanks anyway,
Gabriele
#2
i 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.
#3
in 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.