CiviCRM Community Forums (archive)

Hello All,

I'm working with CiviEvent in my D7 install.  I would like to add a block for Events from CiviEvent.  I go into Views 3, I am able to specify CiviEvent as the type of information to pull in the query (great!)  When I hit submit, I get this error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'acquia_drupal.civicrm_event' doesn't exist

My civicrm install is in a different db, so this is to be expected.  Is there a way to make it point to civicrm.civicrm_event?

Thanks for your help!

Mike

Thanks Hershel -

I'm poking around with the instructions, but Drupal 7 doesn't look like it follows them.  I don't have anything in settings.php with $db_url

I did find $databases and tried the following without luck:
 $databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'acquia_drupal',
      'username' => 'drupaluser',
      'password' => '',
      'host' => '127.0.0.1',
      'port' => '33066',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
  'civicrm' =>
  array (
    'civicrm' =>
    array (
      'database' => 'civicrm',
      'username' => 'drupaluser',
      'password' => '',
      'host' => '127.0.0.1',
      'port' => '33066',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

Any ideas on what I am missing?   

My pleasure. Glad you got it to work.