I receive the following error in the Drupal status report:

CiviCRM Congressional District Module

In sites/default/settings.php you must have prefixes for the following tables: civicrm_custom_field, civicrm_contact, civicrm_address, civicrm_custom_group, civicrm_uf_match, . See the CiviCRM Views Integration for more info.The following tables could not be found: civicrm_custom_field, civicrm_contact, civicrm_address, civicrm_custom_group, civicrm_uf_match.

I have attached my settings.php file (renamed, of course). You will see that I have tried with the array name as $database and $db_prefix, as it was previously in D6. For some reason the CiviCRM Views Integration page.

CommentFileSizeAuthor
#4 array.txt6.33 KBVietyank
#2 settings.php_.txt39.23 KBVietyank
settings.php_.txt39.25 KBVietyank

Comments

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented
Status: Active » Fixed

First you create an array with the just prefixes, then you overwrite that by creating an array in the same variable with the rest of the DB connection information. Move the array with the prefixes below the array with the connection information so that nothing gets overwritten.

Vietyank’s picture

Vietyank commented
StatusFileSize
new settings.php_.txt39.23 KB

I had actually attached the wrong file. Here is the file I am using and it is set up as you said. The CiviCRM folks are saying the array should be called $database and not $db_prefix

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented
Status: Fixed » Postponed (maintainer needs more info)

This new one looks correct. Since you have multiple versions of the file around are you sure that it's reading the proper one?

As an example here's the relevant lines from my settings.php file:

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'driver' => 'mysql',
      'database' => 'd7',
      'username' => '********',
      'password' => '********',
      'host' => 'localhost',
      'port' => '',
      'prefix' => '',
    ),
  ),
);

