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

MySQL upgrade script fails to ignore constraints

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.6
    • Fix Version/s: 1.6
    • Component/s: None
    • Labels:
      None

      Description

      The disabling of foreign key checks doesn't take effect on my version of MySQL (4.1.20-log for RHEL4). This causes the upgrade script to fail.

      Excerpt:
      /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

      – /*******************************************************
      – *
      – * Clean up the exisiting tables
      – *
      – *******************************************************/

      DROP TABLE IF EXISTS civicrm_accept_credit_card;
      DROP TABLE IF EXISTS civicrm_activity_type;

        Attachments

          Activity

            People

            • Assignee:
              sameermare Sameer Mare
              Reporter:
              davidstrauss David Strauss
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: