>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #544706. --> Reported by: [Nick Robillard](https://www.drupal.org/user/176017) >>> <p>I ran into a problem with the Date module and then found a Date/Calendar shared problem that I think belongs in the Calendar issue queue rather than the Date queue (...where I posted this first).</p> <p><a href="http://drupal.org/node/385688">http://drupal.org/node/385688</a></p> <p>This Date issue patch - <a href="http://drupal.org/node/385688#comment-1839132">http://drupal.org/node/385688#comment-1839132</a> - solved the first half of the problem. Now for the second half of the problem.</p> <p>(After applying Noahb's patch...)</p> <p>The data still doesn't show up on the calendar. This is because in calendar.inc, function calendar_build_nodes() the $items array looks like this:</p> <pre>Array<br>(<br>&nbsp;&nbsp;&nbsp; [0] =&gt; stdClass Object<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [nid] =&gt; 12<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_node_data_field_content_reference_nid] =&gt; 11<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_fid] =&gt; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_list] =&gt; 1<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_data] =&gt; a:2:{s:3:"alt";s:0:"";s:5:"title";s:0:"";}<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_nid] =&gt; 12<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_type] =&gt; video<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_date_nid] =&gt; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_node_data_field_content_reference_node_data_field_show_date_field_show_date_value] =&gt; 2009-08-10T00:00:00<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [raw] =&gt; stdClass Object<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [nid] =&gt; 12<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_node_data_field_content_reference_nid] =&gt; 11<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_fid] =&gt; 5<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_list] =&gt; 1<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_field_show_thumb_data] =&gt; a:2:{s:3:"alt";s:0:"";s:5:"title";s:0:"";}<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_thumb_nid] =&gt; 12<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_type] =&gt; video<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_date_field_show_date_value] =&gt; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_date_nid] =&gt; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_node_data_field_content_reference_node_data_field_show_date_field_show_date_value] =&gt; 2009-08-10T00:00:00<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [unknown] =&gt; Click to explore<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...<br>)</pre><p>Notice that there is no "calendar_fields" object. </p> <p>This is <strong>suppose</strong> to be present in $items (when i manually add it, all is well):</p> <pre>[calendar_fields] =&gt; stdClass Object<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [node_data_field_show_date_field_show_date_value] =&gt; 2009-08-10T00:00:00<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</pre><p>The calendar_fields data <strong>is</strong> added when the Date field does <strong>not</strong> use a relationship. However in my case i <strong>need</strong> to use the relationship since my date data is coming from the related node.</p> <p>I've narrowed this down to theme.inc, function template_preprocess_calendar():</p> <pre>$calendar_fields = date_api_fields();<br>$calendar_fields = array_keys($calendar_fields['alias']);</pre><p>The problem is that date_api_fields() doesn't take into account the possibility of relationships and how that will change the field names.<br> IE: "node_data_field_show_date_field_show_date_value" will look like "node_node_data_field_content_reference_node_data_field_show_date_field_show_date_value" when a relationship is used.</p> <p><em>Here's my solution...</em><br> This is a HACK but it works. This checks view fields (with relationships) if the standard date field name exists within it, and if so, gives it the related field's value.</p> <p>On line 98 in theme.inc of <strong>2.0-rc6</strong>, I added:</p> <pre>// HACK: handle field names that use relationships.<br>if ($field-&gt;options['relationship'] !== 'none') {<br>&nbsp; foreach ($calendar_fields as $cfield) {<br>&nbsp;&nbsp;&nbsp; if (is_numeric(strpos($key, $cfield))) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $key = $cfield;<br>&nbsp;&nbsp;&nbsp; }<br>&nbsp; }<br>}</pre><p>I was going to make a patch against 2.2 but I see some code changes around where this snippet goes. I don't have time to test against 2.2 and figure a patch against 2.0-rc6 (that I'm using) would be useless for most. I've still included a patch against 2.0-rc6 as reference for anyone who wants to try this with a newer version.</p> <p><strong>NOTE:</strong> This patch will definitely <strong>fail</strong> against 2.2 and probably most versions besides rc6.</p> >>> [!note] Pre-migration files - [calendar\_relationship\_date\_hack.patch](https://www.drupal.org/files/issues/calendar_relationship_date_hack_0.patch) >>>