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

Table already exists, 1050 error when creating new custom data group, after renaming the old group

    Details

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

      Description

      Steps taken at demo.civicrm.org:

      – Created a custom data group called "Lots of participant fields"
      – Renamed that custom data group to "Lots of event fields" using the Settings interface
      – Tried to create a second custom data group for Participant contacts called "Lots of participant fields" and got the following error:

      Sorry. A non-recoverable error has occurred.

      Database Error Code: Table 'civicrm_value_1_lots_of_participant_fields' already exists, 1050

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -5
      [message] => DB Error: already exists
      [mode] => 16
      [debug_info] => CREATE TABLE civicrm_value_1_lots_of_participant_fields (
      `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
      `domain_id` int unsigned NOT NULL COMMENT 'Default Domain that this data belongs to',
      `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
      PRIMARY KEY ( id ),
      UNIQUE INDEX unique_domain_id_entity_id ( domain_id, entity_id ),
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_domain_id FOREIGN KEY ( `domain_id` ) REFERENCES civicrm_domain ( id ) ,
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_participant ( id ) ON DELETE CASCADE
      ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1050 ** Table 'civicrm_value_1_lots_of_participant_fields' already exists]
      [type] => DB_Error
      [user_info] => CREATE TABLE civicrm_value_1_lots_of_participant_fields (
      `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
      `domain_id` int unsigned NOT NULL COMMENT 'Default Domain that this data belongs to',
      `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
      PRIMARY KEY ( id ),
      UNIQUE INDEX unique_domain_id_entity_id ( domain_id, entity_id ),
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_domain_id FOREIGN KEY ( `domain_id` ) REFERENCES civicrm_domain ( id ) ,
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_participant ( id ) ON DELETE CASCADE
      ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1050 ** Table 'civicrm_value_1_lots_of_participant_fields' already exists]
      [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE civicrm_value_1_lots_of_participant_fields (
      `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
      `domain_id` int unsigned NOT NULL COMMENT 'Default Domain that this data belongs to',
      `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
      PRIMARY KEY ( id ),
      UNIQUE INDEX unique_domain_id_entity_id ( domain_id, entity_id ),
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_domain_id FOREIGN KEY ( `domain_id` ) REFERENCES civicrm_domain ( id ) ,
      CONSTRAINT FK_civicrm_value_1_lots_of_participant_fields_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_participant ( id ) ON DELETE CASCADE
      ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1050 ** Table 'civicrm_value_1_lots_of_participant_fields' already exists]"

        Attachments

          Activity

            People

            • Assignee:
              kiran.jagtap Kiran Jagtap
              Reporter:
              jesse_idc Jesse Mortenson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: