Author Topic: Upgrade from 4.1.2 to 4.2.1 is failing due to failure on ALTER TABLE (Read 603 times)

SarahG (FountainTribe) · September 22, 2012, 10:44:03 am

I am attempting to upgrade a 4.1.2 environment to 4.2.1. But it fails when trying to execute the SQL statement:

ALTER TABLE civicrm_contribution_page DROP INDEX FK_civicrm_contribution_page_payment_processor_id

Output from CiviCRM:

Type   DB_Error
Code   a515ac9c2796ca0e23adbe92c68fc9fc
Message   DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Mode   16
UserInfo   ALTER TABLE civicrm_contribution_page DROP INDEX FK_civicrm_contribution_page_payment_processor_id [nativecode=1025 ** Error on rename of './pogstone_crm/#sql-854_73c91' to './pogstone_crm/civicrm_contribution_page' (errno: 150)]
DebugInfo   ALTER TABLE civicrm_contribution_page DROP INDEX FK_civicrm_contribution_page_payment_processor_id [nativecode=1025 ** Error on rename of './pogstone_crm/#sql-854_73c91' to './pogstone_crm/civicrm_contribution_page' (errno: 150)]

This occurs during step: Error: Upgrade DB to 4.2.alpha1, called from "CRM_Upgrade_Incremental_php_FourTwo->upgrade_4_2_alpha1('4.2.alpha1') "

Hershel · September 22, 2012, 02:07:13 pm

One way to handle this is to find that code, comment it out, and then manually drop the index in the DB, and then rerun the upgrader, all on the original DB of course.

CiviCRM Community Forums (archive)

News:

Author Topic: Upgrade from 4.1.2 to 4.2.1 is failing due to failure on ALTER TABLE (Read 603 times)

SarahG (FountainTribe)

Upgrade from 4.1.2 to 4.2.1 is failing due to failure on ALTER TABLE

Hershel

Re: Upgrade from 4.1.2 to 4.2.1 is failing due to failure on ALTER TABLE