CiviCRM Community Forums (archive)

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.

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

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

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

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).

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)) {