Hello, when i updated from 6.13 to 6.14, all views had duplicate entries (show each row twice) for only one user that i have.

I have 3 users on my website (superuser, administrator and client) and the duplicate entries happens only on the administrator user.

I will try to find more informations.

Comments

sinasquax’s picture

sinasquax commented

The file that causes the problem is database.mysql.inc (or database.mysqli.inc if using mysqli), it's because DISTINCT is no more added to some SQL.

I don't know why this cause duplicate entries for some users only, maybe because of nodeaccess.

damien tournoud’s picture

damien tournoud commented
Status: Active » Closed (duplicate)

Please see #284392: db_rewrite_sql causing issues with DISTINCT.

sinasquax’s picture

sinasquax commented
Status: Closed (duplicate) » Active

It's a bug of nodeaccess, if you authorize authentificated user and node author to view a content type and if authentificated user is node author, you will get the data loaded twice.

Because of old behavior of drupal, this bug was hidden.

sinasquax’s picture

sinasquax commented
Project: Drupal core » Node Access
Version: 6.14 » 6.x-1.3
Component: base system » Code
bryrock’s picture

bryrock commented

subscribe

migas’s picture

migas commented

subscribe, same problem

askibinski’s picture

askibinski commented

this patch fixed it for me
http://drupal.org/node/284392#comment-2068766

talino’s picture

talino commented

This is not a Node Access issue, it has to do with Drupal core (I though it was a Content Access issue when I upgraded to 6.14, turns out it's a different problem). Relevant thread is here : http://drupal.org/node/579892

emptyvoid’s picture

emptyvoid commented
Status: Active » Closed (won't fix)