Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Won't Fix
-
Affects Version/s: 2.1.2
-
Fix Version/s: 2.2.0
-
Component/s: None
-
Labels:None
Description
I'm not entirely sure, but looking at the sql error, it looks like it's expecting the civicrm database to reside in the same database as drupal.
drupal reported error:
user warning: Table 'kids.civicrm_contact' doesn't exist query: SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name, civicrm_address.city AS civicrm_address_city, civicrm_address.country_id AS civicrm_address_country_id FROM civicrm_contact civicrm_contact LEFT JOIN civicrm_address civicrm_address ON civicrm_contact.id = civicrm_address.contact_id LIMIT 0, 10 in /usr/share/drupal/modules/views/includes/view.inc on line 723.
Backstory: I have installed the latest drupal, and views 2.1, i have 2 databases, one for drupal, and one for civicrm. My civicrm version is 2.1.1 I have downloaded the lastest svn of the drupal/modules directory from svn here:
http://svn.civicrm.org/civicrm/branches/v2.1/drupal/modules
I followed the directions to install the views integration from here:
http://forum.civicrm.org/index.php/topic,5410.0.html
Everything was working great, I started creating a new view, selected view type of contacts.
I selected the folowing things in the viewsUI
Arguments
CiviCRM Contact: Name
Fields
CiviCRM Contact: Name Name
CiviCRM Contact: City City
CiviCRM Contact: Country
everything else selected was default. i created a page view and tested it, I recieved the error above.
Am I correct in assuming that views needs civicrm to reside in the same database?