Drupal and CiviCRM views intergration Issue

[emmy]

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

[Erik Hommel]

I assume you have seen this wiki page? http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

[Hershel]

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

[emmy]

Hi Hershel,

I am copying the exact code from the civicrm installation.

I have been reading up on the issue from different individuals on the forum and have gone through the required steps a few times now.

Am using different user credentials  for my CiviCRM DB  and my Drupal DB.

In drupal 6 this is pretty easy to setup when you know how.

Any help or advice with this issue would greatly be appreciated

[emmy]

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