$databases['default']['default']['prefix']= array(
  'default'                                  => '',
  'civicrm_acl'                              => 'd7_civicrm.',
  'civicrm_acl_cache'                        => 'd7_civicrm.',
  'civicrm_acl_contact_cache'                => 'd7_civicrm.',
  'civicrm_acl_entity_role'                  => 'd7_civicrm.',
  'civicrm_activity'                         => 'd7_civicrm.',
  'civicrm_activity_assignment'              => 'd7_civicrm.',
  'civicrm_activity_target'                  => 'd7_civicrm.',
  'civicrm_address'                          => 'd7_civicrm.',
  'civicrm_address_format'                   => 'd7_civicrm.',
  'civicrm_batch'                            => 'd7_civicrm.',
  'civicrm_cache'                            => 'd7_civicrm.',
  'civicrm_campaign'                         => 'd7_civicrm.',
  'civicrm_campaign_group'                   => 'd7_civicrm.',
  'civicrm_case'                             => 'd7_civicrm.',
  'civicrm_case_activity'                    => 'd7_civicrm.',
  'civicrm_case_contact'                     => 'd7_civicrm.',
  'civicrm_component'                        => 'd7_civicrm.',
  'civicrm_contact'                          => 'd7_civicrm.',
  'civicrm_contact_type'                     => 'd7_civicrm.',
  'civicrm_contribution'                     => 'd7_civicrm.',
  'civicrm_contribution_page'                => 'd7_civicrm.',
  'civicrm_contribution_product'             => 'd7_civicrm.',
  'civicrm_contribution_recur'               => 'd7_civicrm.',
  'civicrm_contribution_soft'                => 'd7_civicrm.',
  'civicrm_contribution_type'                => 'd7_civicrm.',
  'civicrm_contribution_widget'              => 'd7_civicrm.',
  'civicrm_country'                          => 'd7_civicrm.',
  'civicrm_county'                           => 'd7_civicrm.',
  'civicrm_currency'                         => 'd7_civicrm.',
  'civicrm_custom_field'                     => 'd7_civicrm.',
  'civicrm_custom_group'                     => 'd7_civicrm.',
  'civicrm_dashboard'                        => 'd7_civicrm.',
  'civicrm_dashboard_contact'                => 'd7_civicrm.',
  'civicrm_dedupe_exception'                 => 'd7_civicrm.',
  'civicrm_dedupe_rule'                      => 'd7_civicrm.',
  'civicrm_dedupe_rule_group'                => 'd7_civicrm.',
  'civicrm_discount'                         => 'd7_civicrm.',
  'civicrm_domain'                           => 'd7_civicrm.',
  'civicrm_email'                            => 'd7_civicrm.',
  'civicrm_entity_batch'                     => 'd7_civicrm.',
  'civicrm_entity_file'                      => 'd7_civicrm.',
  'civicrm_entity_financial_trxn'            => 'd7_civicrm.',
  'civicrm_entity_tag'                       => 'd7_civicrm.',
  'civicrm_event'                            => 'd7_civicrm.',
  'civicrm_file'                             => 'd7_civicrm.',
  'civicrm_financial_account'                => 'd7_civicrm.',
  'civicrm_financial_trxn'                   => 'd7_civicrm.',
  'civicrm_grant'                            => 'd7_civicrm.',
  'civicrm_group'                            => 'd7_civicrm.',
  'civicrm_group_contact'                    => 'd7_civicrm.',
  'civicrm_group_contact_cache'              => 'd7_civicrm.',
  'civicrm_group_nesting'                    => 'd7_civicrm.',
  'civicrm_group_organization'               => 'd7_civicrm.',
  'civicrm_im'                               => 'd7_civicrm.',
  'civicrm_line_item'                        => 'd7_civicrm.',
  'civicrm_loc_block'                        => 'd7_civicrm.',
  'civicrm_location_type'                    => 'd7_civicrm.',
  'civicrm_log'                              => 'd7_civicrm.',
  'civicrm_mail_settings'                    => 'd7_civicrm.',
  'civicrm_mailing'                          => 'd7_civicrm.',
  'civicrm_mailing_bounce_pattern'           => 'd7_civicrm.',
  'civicrm_mailing_bounce_type'              => 'd7_civicrm.',
  'civicrm_mailing_component'                => 'd7_civicrm.',
  'civicrm_mailing_event_bounce'             => 'd7_civicrm.',
  'civicrm_mailing_event_confirm'            => 'd7_civicrm.',
  'civicrm_mailing_event_delivered'          => 'd7_civicrm.',
  'civicrm_mailing_event_forward'            => 'd7_civicrm.',
  'civicrm_mailing_event_opened'             => 'd7_civicrm.',
  'civicrm_mailing_event_queue'              => 'd7_civicrm.',
  'civicrm_mailing_event_reply'              => 'd7_civicrm.',
  'civicrm_mailing_event_subscribe'          => 'd7_civicrm.',
  'civicrm_mailing_event_trackable_url_open' => 'd7_civicrm.',
  'civicrm_mailing_event_unsubscribe'        => 'd7_civicrm.',
  'civicrm_mailing_group'                    => 'd7_civicrm.',
  'civicrm_mailing_job'                      => 'd7_civicrm.',
  'civicrm_mailing_recipients'               => 'd7_civicrm.',
  'civicrm_mailing_spool'                    => 'd7_civicrm.',
  'civicrm_mailing_trackable_url'            => 'd7_civicrm.',
  'civicrm_mapping'                          => 'd7_civicrm.',
  'civicrm_mapping_field'                    => 'd7_civicrm.',
  'civicrm_membership'                       => 'd7_civicrm.',
  'civicrm_membership_block'                 => 'd7_civicrm.',
  'civicrm_membership_log'                   => 'd7_civicrm.',
  'civicrm_membership_payment'               => 'd7_civicrm.',
  'civicrm_membership_status'                => 'd7_civicrm.',
  'civicrm_membership_type'                  => 'd7_civicrm.',
  'civicrm_menu'                             => 'd7_civicrm.',
  'civicrm_msg_template'                     => 'd7_civicrm.',
  'civicrm_navigation'                       => 'd7_civicrm.',
  'civicrm_note'                             => 'd7_civicrm.',
  'civicrm_openid'                           => 'd7_civicrm.',
  'civicrm_openid_associations'              => 'd7_civicrm.',
  'civicrm_openid_nonces'                    => 'd7_civicrm.',
  'civicrm_option_group'                     => 'd7_civicrm.',
  'civicrm_option_value'                     => 'd7_civicrm.',
  'civicrm_participant'                      => 'd7_civicrm.',
  'civicrm_participant_payment'              => 'd7_civicrm.',
  'civicrm_participant_status_type'          => 'd7_civicrm.',
  'civicrm_payment_processor'                => 'd7_civicrm.',
  'civicrm_payment_processor_type'           => 'd7_civicrm.',
  'civicrm_pcp'                              => 'd7_civicrm.',
  'civicrm_pcp_block'                        => 'd7_civicrm.',
  'civicrm_persistent'                       => 'd7_civicrm.',
  'civicrm_phone'                            => 'd7_civicrm.',
  'civicrm_pledge'                           => 'd7_civicrm.',
  'civicrm_pledge_block'                     => 'd7_civicrm.',
  'civicrm_pledge_payment'                   => 'd7_civicrm.',
  'civicrm_preferences'                      => 'd7_civicrm.',
  'civicrm_preferences_date'                 => 'd7_civicrm.',
  'civicrm_premiums'                         => 'd7_civicrm.',
  'civicrm_premiums_product'                 => 'd7_civicrm.',
  'civicrm_prevnext_cache'                   => 'd7_civicrm.',
  'civicrm_price_field'                      => 'd7_civicrm.',
  'civicrm_price_field_value'                => 'd7_civicrm.',
  'civicrm_price_set'                        => 'd7_civicrm.',
  'civicrm_price_set_entity'                 => 'd7_civicrm.',
  'civicrm_product'                          => 'd7_civicrm.',
  'civicrm_project'                          => 'd7_civicrm.',
  'civicrm_relationship'                     => 'd7_civicrm.',
  'civicrm_relationship_type'                => 'd7_civicrm.',
  'civicrm_report_instance'                  => 'd7_civicrm.',
  'civicrm_saved_search'                     => 'd7_civicrm.',
  'civicrm_state_province'                   => 'd7_civicrm.',
  'civicrm_subscription_history'             => 'd7_civicrm.',
  'civicrm_survey'                           => 'd7_civicrm.',
  'civicrm_tag'                              => 'd7_civicrm.',
  'civicrm_task'                             => 'd7_civicrm.',
  'civicrm_task_status'                      => 'd7_civicrm.',
  'civicrm_tell_friend'                      => 'd7_civicrm.',
  'civicrm_timezone'                         => 'd7_civicrm.',
  'civicrm_uf_field'                         => 'd7_civicrm.',
  'civicrm_uf_group'                         => 'd7_civicrm.',
  'civicrm_uf_join'                          => 'd7_civicrm.',
  'civicrm_uf_match'                         => 'd7_civicrm.',
  'civicrm_value_constituent_information_1'  => 'd7_civicrm.',
  'civicrm_value_donor_information_3'        => 'd7_civicrm.',
  'civicrm_value_food_preference_2'          => 'd7_civicrm.',
  'civicrm_value_congressional_district_4'   => 'd7_civicrm.',
  'civicrm_website'                          => 'd7_civicrm.',
  'civicrm_worldregion'                      => 'd7_civicrm.',
);

You can add this at the bottom to confirm that the proper structure is being built:

var_export($databases);
die();
Vietyank’s picture

Vietyank commented
StatusFileSize
new array.txt6.33 KB

I added that. It dumped the array to my screen. See attached.

BTW, Views Integration is working. The CCRM folks had me check that out.

Vietyank’s picture

Vietyank commented

Hmmm....after I took out the debug code, the problem seems to have gone away. Still testing but I am no longer getting the error message in the status report. Perhaps something was cached, although I was clearing caches.

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented
Status: Postponed (maintainer needs more info) » Fixed
Vietyank’s picture

Vietyank commented

I am not getting any results from the lookups. I have an API key from Sunlight Labs and don't see any errors in the logs about the key. I have set up the two fields (Congressional District and Congressional District Override). They are both defined as 16 alphanumeric with the first being view only.

I have edited a couple of the contacts, which have been validly geocoded by Google and saved but do not see the Congressional District in the field. I've also run in batch but got no results.

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

In most cases lookups only happen on cron runs.

Vietyank’s picture

Vietyank commented

Oh, so it doesn't work like CiviCRM geocoding, where it is dynamic, that is the lookup is performed when the record is saved. Let me get it straight, then. The request is queued then the lookup is performed during a cron run.

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

correct.

This decision was made so as to be nice to Sunlight. If your site has hundreds of users updating their profiles all at once (the site that I wrote this for does) it would swamp Sunlight, and possibly your website too as page generation slows down waiting for Sunlight to respond.

This is different from Google who can take a good walloping in stride.

Vietyank’s picture

Vietyank commented

I understand but now I am seeing a different problem. I batch geocoded the data with CiviCRM yesterday and all was good. Google did indeed take it in stride (about 2000) records. When I started working with your module I noticed that all of a sudden all the geocode data (lat/long) was lost and I have to geocode again. I noticed this too with Civi 3.2 but never followed up on it. Something is causing it to lose the data.

Vietyank’s picture

Vietyank commented

Sorry, but I am a bit confused about the cron job. Are you referring to the Drupal cron job or a CiviCRM scheduled job?

Vietyank’s picture

Vietyank commented

I've reviewed the logs and can see that the records were processed by the cron job but I'm still not seeing the Congressional District being posted to the field I have defined. Can you suggest any debugging techniques?

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.