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

Profile Search using Country, State fails

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.4.0, 4.4.1
          • Fix Version/s: 4.4.1
          • Component/s: CiviCRM Profile
          • Labels:

            Description

            Public Profiles searching by Country, State, County, or a combination produce a "No Such Field" DB Error when fields are set as Primary. This is reproducible on 4.4.0 on J2.5 and on the demo server with 4.4.1 for Joomla and Drupal.

            Detailed debug shows
            Database Error Code: Unknown column 'civicrm_address.country_id' in 'where clause', 1054. civicrm_address is not being included in the FROM clause of the query. Adding civicrm_address to $this->_tables in CRM/Contact/BAO/Query::initialize() prior to the fromClause() call resolves the issue, but attempts to debug from the fromClause() method produce a WSOD.

              Attachments

                Activity

                  People

                  • Assignee:
                    pratik.joshi Pratik Joshi
                    Reporter:
                    jproffitt Jeremy Proffitt
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: