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) »
  • Empty Views
Pages: [1]

Author Topic: Empty Views  (Read 637 times)

fairtrademusic

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6.26
  • MySQL version: 5.0.95
  • PHP version: 5.2.17
Empty Views
October 19, 2012, 05:47:11 pm
I have set up settings.php with the appropriate info but can't seem to get views to display any contact info.

No error messages (they used to be there but settings.php fixed that)


My settings.php looks like this

$db_url = 'mysql://actual login info@localhost/fairtrad_fairtrade';
$db_prefix = '';


$db_prefix = array(
  'civicrm_acl'                              => '`fairtrad_ftmcrm`.',
  'civicrm_acl_cache'                        => '`fairtrad_ftmcrm`.',
  'civicrm_acl_contact_cache'                => '`fairtrad_ftmcrm`.',
  'civicrm_acl_entity_role'                  => '`fairtrad_ftmcrm`.',
etc. . . .

Do I need to add the $db_url for the Civicrm database?

D6.26, civicrm 3.4.7

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Empty Views
October 20, 2012, 01:16:03 pm
Quote from: fairtrademusic on October 19, 2012, 05:47:11 pm
Do I need to add the $db_url for the Civicrm database?

No, but the user/password used for the Drupal DB must also work to connect to the CiviCRM DB.

If that's the case already, then can you make a view with Contacts and see the SQL the Views is running and post that?
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.

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

This forum was archived on 2017-11-26.