Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Not sure if this problem is mentioned already but I could not find it.
I did build some views as user 1 and was happy with the results. Great module, many thanks. then I logged in as normal user and noticed only even numbers. I have also been experimenting with Views_calc so I recognized the problem (#923748: Node access (db_rewrite_sql) causes double (n-times) results for everyone but uid=1) The fix mentioned by Karen in comment 3, also fixis this problem. (#comment-3155816)
For me the patch solved the problem.
Comments
Comment #1
skylord CreditAttribution: skylord commented+1
The last patch for this bug is here: http://drupal.org/node/681760#comment-4371188
Comment #2
rurri CreditAttribution: rurri commentedI had a similar issue where all results were quadrupled when user was not user 1. All my results had 4x as many. Luckily found this thread.
+1
This patch fixed my issue: http://drupal.org/node/681760#comment-4371188
Comment #3
lightsurge CreditAttribution: lightsurge commentedI had a similar issue... results doubled for users who hadn't authored a post - except user 1. Patch in http://drupal.org/node/681760#comment-4371188 worked but messed up all my views, so I added the distinct back in that the patch removes.