CiviCRM Community Forums (archive)

Hello.

Could someone please allow Views 2 admin access to address:

http://drupal.demo.civicrm.org/admin/build/views

for 'demo' account?

Regards,
Danila

Sorry, Lobo, could you please update settings.php with database renaming patterns from .../civicrm/admin/setting/uf?reset=1

Otherwise the know error message appears:

user warning: Table 'drupal_demo.civicrm_relationship' doesn't exist query:
SELECT COUNT(*) FROM (SELECT civicrm_contact_civicrm_relationship_1.display_name AS civicrm_contact_civicrm_relationship_1_display_name, COUNT(DISTINCT(civicrm_relationship.id)) AS num_records
FROM civicrm_relationship civicrm_relationship
LEFT JOIN civicrm_contact civicrm_contact_civicrm_relationship ON civicrm_relationship.contact_id_a = civicrm_contact_civicrm_relationship.id
LEFT JOIN civicrm_contact civicrm_contact_civicrm_relationship_1 ON civicrm_relationship.contact_id_b = civicrm_contact_civicrm_relationship_1.id WHERE civicrm_relationship.relationship_type_id in ('4') GROUP BY civicrm_contact_civicrm_relationship_1_display_name
ORDER BY civicrm_contact_civicrm_relationship_1_display_name ASC ) count_alias in /var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/views/includes/view.inc on line 705.
Regards,
Danila