CiviCRM Community Forums (archive)

Hi

I am trying to integrate my Drupal views with Civicrm.

Am using drupal 7 and civicrm version 4.2.0

My Drupal database and civicrm database are separate on the same host

Am getting this error when I try to create views: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxxxx.civicrm_event' doesn't exist.

I have added the required code to my settings.php drupal file but still getting the error.

My settings.php code:

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'drupal7',
      'username' => 'bobby',
      'password' => '******',
      'host' => 'host.com',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

 $databases['civicrm']['default'] = array (
      'database' => 'dru7_civi',
      'username' => 'droopy',
      'password' => '******',
      'host' => 'host.com',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
);


$databases['civicrm']['default']['prefix']= array(

  'default'                                 => '',
  'civicrm_acl'                              => '`dru7_civi`.',
  'civicrm_acl_cache'                        => '`dru7_civi`.',
  'civicrm_acl_contact_cache'                => '`dru7_civi`.',
  'civicrm_acl_entity_role'                  => '`dru7_civi`.',


Can anyone please help?

regards

emmy, you copied the code precisely from the correct page on your CiviCRM install?

Hi guys,

I managed to resolve my issue. By Installing both the Civicrm and the drupal on the same database.

I followed the instructions that Erick Hommle suggested at link: http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration.

I read up on a few other suggestions on the issue by Hershel and I was home free.

Thanks guys until the next time

Cheers