· 8 years ago · Mar 30, 2018, 10:52 PM
1#0 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(187): CRM_Core_Error::backtrace()
2#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
3#2 /var/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
4#3 /var/www/administrator/components/com_civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: already exists", -5, 16, (Array:2), "INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...")
5#4 /var/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB _Error->__construct(-5, 16, (Array:2), "INSERT INTO civicrm_custom_group ( table_name ) VALUES ('civicrm_value_multipl...")
6#5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -5, NULL, NULL, "INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...", "DB_Error", TRUE)
7#6 /var/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
8#7 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->__call("raiseError", (Array:7))
9#8 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -5, NULL, NULL, "INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...", "DB_Error", TRUE)
10#9 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-5, NULL, NULL, NULL, "1062 ** Duplicate entry '0' for key 'PRIMARY'")
11#10 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
12#11 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...")
13#12 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2438): DB_common->query("INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...")
14#13 /var/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multipl...")
15#14 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(482): DB_DataObject->insert()
16#15 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1112): CRM_Core_DAO->save()
17#16 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomGroup.php(195): CRM_Core_ DAO::setFieldValue("CRM_Core_DAO_CustomGroup", 0, "table_name", "civicrm_value_multiples_of_12_12_0")
18#17 /var/www/administrator/components/com_civicrm/civicrm/CRM/Custom/Form/Group.php(455): CRM_Core_BAO_CustomGroup::create((Array:16))
19#18 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(431): CRM_Custom_Form_Group->postProcess()
20#19 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
21#20 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Custom_Form_Group), "next", "Next")
22#21 /var/www/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Custom_Form_Group), "next")
23#22 /var/www/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Custom_Form_Group), "next")
24#23 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
25#24 /var/www/administrator/components/com_civicrm/civicrm/CRM/Custom/Page/Group.php(172): CRM_Core_Controller->run()
26#25 /var/www/administrator/components/com_civicrm/civicrm/CRM/Custom/Page/Group.php(139): CRM_Custom_Page_Group->edit(NULL, 1)
27#26 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Custom_Page_Group->run((Array:4), NULL)
28#27 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:13))
29#28 /var/www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
30#29 /var/www/administrator/components/com_civicrm/civicrm.php(121): CRM_Core_Invoke::invoke((Array:4))
31#30 /var/www/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()
32#31 /var/www/libraries/cms/component/helper.php(405): require_once("/var/www/administrator/components/com_civicrm/civicrm.php")
33#32 /var/www/libraries/cms/component/helper.php(380): JComponentHelper::executeComponent("/var/www/administrator/components/com_civicrm/civicrm.php")
34#33 /var/www/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent("com_civicrm")
35#34 /var/www/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch()
36#35 /var/www/libraries/cms/application/cms.php(257): JApplicationAdministrator->doExecute()
37#36 /var/www/administrator/index.php(51): JApplicationCms->execute()
38#37 {main}
39 Sorry but we are not able to provide this at the moment.
40DB Error: already exists
41Error Details
42Database Error Code: Duplicate entry '0' for key 'PRIMARY', 1062
43Additional Details:
44Array
45(
46 [callback] => Array
47 (
48 [0] => CRM_Core_Error
49 [1] => handle
50 )
51
52 [code] => -5
53 [message] => DB Error: already exists
54 [mode] => 16
55 [debug_info] => INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multiples_of_12_12_0' ) [nativecode=1062 ** Duplicate entry '0' for key 'PRIMARY']
56 [type] => DB_Error
57 [user_info] => INSERT INTO civicrm_custom_group (table_name ) VALUES ('civicrm_value_multiples_of_12_12_0' ) [nativecode=1062 ** Duplicate entry '0' f or key 'PRIMARY']
58 [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_custom _group (table_name ) VALUES ('civicrm_value_multiples_of_12_12_0' ) [nativecode=1062 ** Duplicate entry '0' for key 'PRIMARY']"]
59)
60
61CREATE TABLE `civicrm_custom_group`
62(
63 `id` INT(10) UNSIGNED NOT NULL comment 'Unique Custom Group ID',
64 `name` VARCHAR(64) collate utf8_unicode_ci DEFAULT NULL comment 'Variable name/programmatic handle for this group.',
65 `title` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL comment 'Friendly Name.',
66 `extends` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT 'Contact' comment 'Type of object this group extends (can add other options later e.g. contact_address, etc.).',
67 `extends_entity_column_id` INT(10) UNSIGNED DEFAULT NULL comment 'FK to civicrm_option_value.id (for option group custom_data_type.)',
68 `extends_entity_column_value` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL comment 'linking custom group for dynamic object.',
69 `style` VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL comment 'Visual relationship between this form and its parent.',
70 `collapse_display` INT(10) UNSIGNED DEFAULT '0' comment 'Will this group be in collapsed or expanded mode on initial display ?',
71 `help_pre` text COLLATE utf8_unicode_ci comment 'Description and/or help text to display before fields in form.',
72 `help_post` text COLLATE utf8_unicode_ci comment 'Description and/or help text to display after fields in form.',
73 `weight` INT(11) NOT NULL DEFAULT '1' comment 'Controls display order when multiple extended property groups are setup for the same class.',
74 `is_active` TINYINT(4) DEFAULT NULL comment 'Is this property active?',
75 `table_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL comment 'Name of the table that holds the values for this group.',
76 `is_multiple` TINYINT(4) DEFAULT NULL comment 'Does this group hold multiple values?',
77 `min_multiple` INT(10) UNSIGNED DEFAULT NULL comment 'minimum number of multiple records (typically 0?)',
78 `max_multiple` INT(10) UNSIGNED DEFAULT NULL comment 'maximum number of multiple records, if 0 - no max',
79 `collapse_adv_display` INT(10) UNSIGNED DEFAULT '0' comment 'Will this group be in collapsed or expanded mode on advanced search display ?',
80 `created_id` INT(10) UNSIGNED DEFAULT NULL comment 'FK to civicrm_contact, who created this custom group',
81 `created_date` datetime DEFAULT NULL comment 'Date and time this custom group was created.',
82 `is_reserved` TINYINT(4) DEFAULT NULL,
83 `is_public` TINYINT(1) DEFAULT '1' comment 'Is this property public?',
84 PRIMARY KEY (`id`),
85 UNIQUE KEY `ui_name_extends` (`name`,`extends`),
86 UNIQUE KEY `ui_title_extends` (`title`,`extends`),
87 KEY `fk_civicrm_custom_group_created_id` (`created_id`)
88 )
89 engine=innodb DEFAULT charset=utf8 COLLATE=utf8_unicode_ci
90
91CREATE TABLE `civicrm_custom_group` (
92`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Custom Group ID',
93`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Variable name/programmatic handle for this group.',
94`title` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Friendly Name.',
95`extends` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'Contact' COMMENT
96'Type of object this group extends (can add other options later e.g. contact_address, etc.).',
97`extends_entity_column_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.id (for option group custom_data_type.)',
98`extends_entity_column_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'linking custom group for dynamic object',
99`style` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Visual relationship between this form and its parent.',
100`collapse_display` int(10) unsigned DEFAULT '0' COMMENT 'Will this group be in collapsed or expanded mode on initial display ?',
101`help_pre` text COLLATE utf8_unicode_ci COMMENT 'Description and/or help text to display before fields in form.',
102`help_post` text COLLATE utf8_unicode_ci COMMENT 'Description and/or help text to display after fields in form.',
103`weight` int(11) NOT NULL DEFAULT '1' COMMENT 'Controls display order when multiple extended property groups are setup for the same class.',
104`is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this property active?',
105`table_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Name of the table that holds the values for this group.',
106`is_multiple` tinyint(4) DEFAULT NULL COMMENT 'Does this group hold multiple values?',
107`min_multiple` int(10) unsigned DEFAULT NULL COMMENT 'minimum number of multiple records (typically 0?)',
108`max_multiple` int(10) unsigned DEFAULT NULL COMMENT 'maximum number of multiple records, if 0 - no max',
109`collapse_adv_display` int(10) unsigned DEFAULT '0' COMMENT 'Will this group be in collapsed or expanded mode on advanced search display ?',
110`created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this custom group',
111`created_date` datetime DEFAULT NULL COMMENT 'Date and time this custom group was created.',
112`is_reserved` tinyint(4) DEFAULT '0' COMMENT 'Is this a reserved Custom Group?',
113`is_public` tinyint(4) DEFAULT '1' COMMENT 'Is this property public?',
114PRIMARY KEY (`id`),
115UNIQUE KEY `UI_title_extends` (`title`,`extends`),
116UNIQUE KEY `UI_name_extends` (`name`,`extends`),
117KEY `FK_civicrm_custom_group_created_id` (`created_id`),
118CONSTRAINT `FK_civicrm_custom_group_created_id` FOREIGN KEY (`created_id`)
119REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;