CiviCRM Community Forums (archive)

I was eager to test the latest development in 2.2.3 with regard to calendaring, as outlined here http://civicrm.org/node/557 . I upgraded a site to CiviCRM 2.2.3 and I applied the patch to /sites/all/modules/contrib/date/includes/date_api_fields.inc and after I submitted the Modules page, I indeed saw the new View. When running a preview of it, however, I see no data in my calendar. No error, but no data. So I looked at the SQL:

SELECT civicrm_event.id AS id,
   civicrm_event.start_date AS civicrm_event_start_date,
   civicrm_event.title AS civicrm_event_title,
   node.type AS node_type
 FROM d6_civicrm.civicrm_event civicrm_event
 WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0))
    AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m') <= '2009-05' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m') >= '2009-05'))
   ORDER BY civicrm_event_start_date ASC

As is clear from a close examination of this code, the term node.type AS node_type is invalid--there is no table called node in the CiviCRM database. Before I try to track this down (not sure how easy that will be either) does anyone have any idea what could be causing that?

If I remove that term, the SQL returns the expected result, so it seems that aside from that one term, it is correct.

Another question, while I'm at it: The default View created is of Style: Calendar navigation but no such Style actually exists. At least I can't find anyway to make it appear in my Style list. I certainly understand that I can clone this View, but it is curious that I (as of yet) don't see anyway to create my own from scratch.

The site in question is a dev version of a site which was Drupal, which I am working on upgrading to Drupal 6. I wonder if the upgrade process may have something to do with this.

Thanks.

There was another drupal patch required to enable non node-based views to show in the calendar. The latest patches assume that is in place. I can't recall which Drupal module it patched.

You are quite correct. I found that patch and the calendar module is the one in question, and that patch does appear to have been committed. I took the latest dev release "6.x-2.x-dev 2009-May-12" and that fixed the problem. Could be that stable "6.x-2.1 2009-Mar-25" also has that patch--I didn't test that however.

Thank you very much!