Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-3844

Drupal Views 2 integration sql bug, seperate database issue?

    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?

        Attachments

          Activity

            People

            • Assignee:
              mover Michał Mach
              Reporter:
              james.nadeau James Nadeau
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: