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

Upgrading with drush fails - sql appears not to have run

    Details

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

      Description

      Running Upgrade using DRUSH I get the below CORE error. The task of running the 4.3 mysql is not in the queue now but the sql withing 4.3.alpha.1.mysql.tpl does not appear to have run (ie. ALTER TABLE `civicrm_premiums`
      ADD COLUMN `premiums_nothankyou_position` int(10) unsigned DEFAULT '1'; has not happened) nor has any change to the msg_templates.

      (note that the customer would probably be willing to share a copy of the DB but I have pretty much exhausted the 3 hours they allocated to upgrade to 4.3 so they could take part in the bug hunt - UI upgrade got further but didn't complete - I haven't determined why)

      Mar 18 12:32:25 [info] PEAR_Exception: "DB Error: no such table"

      • ERROR TYPE: DB_Error
      • ERROR CODE: -18
      • ERROR MESSAGE: DB Error: no such table
      • ERROR MODE: 16
      • ERROR USERINFO: SELECT id, name FROM civicrm_financial_type
        WHERE name IN ('Donation', 'Event Fee', 'Member Dues'); [nativecode=1146 ** Table 'mydb.civicrm_financial_type' doesn't exist]
      • ERROR DEBUGINFO: SELECT id, name FROM civicrm_financial_type
        WHERE name IN ('Donation', 'Event Fee', 'Member Dues'); [nativecode=1146 ** Table 'mydb.civicrm_financial_type' doesn't exist]
        #0 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
        #1 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
        #2 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #3 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #4 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...", "DB_Error", TRUE)
        #5 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'mydb.civicrm_financial_type' doesn't exist")
        #6 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
        #7 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #8 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #9 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #10 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #11 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...", TRUE)
        #12 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php(202): CRM_Core_DAO::executeQuery("SELECT id, name FROM civicrm_financial_type\n WHERE name IN ('Donation', 'Eve...")
        #13 [internal function](): CRM_Upgrade_Incremental_php_FourThree::assignFinancialTypeToPriceRecords(Object(CRM_Queue_TaskContext))
        #14 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Queue/Task.php(79): call_user_func_array((Array:2), (Array:1))
        #15 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Queue/Runner.php(186): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
        #16 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Queue/Runner.php(148): CRM_Queue_Runner->runNext()
        #17 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/CRM/Upgrade/Headless.php(65): CRM_Queue_Runner->runAll()
        #18 /var/www/mysite/mysite.com/sites/mysite.com/modules/civicrm/drupal/drush/civicrm.drush.inc(519): CRM_Upgrade_Headless->run()
        #19 [internal function](): drush_civicrm_upgrade_db()
        #20 /usr/share/php/drush/includes/command.inc(324): call_user_func_array("drush_civicrm_upgrade_db", (Array:0))
        #21 /usr/share/php/drush/includes/command.inc(198): _drush_invoke_hooks("civicrm-upgrade-db", (Array:0), "civicrm")
        #22 [internal function](): drush_command()
        #23 /usr/share/php/drush/includes/command.inc(165): call_user_func_array("drush_command", (Array:0))
        #24 /usr/share/php/drush/drush.php(92): drush_dispatch((Array:27))
        #25 /usr/share/php/drush/drush.php(61): _drush_bootstrap_and_dispatch()
        #26 /usr/share/php/drush/drush.php(16): drush_main()
        #27 {main}

        Attachments

          Activity

            People

            • Assignee:
              joemurray Joe Murray
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: