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

skylord’s picture

skylord commented

+1
The last patch for this bug is here: http://drupal.org/node/681760#comment-4371188

rurri’s picture

rurri commented

I 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

lightsurge’s picture

lightsurge commented

I 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.