CiviCRM Community Forums (archive)

Hi

I am new to civicrm and have encountered a few problems with the integration of civicrm and drupal . Also to make known, am working from a web shared hosting environment.

I have followed all the steps that I have found on a few posts that i came across however am at my wits end at the moment.

Drupal: v6.28
Civicrm: v3.4.8

Civicrm db: db1114980_xxxx_DB
Drupal db: db1114980_xxxx_14

When I try to view civievents through drupal views i have been getting a few warning and with all the modifications I done to the settings.php and civicrm.views.inc files, the current warning is as follows:

user warning: Table 'db1114980_xxxx_DB.civicrm_eventcivicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM `db1114980_xxxx_DB`.civicrm_eventcivicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(3600)), '%Y-%m') <= '2013-09' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(3600)), '%Y-%m') >= '2013-09')) ORDER BY civicrm_event_start_date ASC in /usr/local/pem/vhosts/260664/webspace/httpdocs/fightingwords.co.uk/sites/all/modules/views/includes/view.inc on line 814.

Settings.php file currently being used:

$db_url['default'] = 'mysqli://u1114980_user1:******@mysql1853int.cp.test.com:4406/db1114980_xxxx_14';
$db_url['civicrm'] = 'mysqli://u1114980_user2:******@mysql919int.cp.test.com:4406/db1114980_xxxx_DB';
$db_prefix = array(
  'default'                            =>   '`db1114980_xxxx_14`.',
  'civicrm_acl'                              => '`db1114980_xxxx_DB`.civicrm_acl',
  'civicrm_acl_cache'                        => '`db1114980_xxxx_DB`.civicrm_acl_cache',
  'civicrm_acl_contact_cache'                => '`db1114980_xxxx_DB`.civicrm_acl_contact_cache',
  'civicrm_acl_entity_role'                  => '`db1114980_xxxx_DB`.civicrm_acl_entity_role',
etc......

civicrm.view.inc file:

I added the following key/value pair 'database' => 'civicrm', to all the $data['table_name']['table']['base'] array definitions.

If anyone can advice or help me solve this issue I will be so grateful.

any reason why you are still on 3.4? that version is fairly obsolete at this stage

lobo