"Calendar Page" Data Stops Showing After Certain Date [#731492]

As you can see here ( http://www.parentworld.com/?q=calendar/2010-03-14 ) and in prior dates of the same month, the calendar Body and Date Field data appear, but here ( http://www.parentworld.com/?q=calendar/2010-03-15 ) and afterward, no data appears - not even the date field.

My Calendar Day nodes (system name is "event"), which appear fine as custom views and standalone nodes, are created using the Title, Calendar Date (system name "field_eventdate"), and Body field. All these nodes are uniform in parameters not concerning Title, Date, and Body text, so I don't know how it would distinguish between the two - or rather why it would show all the dates leading up to the 14th, and not any after.

The attached images show the Calendar Pages configuration and the details of the Date argument (minus the Title, Breadcrumb, and Method fields. Method is set to OR.)

Help is MUCHO APPRECIADO!!!!

Comment	File	Size	Author
	Picture 3.png	144.19 KB	g10tto
	Picture 2.png	134.24 KB	g10tto

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

g10tto CreditAttribution: g10tto commented 3 March 2010 at 16:37

My company has reproduced this layout in Drupal for two other magazines, and I have found that they are having the same exact issue!

I put the site together for the first time back in August or October of last year, when I can't recall having the issue, so I'm guessing that an update to either the Date module or Calendar module is to blame.

I have found other issues LIKE this, where calendar page views appear blank, but nothing matching mine where only certain dates in a range are missing.

Comment #2

g10tto CreditAttribution: g10tto commented 3 March 2010 at 16:52

This is the SQL Query pasted from the Preview:

SELECT node.nid AS nid,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
node_data_field_eventdate.field_eventdate_value AS node_data_field_eventdate_field_eventdate_value,
node.type AS node_type,
node.vid AS node_vid,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_event node_data_field_eventdate ON node.vid = node_data_field_eventdate.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE ((node.status <> 0) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(node_data_field_eventdate.field_eventdate_value, SEC_TO_TIME(-21600)), '%Y-%m') <= '2010-03' AND DATE_FORMAT(ADDTIME(node_data_field_eventdate.field_eventdate_value, SEC_TO_TIME(-21600)), '%Y-%m') >= '2010-03'))
ORDER BY node_changed ASC, node_data_field_eventdate_field_eventdate_value ASC

Comment #3

g10tto CreditAttribution: g10tto commented 3 March 2010 at 17:45

Found out this was the same issue as http://drupal.org/node/447728

To fix, I went in to edit the Content Type "event", then the Datefield, and turned off Timezone handling by selecting "No Timezone handling" at the bottom of the field edit screen.

It's only a workaround, but my events are all appearing, so it works. Whee!