Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5033

INSTALLATION: mysql "DROP FOREIGN KEY' Not Found issue when upgrading

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 3.0
          • Fix Version/s: 3.0
          • Component/s: Core CiviCRM
          • Labels:
            None

            Description

            Installation 3 beta 3 (and most likely beta2 and beta1)

            when running civicrm/upgrade/index.php to upgrade a site, receive error: DB Error: Can't drop 'FK_civicrm_activity_source_contact_id'l check the key/column exists.

            Another user at the dev camp also had this issue.

            SUGGESTION:

            For all dropping of tables/keys, use mysql IF EXISTS which will not fire an error if the key/table/index is not there.
            The script should continue running in this case since most likely a previous script already deleted the constraint.

              Attachments

                Activity

                  People

                  • Assignee:
                    rajan Rajan P Mayekar
                    Reporter:
                    stantale Sacha Stanton
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: