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

default dedupe rule with no fields causes error on contact edit/insert

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.1.2
    • Fix Version/s: 2.2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      In an effort to work around CRM-4124 I removed all fields from the default fuzzy rule. However if I now attempt to edit and save a contact I get the following error:

      backTrace

      /home/oa/production/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
      , handle,
      /home/oa/production/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
      /home/oa/production/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
      /home/oa/production/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
      /home/oa/production/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
      /home/oa/production/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
      /home/oa/production/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
      /home/oa/production/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
      /home/oa/production/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
      /home/oa/production/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1587
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 144
      /home/oa/production/sites/all/modules/civicrm/CRM/Dedupe/Finder.php, query, 97
      /home/oa/production/sites/all/modules/civicrm/CRM/Contact/Form/Individual.php, dupesByParams, 230
      , formRule,
      /home/oa/production/sites/all/modules/civicrm/packages/HTML/QuickForm.php, call_user_func, 1591
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/Form.php, validate, 290
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/StateMachine.php, validate, 148
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
      /home/oa/production/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
      /home/oa/production/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
      /home/oa/production/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 114
      /home/oa/production/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 169
      /home/oa/production/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315
      , civicrm_invoke,
      /home/oa/production/includes/menu.inc, call_user_func_array, 348
      /home/oa/production/index.php, menu_execute_active_handler, 18

      Error Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT id
      FROM dedupe JOIN civicrm_contact USING (id)
      WHERE contact_type = 'Individual'
      GROUP BY id HAVING SUM(weight) >= 13
      ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']
      [type] => DB_Error
      [user_info] => SELECT id
      FROM dedupe JOIN civicrm_contact USING (id)
      WHERE contact_type = 'Individual'
      GROUP BY id HAVING SUM(weight) >= 13
      ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id
      FROM dedupe JOIN civicrm_contact USING (id)
      WHERE contact_type = 'Individual'
      GROUP BY id HAVING SUM(weight) >= 13
      ORDER BY SUM(weight) desc [nativecode=1054 ** Unknown column 'id' in 'from clause']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              sunil Sunil Pawar
              Reporter:
              dalin dave hansen-lange
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: