CiviCRM Community Forums (archive)

Hello,

I have followed the instructions (http://wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration) to edit my settings.php file. I have separate databases for Drupal and CiviCRM, but the same host, username and password for both databases.

My settings.php file now includes this:

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'smac_drupal',
      'username' => 'myusername',
      'password' => 'mypassword',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);
$databases['default']['default']['prefix']= array(
  'default' => '',
  'civicrm_acl'                              => '`smac_civicrm`.',
  'civicrm_acl_cache'                        => '`smac_civicrm`.',
  'civicrm_acl_contact_cache'                => '`smac_civicrm`.',
  'civicrm_acl_entity_role'                  => '`smac_civicrm`.',
 ... etc. ...
  'civicrm_website'                          => '`smac_civicrm`.',
  'civicrm_word_replacement'                 => '`smac_civicrm`.',
  'civicrm_worldregion'                      => '`smac_civicrm`.',
);
I enabled the CiviCRM Events view, and the calendar displays more or less as expected, but it does not display events. The Views preview gives me this error:

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

However, I am able to see all the CiviCRM fields when I click "add" if I choose to add a new field to the view.

Any ideas why this is not working?

Yes, same issue. I can set up the view (choosing CiviCRM fields), but I get the same error on the view preview and even if I set up a text rather than a calendar display, it is blank.

Thank you, Pete. Forgive me, I'm not an expert. Is this supposed to give me a clue to a solution? Unfortunately, I'm still clueless.

Well, I hope you do run into Mr. Chinchilla.

Just for clarification, is the "civi-views" module you refer to the one located at /sites/all/modules/civicrm/drupal/modules/views?

Thanks.

Not the first time I have felt dumb on here: My mistake. I had edited the settings file and thought I had uploaded it, but I missed the error message generated by my FTP program indicating that I had not changed the file's permission on the server to be writable, so the file was not saved. I edited the settings file and saved it properly and the calendar works now. Thanks, both of you, for taking the time with me.

farmrchrys, glad you got it.

Pete, the last bit of SQL you posted does look wrong. It looks like it's looking for events that start after "13 hours before October 1st" and before "12 hours before October 1st". That's a one hour window, and it's just before October. I think. Look at formatted this way:

  DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_event.start_date), SEC_TO_TIME(46800)), '%Y-%m') >= '2014-10' AND
  DATE_FORMAT(ADDTIME(FROM_UNIXTIME(civicrm_event.start_date), SEC_TO_TIME(43200)), '%Y-%m') <= '2014-10') ))
Bizarre.