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 Bug
    • Status: Closed
    • Priority: Minor 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]"

        Activity

        Hide
        Donald A. Lobo added a comment -

        good catch jesse :)
        Show
        Donald A. Lobo added a comment - good catch jesse :)
        Hide
        Kiran Jagtap added a comment -
        Tested and Confirmed for 2.1 ( r - 16234 )
        Show
        Kiran Jagtap added a comment - Tested and Confirmed for 2.1 ( r - 16234 )

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development