Duplicate content in Views [#582206]

I have stumbled upon a major issue which is definitely due to Content Access. I went as far as deactivating all contrib modules, activating them one by one, testing, etc, all of this twice and in reverse.

What happens is that when I build a display using Views with a simple filter (say, Node Type), I get the same node displayed for each role that a user has. If a user has 3 roles (and each of them can view that node type), then the node will be displayed 3 times in the list (this happens in any Views display style : fields, table, node...)

Some more information : the site is set up with several roles (e.g. group1, group2, group3, group4), but a user can belong to one or more of these groups. If, in a node type Access Control tab, I select group1, 2 & 3 under View Any Content, a member who belongs to all of the above 3 groups will see the content three times in a Views display (whether Views Access Restriction is on or not). If I deselect one of the roles in the Access Control tab, the same user will see the content twice.

I hope I've described the problem clearly enough. Is there something I'm not doing correctly or is this a bug?

Thanks.

Comments

Comment #1

Junro commented 19 September 2009 at 18:40

I just have this issue updating Drupal 6.14 from 6.13. Did you update Drupal 6.14 too?

Comment #2

talino commented 19 September 2009 at 18:46

Indeed I have. I temporarily solved this by checking "Distinct" in all relevant Views Displays, but I would really like to know why Content Access does this, because I don't think it should :)

Comment #3

Junro commented 19 September 2009 at 19:02

Your theory about roles doesn't exactly apply with me. Some nodes are displayed 1, 2, 3 or 4 times.
ex 4 3 4 3 2 1 4 3.

But you're right, I don't have the same duplicate display with user not having the same number of roles.

Comment #4

Junro commented 19 September 2009 at 19:04

Checking "Distinct" is deffinitly not a solution as you said. Very critical issue...

Comment #5

Junro commented 19 September 2009 at 19:09

This is not a Content Access issue, I don't have this module on my configuration.

Comment #6

Junro commented 19 September 2009 at 19:29

Project:	Content Access	» Drupal core
Version:	6.x-1.2	» 6.14
Component:	Code	» database system
Status:	Active	» Closed (duplicate)

here the issue #579892: Authors and only authors see duplicate items after upgrading Drupal to 6.14 in views issue

Here the right issue in Drupal issue: #284392: db_rewrite_sql causing issues with DISTINCT

Comment #7

talino commented 19 September 2009 at 19:58

@Junro : The Views issue (http://drupal.org/node/579892) does seem related to this one (and I just posted there also), but I'd still like to point out that I checked and unchecked *every* contrib module on the site and only when Content Access was activated did the issue appear.

Comment #8

Junro commented 19 September 2009 at 20:14

All we have to do is to wait the next Drupal core release with the bug fixe.

Meanwhile, I have reinstalled 6.13 (the bug disappears)

Comment #9

talino commented 19 September 2009 at 20:19

I'm not skilled enough to say whether this is a Drupal or Content Access issue. For the time being I'll stick to 6.14 simply because switching versions is such a hassle, especially since I have an essential patch applied (http://drupal.org/node/181003#comment-2015258) and that using DISTINCT works for now.

I would have happily stayed with 6.13 if I didn't get red warnings all over the place.

Comment #10

seddonym commented 16 October 2009 at 14:07

I've experienced a similar problem with Domain Access. Just installed 6.x-2.0-rc9 on Drupal 6.14, and for certain roles (less privileged ones?) the nodes are appearing twice in views. Also got two domains set up, I don't imagine that's a coincidence. DISTINCT fixed it for now.