CiviCRM Community Forums (archive)

Did you add $db_prefix array in your settings.php ?

Check http://drupal.demo.civicrm.org/civicrm/admin/setting/uf&reset=1

Kurund

I went to: http://wiki.civicrm.org/confluence/display/CRMDOC32/Views2+Integration+Module

I am using a godaddy shared hosting, grid hosting.

I followed the directions from the bullet point 1 because I thought that applied to my situation.  I have a civicrm database and a drupal database, both with godaddy, accessed from the same control panel.

I then followed the instructions from bullet point 3 because I am getting the same error as described in bulet point 3.

"find the part that says $db_prefix = 'drupal_'; and change it to this: $db_prefix = array ('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');  NOTE: your prefix may be something other then drupal_, just replace drupal_ with whatever prefix you have configured."

_________________________________________________________________

My script after I made the changes accroding to bullet point 1 & 3 is as follows:

$db_url['default'] = 'mysqli://dop10:Dopal1@dop101256.db.6754888.hostedresource.com/dop10351256';
$db_url['mydb'] ='mysql://civicrmdoal:Dopa3@civicrmdoal.db.6754888.hostedresource.com/civicrmdoperdal?new_link=true';
$db_prefix = array ('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

db_set_active('mydb');

db_query('SELECT * FROM table_in_anotherdb');

Switch back to the default connection when finished.
db_set_active('default');

____________________________________________________________________

My php is currently not working and I get a fatal error error on:  db_set_active('mydb');

I know I need to figure out what I need to replace "drupal" with in the array.


But, even before all of this.....everything refrences VIEWS2.  Where do I get Views2?  I am only finding in drupal the module "Views".   Possibly I have the right module or maybe I don't, I am not sure.  That may be part of the problem. 
 

thank you for your comment.

My php after I added the info you told me to get is:

$db_url['default'] = 'mysqli://dop1026:Dope3@dop106.db.678.hostedresource.com/dop1026';
 $db_url['mydb'] ='mysql://civicrmdl:Dop@civicrmdl.db.6758.hostedresource.com/civicrmdopl?new_link=true';
$db_prefix = array ('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

db_set_active('mydb');

db_query('SELECT * FROM table_in_anotherdb');

//Switch back to the default connection when finished.

db_set_active('default');

$db_prefix = array(
  'civicrm_acl'                              => 'civicrmdoal.',
  'civicrm_acl_cache'                        => 'civicrmdoal.',
  'civicrm_acl_contact_cache'                => 'civicrmdopl.',
  'civicrm_acl_entity_role'                  => 'civicrmdopl.',
  'civicrm_activity'                         => 'civicrmdopel.',
  'civicrm_activity_assignment'              => 'civicrmdopl.',
  'civicrm_activity_target'                  => 'civicrmdopl.',

etc.

I am getting:

Fatal error: Call to undefined function db_set_active() in /home/content/88/6754888/html/doperdal/sites/default/settings.php on line 96 = db_set_active('mydb');


I am sure something I need to take something out of the first part. But I am not sure what.  

You are correct.  I got this error:

user warning: SELECT command denied to user 'dp1026'@'174.201.199.272' for table 'civicrm_event' query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrmdoperdal.civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0)) AND ((DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2010-11' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2010-11')) ORDER BY civicrm_event_start_date ASC in /home/content/88/6754888/html/doperdal/sites/all/modules/views/includes/view.inc on line 775.


I'm not sure how to fix it.  I thought bullet point #1 addressed the issue?

"If your CiviCRM install uses a different database to your Drupal install, ensure that your Drupal DB user has SELECT rights to your CiviCRM DB. Some hosting platforms might make this difficult. For more information about setting up Drupal multi-database access: http://drupal.org/node/18429"

The bullet point is what propted me to write the following lines in my php.

$db_url['default'] = 'mysqli://dop1026:Dope3@dop106.db.678.hostedresource.com/dop1026';
 $db_url['mydb'] ='mysql://civicrmdl:Dop@civicrmdl.db.6758.hostedresource.com/civicrmdopl?new_link=true';
$db_prefix = array ('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');


Possibly there is a mistake in my scripting? 


Which also brings up the issue with the following part of the array:

('default'=>'drupal_','civicrm_event'=>'','civicrm_activity'=>'','civicrm_contact'=>'','civicrm_address'=>'','civicrm_contribution'=>'');

directions are --- NOTE: your prefix may be something other then drupal_, just replace drupal_ with whatever prefix you have configured.

Where do I locate my prefix?     


The prefix is only part of the problem, the other part most likely is the [default], [mydb].

Any idea what the solution is?

Thanks for the help.  I appreciate it.  I reposted in the module section.