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]"