CiviCRM Community Forums (archive)

Just upgraded from 1.9 and all seemed well.
I ran the longer upgrade process to make sure 1.9 was fine. Then ran the 2.0 upgrade in the browser and that worked well.
The site was working fine.
Then I upgrade to 2.1 (we need pledges)
First I got this error
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -4
    [message] => DB Error: not found
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
    DROP location_id [nativecode=1091 ** Can't DROP 'location_id'; check that column/key exists]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
    DROP location_id [nativecode=1091 ** Can't DROP 'location_id'; check that column/key exists]
    [to_string] => [db_error: message="DB Error: not found" code=-4 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
    DROP location_id [nativecode=1091 ** Can't DROP 'location_id'; check that column/key exists]"]
)
-------------------
I ran
ALTER TABLE `civicrm_group_contact` ADD `location_id` INT UNSIGNED NOT NULL COMMENT 'Optional location to associate with this membership' AFTER `status` ;
to see if I could cheat my way past this error but then got the error below....


Then ----
Error Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
    DROP location_id [nativecode=1025 ** Error on rename of './civicrm19Fix/civicrm_group_contact' to './civicrm19Fix/#sql2-1581-613' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
    DROP location_id [nativecode=1025 ** Error on rename of './civicrm19Fix/civicrm_group_contact' to './civicrm19Fix/#sql2-1581-613' (errno: 152)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_group_contact`
    DROP FOREIGN KEY `FK_civicrm_group_contact_location_id`,
-------------------------------------------------------end error
Any thoughts?
I will try again later.
Server version: 5.0.51a-3ubuntu5.2
PHP Version 5.2.4-2ubuntu5.3
??
Thanks
   [/code][/code]

Right, how did I run the civicrm19Fix from 1.9 to 2.0 then that worked great.
Then tested a bunch of contacts etc.
But then ran this and got the error.
I will try your suggestion. I am looking over the upgrade scripts and seeing what else I am missing.
Thanks

This is because when adding the column 'location_id' for the first time you made it "NOT NULL". And when you add FK constraint, since you not providing any values results in that error.
So first drop the column location_id and add it again (or modify) allowing it to have null values (use the query i pasted ).