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

Multilingual bug on dedupe_group_rules table

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.1
    • Fix Version/s: 4.2.2
    • Component/s: None
    • Labels:
      None

      Description

      I'm getting a mysql error when trying to save a dedupe rule - the problem is that the title field id multilingual (title_US) but the query isn't.

      Sep 27 08:49:30 [info] $SELECT *
      FROM civicrm_dedupe_rule_group

      WHERE ( civicrm_dedupe_rule_group.title = 'kk' )

      = #0 /var/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(448): CRM_Core_Error::backtrace("SELECT * \n FROM civicrm_dedupe_rule_group \n \n WHERE ( civicrm_dedupe_rule...", TRUE)
      #1 /var/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2359): CRM_Core_Error::debug_query("SELECT * \n FROM civicrm_dedupe_rule_group \n \n WHERE ( civicrm_dedupe_rule...")
      #2 /var/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(441): DB_DataObject->_query("SELECT * \n FROM civicrm_dedupe_rule_group \n \n WHERE ( civicrm_dedupe_rule...")
      #3 /var/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(494): DB_DataObject->find(TRUE)
      #4 /var/www/www/sites/all/modules/civicrm/CRM/Utils/Rule.php(484): CRM_Core_DAO::objectExists("kk", "CRM_Dedupe_DAO_RuleGroup", "7", "title")
      #5 [internal function](): CRM_Utils_Rule::objectExists("kk", (Array:3))
      #6 /var/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Rule/Callback.php(77): call_user_func((Array:2), "kk", (Array:3))
      #7 /var/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/RuleRegistry.php(158): HTML_QuickForm_Rule_Callback->validate("kk", (Array:3))
      #8 /var/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm.php(1582): HTML_QuickForm_RuleRegistry->validate("objectExists", "kk", (Array:3), FALSE)
      #9 /var/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(301): HTML_QuickForm->validate()
      #10 /var/www/www/sites/all/modules/civicrm/CRM/Core/StateMachine.php(141): CRM_Core_Form->validate()
      #11 /var/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Form_DedupeRules), "next", "Next")
      #12 /var/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Form_DedupeRules), "next")
      #13 /var/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_DedupeRules), "next")
      #14 /var/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("next")
      #15 /var/www/www/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(378): CRM_Core_Controller->run()
      #16 /var/www/www/sites/all/modules/civicrm/CRM/Contact/Page/DedupeRules.php(133): CRM_Core_Page_Basic->edit(2, "7")
      #17 /var/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(228): CRM_Contact_Page_DedupeRules->run((Array:3), NULL)
      #18 /var/www/www/sites/all/modules/civicrm/drupal/civicrm.module(500): CRM_Core_Invoke::invoke((Array:3))
      #19 [internal function](): civicrm_invoke("contact", "deduperules")
      #20 /var/www/www/includes/menu.inc(516): call_user_func_array("civicrm_invoke", (Array:2))
      #21 /var/www/www/index.php(21): menu_execute_active_handler()

        Attachments

          Activity

            People

            • Assignee:
              mlutfy Mathieu Lutfy
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: