Closed (works as designed)
Project:
Domain
Version:
7.x-3.4
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
11 Jun 2012 at 10:03 UTC
Updated:
17 Jun 2012 at 16:29 UTC
We have one CiviCRM installion which works with a Domain Access site. We don't use the Multisite feature of CiviCRM.
I juft tryed to aneble view intigration for CiviCRm whoch is done by adding some code to the settings.php file. Because CiviCRM has it's own Database.
$databases['default']['default']['prefix']= array(
'civicrm_acl' => '`dafmr_crm`.',
'civicrm_acl_cache' => '`dafmr_crm`.',
'civicrm_acl_contact_cache' => '`dafmr_crm`.',
'civicrm_acl_entity_role' => '`dafmr_crm`.',
'civicrm_action_log' => '`dafmr_crm`.',
'civicrm_action_mapping' => '`dafmr_crm`.',
'civicrm_action_schedule' => '`dafmr_crm`.',
'civicrm_activity' => '`dafmr_crm`.',
'civicrm_activity_assignment' => '`dafmr_crm`.',
'civicrm_activity_target' => '`dafmr_crm`.',
'civicrm_address' => '`dafmr_crm`.',
'civicrm_address_format' => '`dafmr_crm`.',
'civicrm_batch' => '`dafmr_crm`.',
'civicrm_cache' => '`dafmr_crm`.',
'civicrm_campaign' => '`dafmr_crm`.',
'civicrm_campaign_group' => '`dafmr_crm`.',
'civicrm_case' => '`dafmr_crm`.',
'civicrm_case_activity' => '`dafmr_crm`.',
'civicrm_case_contact' => '`dafmr_crm`.',
'civicrm_component' => '`dafmr_crm`.',
'civicrm_contact' => '`dafmr_crm`.',
'civicrm_contact_type' => '`dafmr_crm`.',
'civicrm_contribution' => '`dafmr_crm`.',
'civicrm_contribution_page' => '`dafmr_crm`.',
'civicrm_contribution_product' => '`dafmr_crm`.',
'civicrm_contribution_recur' => '`dafmr_crm`.',
'civicrm_contribution_soft' => '`dafmr_crm`.',
'civicrm_contribution_type' => '`dafmr_crm`.',
'civicrm_contribution_widget' => '`dafmr_crm`.',
'civicrm_country' => '`dafmr_crm`.',
'civicrm_county' => '`dafmr_crm`.',
'civicrm_currency' => '`dafmr_crm`.',
'civicrm_custom_field' => '`dafmr_crm`.',
'civicrm_custom_group' => '`dafmr_crm`.',
'civicrm_dashboard' => '`dafmr_crm`.',
'civicrm_dashboard_contact' => '`dafmr_crm`.',
'civicrm_dedupe_exception' => '`dafmr_crm`.',
'civicrm_dedupe_rule' => '`dafmr_crm`.',
'civicrm_dedupe_rule_group' => '`dafmr_crm`.',
'civicrm_discount' => '`dafmr_crm`.',
'civicrm_domain' => '`dafmr_crm`.',
'civicrm_email' => '`dafmr_crm`.',
'civicrm_entity_batch' => '`dafmr_crm`.',
'civicrm_entity_file' => '`dafmr_crm`.',
'civicrm_entity_financial_trxn' => '`dafmr_crm`.',
'civicrm_entity_tag' => '`dafmr_crm`.',
'civicrm_event' => '`dafmr_crm`.',
'civicrm_event_carts' => '`dafmr_crm`.',
'civicrm_events_in_carts' => '`dafmr_crm`.',
'civicrm_file' => '`dafmr_crm`.',
'civicrm_financial_account' => '`dafmr_crm`.',
'civicrm_financial_trxn' => '`dafmr_crm`.',
'civicrm_grant' => '`dafmr_crm`.',
'civicrm_group' => '`dafmr_crm`.',
'civicrm_group_contact' => '`dafmr_crm`.',
'civicrm_group_contact_cache' => '`dafmr_crm`.',
'civicrm_group_nesting' => '`dafmr_crm`.',
'civicrm_group_organization' => '`dafmr_crm`.',
'civicrm_im' => '`dafmr_crm`.',
'civicrm_job' => '`dafmr_crm`.',
'civicrm_job_log' => '`dafmr_crm`.',
'civicrm_line_item' => '`dafmr_crm`.',
'civicrm_loc_block' => '`dafmr_crm`.',
'civicrm_location_type' => '`dafmr_crm`.',
'civicrm_log' => '`dafmr_crm`.',
'civicrm_mail_settings' => '`dafmr_crm`.',
'civicrm_mailing' => '`dafmr_crm`.',
'civicrm_mailing_bounce_pattern' => '`dafmr_crm`.',
'civicrm_mailing_bounce_type' => '`dafmr_crm`.',
'civicrm_mailing_component' => '`dafmr_crm`.',
'civicrm_mailing_event_bounce' => '`dafmr_crm`.',
'civicrm_mailing_event_confirm' => '`dafmr_crm`.',
'civicrm_mailing_event_delivered' => '`dafmr_crm`.',
'civicrm_mailing_event_forward' => '`dafmr_crm`.',
'civicrm_mailing_event_opened' => '`dafmr_crm`.',
'civicrm_mailing_event_queue' => '`dafmr_crm`.',
'civicrm_mailing_event_reply' => '`dafmr_crm`.',
'civicrm_mailing_event_subscribe' => '`dafmr_crm`.',
'civicrm_mailing_event_trackable_url_open' => '`dafmr_crm`.',
'civicrm_mailing_event_unsubscribe' => '`dafmr_crm`.',
'civicrm_mailing_group' => '`dafmr_crm`.',
'civicrm_mailing_job' => '`dafmr_crm`.',
'civicrm_mailing_recipients' => '`dafmr_crm`.',
'civicrm_mailing_spool' => '`dafmr_crm`.',
'civicrm_mailing_trackable_url' => '`dafmr_crm`.',
'civicrm_mapping' => '`dafmr_crm`.',
'civicrm_mapping_field' => '`dafmr_crm`.',
'civicrm_membership' => '`dafmr_crm`.',
'civicrm_membership_block' => '`dafmr_crm`.',
'civicrm_membership_log' => '`dafmr_crm`.',
'civicrm_membership_payment' => '`dafmr_crm`.',
'civicrm_membership_status' => '`dafmr_crm`.',
'civicrm_membership_type' => '`dafmr_crm`.',
'civicrm_menu' => '`dafmr_crm`.',
'civicrm_navigation' => '`dafmr_crm`.',
'civicrm_note' => '`dafmr_crm`.',
'civicrm_openid' => '`dafmr_crm`.',
'civicrm_option_group' => '`dafmr_crm`.',
'civicrm_option_value' => '`dafmr_crm`.',
'civicrm_participant' => '`dafmr_crm`.',
'civicrm_participant_payment' => '`dafmr_crm`.',
'civicrm_participant_status_type' => '`dafmr_crm`.',
'civicrm_payment_processor' => '`dafmr_crm`.',
'civicrm_payment_processor_type' => '`dafmr_crm`.',
'civicrm_pcp' => '`dafmr_crm`.',
'civicrm_pcp_block' => '`dafmr_crm`.',
'civicrm_persistent' => '`dafmr_crm`.',
'civicrm_phone' => '`dafmr_crm`.',
'civicrm_pledge' => '`dafmr_crm`.',
'civicrm_pledge_block' => '`dafmr_crm`.',
'civicrm_pledge_payment' => '`dafmr_crm`.',
'civicrm_preferences_date' => '`dafmr_crm`.',
'civicrm_premiums' => '`dafmr_crm`.',
'civicrm_premiums_product' => '`dafmr_crm`.',
'civicrm_prevnext_cache' => '`dafmr_crm`.',
'civicrm_price_field' => '`dafmr_crm`.',
'civicrm_price_field_value' => '`dafmr_crm`.',
'civicrm_price_set' => '`dafmr_crm`.',
'civicrm_price_set_entity' => '`dafmr_crm`.',
'civicrm_product' => '`dafmr_crm`.',
'civicrm_project' => '`dafmr_crm`.',
'civicrm_relationship' => '`dafmr_crm`.',
'civicrm_relationship_type' => '`dafmr_crm`.',
'civicrm_report_instance' => '`dafmr_crm`.',
'civicrm_saved_search' => '`dafmr_crm`.',
'civicrm_setting' => '`dafmr_crm`.',
'civicrm_state_province' => '`dafmr_crm`.',
'civicrm_subscription_history' => '`dafmr_crm`.',
'civicrm_survey' => '`dafmr_crm`.',
'civicrm_tag' => '`dafmr_crm`.',
'civicrm_task' => '`dafmr_crm`.',
'civicrm_task_status' => '`dafmr_crm`.',
'civicrm_tell_friend' => '`dafmr_crm`.',
'civicrm_timezone' => '`dafmr_crm`.',
'civicrm_uf_field' => '`dafmr_crm`.',
'civicrm_uf_group' => '`dafmr_crm`.',
'civicrm_uf_join' => '`dafmr_crm`.',
'civicrm_uf_match' => '`dafmr_crm`.',
'civicrm_value_ausweisdaten_1' => '`dafmr_crm`.',
'civicrm_value_communication_details' => '`dafmr_crm`.',
'civicrm_value_constituent_info' => '`dafmr_crm`.',
'civicrm_value_contact_info' => '`dafmr_crm`.',
'civicrm_value_demographics' => '`dafmr_crm`.',
'civicrm_value_elected_official_info_22' => '`dafmr_crm`.',
'civicrm_value_event_details' => '`dafmr_crm`.',
'civicrm_value_funder_info_21' => '`dafmr_crm`.',
'civicrm_value_grant_info' => '`dafmr_crm`.',
'civicrm_value_grassroots_info' => '`dafmr_crm`.',
'civicrm_value_media_info_20' => '`dafmr_crm`.',
'civicrm_value_media_outlet_info_19' => '`dafmr_crm`.',
'civicrm_value_organizational_details' => '`dafmr_crm`.',
'civicrm_value_participant_info' => '`dafmr_crm`.',
'civicrm_value_proposal_info' => '`dafmr_crm`.',
'civicrm_value_voter_info' => '`dafmr_crm`.',
'civicrm_value_weitere_angaben_2' => '`dafmr_crm`.',
'civicrm_view_case_activity_recent' => '`dafmr_crm`.',
'civicrm_view_case_activity_upcoming' => '`dafmr_crm`.',
'civicrm_website' => '`dafmr_crm`.',
'civicrm_worldregion' => '`dafmr_crm`.',
);Views intigrations works ok with CiviCRM so far, but i get this Notice as soon as i added this code into settings.php.
Notice: Undefined index: default in domain_get_primary_table() (line 266 of /srv/htdocs/sites/all/modules/domain/domain.bootstrap.inc).
So my question is, what is the right way to do this with DA?
Comments
Comment #1
agentrickardI think you need to add this item to the array:
Comment #2
andros commentedThx agentrickard. The notice is gone.
Comment #3
andros commentedComment #4
agentrickardFYI. From settings.php code documentation: