CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM not showing in Views listing
Pages: [1]

Author Topic: CiviCRM not showing in Views listing  (Read 1100 times)

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
CiviCRM not showing in Views listing
September 03, 2011, 07:35:37 pm
I'm not seeing any CiviCRM Views available at all since I upgraded to Views 7.x-3.0-rc1. I've pasted the necessary lines into settings.php. Any ideas? I'm on D7.7 and CiviCRM 4.05.


Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: CiviCRM not showing in Views listing
September 04, 2011, 06:45:49 am
Did you refresh all caches in Drupal and also refresh the Views cache separately? You must go to Views -- Advanced or some such and find the button there to refresh Views cache.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: CiviCRM not showing in Views listing
September 06, 2011, 08:37:57 am
Yes, I had flushed caches in both places. I just did that again, but still no CiviCRM views in the listing.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: CiviCRM not showing in Views listing
September 06, 2011, 10:17:31 am
Did you have it before you upgraded? Can you post your code from settings.php?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: CiviCRM not showing in Views listing
September 08, 2011, 12:52:47 pm
I'm almost positive I had it before upgrade, but unfortunately I can't confirm that now. The upgrade was done in conjunction with a site move to another host.

The (sanitized) settings.php code is pasted below. It was copied/pasted right from the system page that provided it.

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

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


m.e.

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.0.9
  • CMS version: Drupal 7.9
Re: CiviCRM not showing in Views listing
September 28, 2011, 10:57:14 am
This was a false alarm - apologies. For some reason the CiviCRM views that were in my Views List before my upgrade / move had disappeared. However, I've just realized they are still there in the background and can be re-added, so the connection to CiviCRM isn't broken after all.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM not showing in Views listing

This forum was archived on 2017-11-26.