By mhm on

When I set up this view, this was not happening. I tweaked some things awhile back, and I must have accidentally screwed something up. Now, everything shows up on the calendar view twice (but does not exist twice). See http://www.azmuseums.org/calendar

I think the problem may be the views for Month/Week/Day, etc. are also set as "attached to" the page in question. I haven't removed them, because it stands to reason that if that was it, wouldn't they be showing 3-4 times?

Help?

⋅ Categories: Drupal 6.x

Comments

SweeneyTodd’s picture

SweeneyTodd commented

Are you passing any additional arguments?

I had a problem recently where I passed a taxonomy term to a view and I got items appearing twice because the same term name was in 2 different vocabularies on some nodes.

As a "quick and dirty" fix, there is a setting in the View Basic Settings area called Distinct. If you set this to "Yes" it should remove duplicate entries. This will add a bit of time to how long the query runs and will only hide the problem - it will not sort out the underlying issue.

mhm’s picture

mhm commented

Thanks for the ideas. It's definitely not a taxonomy issue, and the "Distinct" setting didn't even hide the problem.

The weird thing is my changes don't seem to be doing anything. One thing I've considered adding is the city (since this covers state-wide events), so I gave that a shot -- nothing in the display changes, even after clearing the cache. Something is seriously amiss.

The query is 

 SELECT DISTINCT(node.nid) AS nid,
   node.title AS node_title,
   location.city AS location_city,
   node.type AS node_type
 FROM node node 
 LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
 LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
 LEFT JOIN location location ON location_instance.lid = location.lid
 WHERE ((node.status <> 0) AND (node.type in ('event')))
    AND ((DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), 'UTC', 'America/Phoenix'), '%Y-%m') <= '2010-10' AND DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), 'UTC', 'America/Phoenix'), '%Y-%m') >= '2010-10'))
 GROUP BY nid