D7/C4 and the Default Events Calendar View

[Hershel]

Using the latest versions of all tools involved, the built in Events Calendar View not only generates errors for me, it also doesn't show my event. The SQL query is correct and when run manually, brings up one event, but I don't see it in the view.

Does anyone have this working? If so, can you provide tips? Precise versions of modules etc.

I also tried the dev versions of the Drupal modules, but no luck.

[Hershel]

Issue filed: http://issues.civicrm.org/jira/browse/CRM-8353

[jalama]

The issue is with the calendar module from Drupal.  I've got it partially working, ie items  but with new errors by replace line 592 of /sites/all/modules/calendar/calendar.module as below.  Can you test it and let me know?  If it works for you I'll post the patch to d.o

replace

Code: [Select]

$fields = date_views_fields($base_table[0]);
with

Code: [Select]

foreach ($view->date_info->date_fields as $key => $field_name) {
  $base_table = explode(".",$field_name);
  $fields = date_views_fields($base_table[0]); 
}

[Hershel]

That line in the latest dev Calendar release is:

Code: [Select]

  $fields = date_views_fields();
but anyhow your patch worked.

I still get:

Code: [Select]

Notice: Undefined index: exception in calendar_plugin_display_attachment->display_granularity()
(line 70 of /srv/http/xxx.com/sites/all/modules/calendar/includes/calendar_plugin_display_attachment.inc).
but it works anyhow.

[mc625569]

Same issue as Hershel when fix applied.

View works but shows error


Notice: Undefined index: exception in calendar_plugin_display_attachment->display_granularity() (line 70 of /var/www/.../all/modules/calendar/includes/calendar_plugin_display_attachment.inc).

[jalama]

Father Shawn was right just ned to re-save the view, I attached the new view here and committed to the 4.0.5 codebase

[lesmanalim]

The above mostly worked for me as well. I also had to change a line in Calendar module's theme/theme.inc since the CiviCRM event ID key is only 2 characters long:

Line 98:

if (strlen($key) == 3 && substr($key, -2) == 'id' && !empty($row->$key)) {

One possible fix:

if (strlen($key) <= 3 && substr($key, -2) == 'id' && !empty($row->$key)) {