CiviCRM Community Forums (archive)

Hi everybody !

I'm having troubles integrating CiviCRM to Drupal.

Here's what i've got : Drupal module CiviCRM Rules Integration, Drupal Module CiviCRM Entities and even Drupal module Webform CiviCRM Integration.

What's more i've added the code given by CiviCRM for integrating CiviCRM to Drupal Views. But whatever i'm trying to do I can't get Civi tables in my View.

It work's perfectly fine on my local but on the dev environment it doesn't.

Could it be because of the params given here "$databases['default']['default']['prefix']"

Thank's !

It doesn't really sound like you are having trouble w/ the integration, but with replicating your local integration in a different environment.  The fact that you are using Rules, Webform, and (unsupported, still experimental?) Entity integration is unnecessarily complicating a failure at a much more basic level.

The array that is output from Administer > System Settings > CMS Integration that is added to Drupal's settings.php only needs to be used when the Drupal tables and CiviCRM tables are in separate database.  That requires the user being used to access the Drupal database ALSO be able to access the CiviCRM database.

It's hard to help without more details about what you've done, but since this was working on in your local environment, I'm guessing the issues is either that the database names in your dev environment are different so the Drupal settings.php needs to be updated w/ a new export from Administer > System Settings > CMS Integration OR the Drupal user doesn't have access to the CiviCRM database in the dev environment.

If you can't figure out what needs to be changed, start troubleshooting this by configuring a clean Drupal/CiviCRM integration on you dev environment and following the steps in the documentation.  Without any information about that environment, we have to assume that it might not support sharing permissions between different CiviCRM and Drupal databases and you may need to consider changing your local dev environment.  I know Pantheon requires a single database with both the Drupal and CiviCRM tables.

Hope this helps!

Hi everyone,

I'm having another issue... when trying to display my View, drupal show me this nice message :

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prefix-XX.civicrm_membership' doesn't exist.

prefix-XX being in fact the Drupal prefix and not the CiviCRM prefix.

The problem is that I can't understand why, even having settings.php filled with CiviCRM tables integration, Drupal can't found my CiviCRM tables.

By the way, I checked my $databases and the prefix is correctly inserted into it.

Everything's ok now !

My problem wasn't CiviCRM integration but the PHP filter in my Drupal View.

Since my database is in dev environment, it's kind of messed up... my incremential ids were broken.

After restoring them everything went fine !

Thank's a lot guys !!