Sometimes when people are logged into our site editing content and what not, some views pages show up with double entries. This only happens when certain people are logged in and I don't know why. When Person X logs in and looks at our event page, the listing of events is doubled. When the super user admin person is logged in, nothing weird happens, everything looks normal. I have cleared my cache, re started the server, everything. I have no idea how to diagnose this other than to say it happens only on views pages....

Any help?

http://www.wimaxforum.org/events and http://www.wimaxforum.org/resources/documents/marketing/whitepapers and pages I am noticing this on. I have attached screenshots.
I kind of wonder if it is a caching problem but I have cleared my cache over and over with no luck.
Becky

CommentFileSizeAuthor
Screen shot 2010-01-05 at 2.03.01 PM.png58.4 KBbeckyjohnson
Screen shot 2010-01-05 at 2.03.17 PM.png61.74 KBbeckyjohnson

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (duplicate)

If you're using Drupal 6.14 and a node_access related module, then this is a duplicate of the core bug where DISTINCT is being lost with db_rewrite_sql. Try setting the DISTINCT setting on the view to restore it. It's a sloppy workaround but should do it.

beckyjohnson’s picture

beckyjohnson commented

I am using Drupal 6.15 but I will try this fix anyway.

Becky

beckyjohnson’s picture

beckyjohnson commented

Ok that seemed to do the trick. Thanks.