CiviCRM Community Forums (archive)

CiviCRm shouldn't use the Drupal Prefix in the Cal view for a Civi table.

I renamed my tables and removed the prefix and that seems to fixe the issue.

FWIW I believe I have seen this issue reported elsewhere as well.

Dave, is this issue expected to be fixed soon? If not, let me know and I could make a note somewhere in the docs about this--that if a Drupal db prefix is used, then Views integration will fail.

I am running into the exact same problem trying to build a Drupal view of the civicrm events.
Seems like the civicrm events view needs to read from the civicrm database, and drupal is looking for the event table in its own database.
So I am getting the same error.

Lobo mentions (above) documentation on setting up multiple databases in Drupal? Where is this? I have searched high and low....
And then I suppose there would need to be some code to switch between the two databases that I'd need to insert somewhere?

I feel as if I am running into the age-old problem:
the urge to solve the problem and the simultaneous realization that solving the problem is, in fact, perhaps the least elegant solution.

Is there an easy way to deal with this or is it time to scrap using the civicrm calendar in Drupal and just use Drupal's calendar?

This would have been helpful to me back when I was trying to figure out my original issues.  I opted at the time to put CiviCrm in Drupal's database with no prefixs.

Now that I have CiviCRM and Drupal in a single database with no table prefixes, is there a way to integrate the calendar with other Drupal Events? Currently I have two separate calendars cause I couldn't make it work.

Thanks Lobo,

I think I have seen this before but gave up on it.  I will check in to it again and give it another go.

OK. So Lobo's link was the most informative.
Hershel's suggestion involves adding snippits of code to tell Drupal which database to read from as far as I can tell everywhere where Drupal needs to read from civicrm's database - not exactly an out of the box type solution.

So following Lobo's link, and then updatiung the Calendar and Date modules past the versions requested, I am still getting:

user warning: Table '_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 (civicrm_event.event_type_id in ('7')) ORDER BY civicrm_event_start_date ASC in /httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 759.


Probably a way to get this working if I had another day to mess with this type of thing. So I guess time to stop wasting time on this! I'm officially throwing in the towel on trying to get this Drupal site working with Civievents and instead using Drupal's events and calendering using CCK and Views.

If anyone manages to wrestle a stable Drupal/Civicrm combination into working order, please take a snapshot of the entire thing, I imagine development on this is a bit tough trying to keep up with several moving targets (Drupal development, views development, Date development, Calendar development, etc etc)

My project would perhaps be better served with a standalone installation of Drupal, and another of Civicrm. Integrating them is proving too much hassle.

Cool. Thanks Hershel. That was extremely helpful - and didn't take forever.

The documentation here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Drupal+Calendar+with+CiviEvent

needs to be updated to reflect the need to add the prefix array in the drupal settings (and where that can be found in the civicrm admin page) and then of course, the doc needs to mention that permission needs to be granted in mysql to the drupal user to access the civicrm tables.

Thanks for the help!