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

4.0 => 4.3 upgrade fails: Unknown column 'civicrm_dedupe_rule_group.used'

    Details

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

      Description

      Observed using civicrm-upgrade-test with 4.0.0-setupsh.sql.bz2.

      ----------------

      PEAR_Exception: "DB Error: no such field"

      • ERROR TYPE: DB_Error
      • ERROR CODE: -19
      • ERROR MESSAGE: DB Error: no such field
      • ERROR MODE: 16
      • ERROR USERINFO: SELECT *
        FROM civicrm_dedupe_rule_group

      WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.used = 'Unsupervised' )

      [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.used' in 'where clause']

      • ERROR DEBUGINFO: SELECT *
        FROM civicrm_dedupe_rule_group

      WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.used = 'Unsupervised' )

      [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.used' in 'where clause']
      #0 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
      #1 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #2 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT * \n
      #3 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT * \n FROM civicrm_dedupe_rule_grou
      #4 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT * \n FROM civicrm_dedupe_ru
      #5 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm
      #6 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
      #7 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT * \n FROM civicrm_dedupe_rule_group \n \n WHE
      #8 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT * \n FROM civicrm_dedupe_rule_group \n \n WHER
      #9 /Applications/MAMP/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(441): DB_DataObject->_query("SELECT * \n FROM civicrm_dedupe_rule_group \n \n
      #10 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Dedupe/BAO/Rule.php(199): DB_DataObject->find(TRUE)
      #11 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Event/BAO/Participant.php(656): CRM_Dedupe_BAO_Rule::dedupeRuleFields((Array:2))
      #12 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Event/BAO/Query.php(48): CRM_Event_BAO_Participant::importableFields("Individual", TRUE, FALSE)
      #13 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Event/BAO/Query.php(41): CRM_Event_BAO_Query::getParticipantFields()
      #14 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Core/Component.php(215): CRM_Event_BAO_Query::getFields()
      #15 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php(357): CRM_Core_Component::getQueryFields()
      #16 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php(2672): CRM_Core_BAO_UFGroup::getFields("3", FALSE, NULL, NULL, NULL, TRUE, NULL
      #17 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/ThreeFour.php(141): CRM_Core_BAO_UFGroup::calculateGroupType("3", TRUE)
      #18 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php(556): CRM_Upgrade_Incremental_php_ThreeFour->upgrade_3_4_3("3.4.3")
      #19 [internal function](): CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), "3.4.3", "3.4.0", "4.3.alpha1", "/private/var/folders/8_/x1
      #20 /Applications/MAMP/htdocs/sites/all/modules/civicrm/CRM/Queue/Task.php(79): call_user_func_array((Array:2), (Array:5))

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kurund Kurund Jalmi
                Reporter:
                timotten Tim Otten
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: