CiviCRM Community Forums (archive)

AH! Nice to know I was on the right track. lobo -- i added this link to the top of the Drupal/Civi Cal integration page. Very useful!

Followed the steps but when I try to view, I get this error:



    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM 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-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, dir_event.title AS civicrm_event_title FROM 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-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.


Any help?
Thanks

I'm getting a similar error:

    * user warning: Table 'tcpcrm_drupal.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(civicrm_event.start_date, '%Y-%m') <= '2010-01' AND DATE_FORMAT(civicrm_event.start_date, '%Y-%m') >= '2010-01')) ORDER BY civicrm_event_start_date ASC in /home/username/thecenterproject/sites/all/modules/views/includes/view.inc on line 769.
    * user warning: Table 'tcpcrm_drupal.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(civicrm_event.start_date, '%Y-%m') <= '2010-01' AND DATE_FORMAT(civicrm_event.start_date, '%Y-%m') >= '2010-01')) ORDER BY civicrm_event_start_date ASC in /home/username/thecenterproject/sites/all/modules/views/includes/view.inc on line 769.

It doesn't seem like this was ever resolved in this string. Any help?

If your CiviCRM tables are in a separate database from your Drupal DB, use this article to get your Drupal Calendar/CiviCRM integration working:

http://redspire.net/content/civicrm-views-2-integration-remote-civicrm-database

Just setup CiviCRM DB as separate DB connection as described.

Community,

May I please ask for your help?

I am so close to getting the CiviEvent/Drupal Calendar integration running, but missing a critical step somewhere.

Here is my problem: calendar events aren't showing up on the calendar automatically. They do show up in the Drupal content section and the Drupal calendar when I click the 'Refresh' tab on the feed I created in Step 3 of Option 2 at...

http://wiki.civicrm.org/confluence/display/CRMDOC32/Using+Drupal+Calendar+with+CiviEvent.

After I click the 'Refresh' in the feed's edit view, the calendar events are created and appear in the view I created in step 10. Everything is perfect, except it's not automatic.

My question is: how do I automate the process of creating calendar events from the CiviEvent iCal feed?

Here are the steps I followed:

Chose "Option 2. Integrate CiviEvents iCal feed with Drupal Calendar"

Step 1
OK

Step 2
Chose "Calendar event" as the content type.

Step 3
Chose 'Feed' as the content type.
I don't see a section called "FeedAPI".
I don't see a section called "Parser Common iCal Syndication".

Steps 4-13
Everything works as expected. Civi events show up in my Drupal calendar as expected.

----------------
On a related note, a bunch of errors are showing up in my Drupal log:

Table &#039;nchs_civicrm.backup_migrate_schedules&#039; doesn&#039;t exist query: UPDATE backup_migrate_schedules SET last_run = 1286156640 WHERE schedule_id = &#039;7348d141b666c5d92d7360b326f9e104&#039; in /home/nchs/public_html/sites/all/modules/backup_migrate/includes/schedules.inc on line 364.

Table &#039;nchs_civicrm.feedapi_stat&#039; doesn&#039;t exist query: DELETE FROM feedapi_stat WHERE timestamp &lt; 1283737439 in /home/nchs/public_html/sites/all/modules/feedapi/feedapi.module on line 689.

Table &#039;nchs_civicrm.search_index&#039; doesn&#039;t exist query: SELECT SUM(score) FROM search_index WHERE word = &#039;402am&#039; in /home/nchs/public_html/modules/search/search.module on line 285.

Table &#039;nchs_civicrm.search_total&#039; doesn&#039;t exist query: UPDATE search_total SET count = 0.301029995664 WHERE word = &#039;402am&#039; in /home/nchs/public_html/modules/search/search.module on line 288.

Table &#039;nchs_civicrm.search_total&#039; doesn&#039;t exist query: SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL in /home/nchs/public_html/modules/search/search.module on line 296.

Now that we're working with CiviCRM 4.0, Drupal 7, and Views 3, are we still limited to the options presented on http://wiki.civicrm.org/confluence/display/CRMDOC33/Using+Drupal+Calendar+with+CiviEvent for CiviEvent integration with Drupal Views/Calendar? Or are there new possibilities?

Having a hard time integrating CiviEvents with Calendar View. Can't seem to find out how to handle the none existing field date_filter

I am using
Drupal 7
CiviCRM 4.0.6
Chaos tools 7.x-1.0-rc1
Calendar 7.x-3.x-dev
Views   7.x-3.0-rc1

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_event.date_filter' in 'where clause'

SELECT civicrm_event.id AS id, civicrm_event.end_date AS civicrm_event_end_date, civicrm_event.event_type_id AS civicrm_event_event_type_id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title
FROM
{civicrm_event} civicrm_event
WHERE (( (DATE_FORMAT(FROM_UNIXTIME(civicrm_event.date_filter), '%Y-%m') >= '2011-10' AND DATE_FORMAT(FROM_UNIXTIME(civicrm_event.date_filter), '%Y-%m') <= '2011-10') ))

The first few people who need it and experiment with it will need to lay down and pave the road for others

Seems like you are one of the first to try this combination, so you might want to document how/where you got and hopefully other folks who come down the road can use your stuff and help you make progress

lobo