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}