CiviCRM Community Forums (archive)

My uprgade fails on the same issue each time. I tried to upgrade to 4.3.1 and 4.3.2.

Any ideas

Majo

CiviCRM Upgrade Tasks
[Error: Upgrade DB to 4.3.alpha1]
Error Field Error Value
Type DB_Error
Code -1
Message DB Error: unknown error
Mode 16
UserInfo ALTER TABLE civicrm_membership_type DROP FOREIGN KEY FK_civicrm_membership_autorenewal_msg_id [nativecode=1025 ** Error on rename of './chautaar_chautaardr7_crm/civicrm_membership_type' to './chautaar_chautaardr7_crm/#sql2-3003-27ab9ed' (errno: 152)]
DebugInfo ALTER TABLE civicrm_membership_type DROP FOREIGN KEY FK_civicrm_membership_autorenewal_msg_id [nativecode=1025 ** Error on rename of './chautaar_chautaardr7_crm/civicrm_membership_type' to './chautaar_chautaardr7_crm/#sql2-3003-27ab9ed' (errno: 152)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
# Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
1 call_user_func(Array, Object(DB_Error)) /home/chautaar/public_html/sites/all/modules/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB.php:969
3 DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -1, null, null, 'ALTER TABLE civi…', 'DB_Error', true) /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/common.php:1905
5 DB_common->raiseError(-1, null, null, null, '1025 ** Error on…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery('ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/common.php:1216
8 DB_common->query('ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9 DB_DataObject->_query('ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10 DB_DataObject->query('ALTER TABLE civi…') /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11 CRM_Core_DAO->query('ALTER TABLE civi…', false) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:917
12 CRM_Core_DAO::executeQuery('ALTER TABLE civi…', Array, true, null, false, false) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:779
13 CRM_Upgrade_Incremental_php_FourThree->task_4_3_alpha1_checkDBConstraints() /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:193
14 CRM_Upgrade_Incremental_php_FourThree->upgrade_4_3_alpha1('4.3.alpha1') /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php:570
15 CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.3.alpha1', '4.2.7', '4.3.2', '/tmp/civicrm-pos…') unknown:unknown
16 call_user_func_array(Array, Array) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Queue/Task.php:79
17 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
18 CRM_Queue_Runner->runNext(true) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
19 {closure}() /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
20 CRM_Queue_ErrorPolicy->call(Object(Closure)) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
21 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
22 call_user_func(Array, Array) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
23 CRM_Core_Invoke::runItem(Array) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
24 CRM_Core_Invoke::_invoke(Array) /home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
25 CRM_Core_Invoke::invoke(Array) /home/chautaar/public_html/sites/all/modules/civicrm/drupal/civicrm.module:436
26 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') unknown:unknown
27 call_user_func_array('civicrm_invoke', Array) /home/chautaar/public_html/includes/menu.inc:517
28 menu_execute_active_handler() /home/chautaar/public_html/index.php:21

Lobo,

I never used any autorenewal templates and all values in the dbase are set to NULL, does it means i first have to make a template and then assign all memebershiptypes to this template? Even if i don't want to use the autorenewal function in the future?

I upload a screenshot of the dabase civicrm.membership.type table

Majo

I just duplicated my error and it seems it is with a different table but the rest is the same, EXCEPT mine is with Joomla 

ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 [nativecode=1025 ** Error on rename of './my-site/civicrm_financial_trxn' to './my-site/#sql2-ae83-15a4' (errno: 152)]

I don't know what to think of that ticket Eileen.

However, I did find the nifty "skip" button, skipped it and got a green check mark.

Am I out of the woods??

Lots of reading -- lots of head scratching

I looked at the db within TextWrangler and searched for civicrm_financial_trxn_ibfk_2 but it doesn't exist, just as in that other thread, http://forum.civicrm.org/index.php/topic,28453.45.html

Now I have quite a number of db backups, but none that are just the schema. But at quick check, I still do not have ibfk_2 anywhere so I am wondering....

When the next upgrade occurs, will I get the same error? I may have to wait and see. 

I just checked the db in the text editor and see this info so it looks like I do have FKs:

-- Create Table `civicrm_financial_trxn`
--

DROP TABLE IF EXISTS `civicrm_financial_trxn`;
CREATE TABLE `civicrm_financial_trxn` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Gift ID',
  `from_account_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to financial_account table.',
  `to_account_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to financial_account table.',
  `trxn_date` datetime NOT NULL,
  `trxn_type` enum('Debit','Credit') COLLATE utf8_unicode_ci NOT NULL,
  `total_amount` decimal(20,2) NOT NULL COMMENT 'amount of transaction',
  `fee_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual processor fee if known - may be 0.',
  `net_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.',
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `payment_processor` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'derived from Processor setting in civicrm.settings.php.',
  `trxn_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'unique processor transaction id, bank id + trans id,... depending on payment_method',
  `trxn_result_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'processor result code',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_ft_trxn_id` (`trxn_id`),
  KEY `FK_civicrm_financial_trxn_from_account_id` (`from_account_id`),
  KEY `FK_civicrm_financial_trxn_to_account_id` (`to_account_id`),
  CONSTRAINT `FK_civicrm_financial_trxn_from_account_id` FOREIGN KEY (`from_account_id`) REFERENCES `civicrm_financial_account` (`id`),
  CONSTRAINT `FK_civicrm_financial_trxn_to_account_id` FOREIGN KEY (`to_account_id`) REFERENCES `civicrm_financial_account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Data for Table `civicrm_financial_trxn`

Eileen, I am not quite getting this. I will looks at a bunch of backups to see if it clicks.

Thanks Eileen. This got me thinking and I was able to solve my problem which was multi-fold. My live site was fine but my localhost was messed up and in the process of correction due to outdated mysql. I had restored my local database with my live database backups but this didn't fix the problem. What I had to do was CLEAR the local database and THEN restore in order to clear out all the old garbage.

Can't have enough backups!!