CiviCRM Community Forums (archive)

I'm working in a subdirectory of my MAMP install (in my case, d6) and I get the following error when I try to create en event view in D6.9:

user warning: Table 'd6.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date FROM civicrm_event civicrm_event LIMIT 0, 10 in... etc.
My Drupal db is named d6 as well (Civi db is named d6civi) - so it could be looking at the wrong db or in the wrong directory. Any ideas?

check:

http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module

lobo

Nope - that's not it. I also notice that the Civi iCal feed I'm trying to pass through to Drupal appears in FeedAPI starting with /d6/civicrm, etc. when it should just be /civicrm/etc. The base URL is xx.xx.xx.xx:8888/d6/ so when appended, the final URL is xxx:8888/d6//d6/civicrm/etc., which doesn't work, of course.

I think the two are related - it seems to me that the Drupal integration for Views isn't parsing the base URL correctly and dropping everything once it sees the / delimiter.

i'd first get a working civicrm in the sub directory before trying the views integration

Yes, Civi is working.

the civicrm views integration does not do a lot with the base url. your error is regarding db tables, so u do need the prefix fix mentioned in the wiki page

Ah yes, I see... The Drupal Integration page under Global Settings (on the user's local install) has a cut-and-paste solution - thank you.

I have managed to create a View from the exposed Civi Events consisting of:

• The Event Title that links to the event - good!
• Start and End times in the correct format by using Custom Date Format (g:i A) to the end of creating something like "12:00 PM - 3:00 PM." - excellent!

So far so good. But when I try to create a Calendar view by entering CiviCRM Event Start Date into the Arguments section of Views, I get "The calendar_style style requires a Date argument." I've tried a variety of settings here, to no avail. I'm simply trying to reproduce the functionality of pasting the CiviEvent iCal feed into the Drupal 5 calendar, which worked brilliantly.

For whatever reason, that functionality is no longer implemented in D6 and I'm having a horrific time just trying to create a CiviEvent calendar.

I realize this is more of a Calendar/Views question than a Civi issue; I'm hoping that someone over here can shed some light on the issue - thanks much!

1. you might want to ask your question in the calendar/views forum/issue queue

2. in the meantime, you might want to consider using google calendar.

http://forum.civicrm.org/index.php/topic,1209.msg5324.html#msg5324

If you do the latter, would be great if you could provide a step-by-step recipe so other folks could also do something similar

lobo

No luck. Entering the iCal feed results in:

The address that you provided did not contain a calendar in a valid iCal or GData format.

The feed is, indeed, valid and permissions are set in Drupal for anonymous access. The event data appears when the URL is pasted into a browser. Coming up blank here - thanks for the suggestion, though...

I've created a Drupal issue here: http://drupal.org/node/364149