From a1005585f25d2064dcd54a5857aac031ab03ecbe Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Tue, 9 Apr 2013 15:30:45 -0700 Subject: [PATCH] Fix event contribution_type FK error CRM-12312 --- CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl index d5c0b9d0e1..65dbcf0f16 100644 --- a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl @@ -291,7 +291,10 @@ ALTER TABLE `civicrm_financial_item` ALTER TABLE `civicrm_entity_financial_trxn` DROP currency; --- CRM 9189 and CRM-8425 change fk's to financial_account.id in our branch that will need to be changed to an fk to financial_type.id +-- CRM-12312 +UPDATE civicrm_event SET contribution_type_id = NULL WHERE contribution_type_id = 0; + +-- CRM-9189 and CRM-8425 change fk's to financial_account.id in our branch that will need to be changed to an fk to financial_type.id ALTER TABLE `civicrm_pledge` DROP FOREIGN KEY FK_civicrm_pledge_contribution_type_id, -- 2.25.1