Nodes showing up twice on views

Try the Node: Distinct filter.

Ahh, you're having a problem with the core db_rewrite_sql working with the taxonomy query causing duplicates. There's no fix for this, that I've been able to find. The best I can suggest is that you should make sure to set the depth option to 0; if you're already doing that, you're going to have to find another solution to whichever field/sort/filter is causing the duplicates. Sorry.

It's usually taxonomy with depth.

It sounds like there's something in 5.7 that's adding stuff to the query in the node_db_rewrite_sql which is handling access control -- which is why you don't see the problem for users with administer nodes access.

I'm not actually sure what changed there that might be causing this. :/

Hi there, I am having the same problem. I'm simply trying to create a taxonomy index (view that displays a list of taxonomy terms), but each term appears multiple times in the listing. I have tried using the node distinct, but still had the same results. I am using Drupal 5.7, but I don't have views fast search or views fusion.

Please advise me on what I should do. Does this happen with any one else, or is this just an edge case?

I can post my view if you would like.

Thanks for the help.

hi all,

i was also facing the same problem. i added the filter node: distinct and put it on top of other filters. it worked and everything is fine now.

i thought this may be helpful for other users so posted here.

This happens to me on taxonomy_directory view as well.

I'm experiencing the exact same problem and I'm not even using taxonomy. Ive tried clearing the cache tables with no luck. I've noticed that It's always the same nodes that show in the table twice, even if I sort the table by something other than name the same nodes always show up twice. Does anyone have a suggestion on how to fix?

I set this won't fix because I can't fix it.

You desperately wanting me to will NOT CHANGE THAT FACT, it will only waste my time.

I had the same problem and Node District fixed it.

One thing to note, when I set node district and saved the view, I got an error saying that node district must have a value. I simple clicked save again and it saved without any problem and worked like a treat.

ps, my problem was caused by nodes having multiple terms

The "node distinct" solution definitely seems to be hit or miss here. It won't solve the problem with mine.

The views I had created under 5.0/5.2 seem to work fine. But new Views and modified views show this problem.

Has anyone checked 5.8 to see if that fixes it?

Some more light on this from my experience, FWIW. I think this explains why my "node: distinct" didn't work.

SELECT DISTINCT(node.nid), comments.timestamp AS comments_timestamp_timestamp FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN comments comments ON node.nid = comments.nid WHERE (node.status = '1') AND (term_node.tid = '127') GROUP BY node.nid, comments_timestamp_timestamp ORDER BY comments_timestamp_timestamp DESC LIMIT 0, 15

This is the mis-constructed query ( I guess by db_rewrite_sql ). The node.nid is distinct but if you have

SELECT DISTINCT(node.nid), comments.timestamp

you will get multiple nids from Mysql because the second term (comment) has multiple entries. But the only reason the comments is even here is because I had it in my "sort" portion at the bottom. So, it seems to me if you just don't SORT (and probably make no other reference) to multi-select CCK fields you should be OK with just node:distinct.

This worked for me. I just sorted on node created time, rather than comment time.

Still the same problem in Drupal 5.8.

I have the same issue with both nodes and 'who's online' users appearing twice in views. It looks as though it is affecting users added after the upgrade to 5.7.

I've got this same problem with 5.10, and I'm not using taxonomy terms in my view.

Marking as duplicate of #140061: Node Distinct is not working anymore

Ok, I think I *might* have found a solution.

If Node: Distinct is the FIRST filter in the filter option, and sort: criteria is set to random, I am not showing any repeats of nodes, regardless of taxonomy tags. So far so good... I'll post this in the duplicate forum as well.

Thank you corona ronin, this is working for me.
As info. for the ones with the same issue: If this is a problem with Drupal core it is not fixed until 5.12

still repeated nodes, even with "Node: Distinct is the FIRST filter in the filter option, and sort: criteria is set to random"

I faced the same problem in my V6.x installation. But setting Distinct=Yes in view: taxonomy_term fixed it> i didn't have a clue how to fix this, but this discussion gave me the leads. thanks

I had Duplicate events appearing in my calender view. I was able to fix this by clicking on "Date: Date (node)" in arguments. It turned out that I had two date fields selected (From date & To date). By checking only one field (From date), the duplicate views disappeared from the calendar.

Hope this helps.

#29 fixed the issue for me, thanks!

I have installed the Node Access Node Reference module, which might have caused the access right system to get confused, I now have duplicates in certain views.
EDIT: I updated Views to 6.x-2.8 (2009-12-03) which fixed the problem for me.

I had the same problem. I had several taxonomies on one node. For example one organization is a clinic and a diagnostic center at the same time. I used the option "Reduce Duplicates" option in the filter criteria. Now everything is fine.

I had the same problem. I had several taxonomies on one node. For example one organization is a clinic and a diagnostic center at the same time. I used the option "Reduce Duplicates" option in the filter criteria. Now everything is fine.

It was happening to me even on Drupal7.21. Whenever I edited a node that was in the view it started to appear twice. Interestingly, what fixed it for me was the setting "Force using fields" (this is under Format->Unformatted List->Settings). When this setting was unchecked the duplicate disappeared.