CiviCRM Community Forums (archive)

I have civicrm 4.0.7 installed with drupal 7.8, and I followed the views3 and drupal integration instructions, copy and paste the code into settings.php.
I was successfully synchronized users to contacts after the integration. Now I want to create an civi events view in drupal using views 3, but got an error:

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

I tried to create other civi related views, all showed me that the views is not selecting table from civicrm, instead, it is try to find the table from my drupal database (I have two separate databases for civicrm and drupal).

Do anybody know what's wrong here? Thank you!

Thanks for your suggestions, msn! But I really want this works normally because I need to create a few views from civicrm content. Do you have two separate db? Does you drupal db user have select privilege in civicrm db if you did set up two dbs? I am trying to find out what the problem is...

Thank you, msn! I too have two dbs, and I pasted this code in settings.php:
/**drupal 7 and civicrm views integration*/
$databases['default']['default']['prefix']= array(
  'default'                                  => 'cmdr7',
  'civicrm_acl'                              => '`mysite_civicrm`.',
  'civicrm_acl_cache'                        => '`mysite_civicrm`.',
  'civicrm_acl_contact_cache'                => '`mysite_civicrm`.',
  'civicrm_acl_entity_role'                  => '`mysite_civicrm`.',
  'civicrm_action_log'                       => '`mysite_civicrm`.',
  'civicrm_action_mapping'                   => '`mysite_civicrm`.',
  'civicrm_action_schedule'                  => '`mysite_civicrm`.',
  'civicrm_activity'                         => '`mysite_civicrm`.',
.....
  'civicrm_worldregion'                      => '`mysite_civicrm`.',
);
 
AFTER
$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'mysite_drupal',
      'username' => 'myusername',
      'password' => 'mypassword',
      'host' => 'myaddress',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => 'cmdr7',
    ),
  ),
);
I also check with my db admin, the drupal user does have select permission over the civicrm database. I could not find what's wrong here:(

Thanks for your response. I can add a new view and all civicrm content type shown on the list (see the attachment), but could not get anything in the next step (pic 2 below).
I noticed that the system was looking for the civicrm_contact table in drupal database, rather than in civicrm database. My db admin told me he had already assigned the DB user all privileges in both DBs (drupal and civicrm). Any suggestions/ideas?

Thank you!

The drupal database's prefix is cmdr7, civicrm database does not have a prefix.