CiviCRM Community Forums (archive)

We have upgraded an existing test environment to 3.3 Alpha2 and then to 3.3 Beta 1.

Since installing Alpha 2, when ever I create a custom data field, this error is generated, even when it is the first custom data field being defined for a set.

The error is:
Sorry. A non-recoverable error has occurred.

--------------------------------------------------------------------------------

DB Error: already exists
Error Details
Database Error Code: Table 'log_civicrm_value_wca_11' already exists, 1050
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => CREATE TABLE `log_civicrm_value_wca_11` (
  `id` int(10) unsigned NOT NULL COMMENT 'Default MySQL primary key',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Table that this extends',
  `wca_associate_member_48` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wca_audit_committee_49` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wca_capital_projects_commission_50` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wca_conference_program__planning_51` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

Question:

Is the result of installing the Alpa 2?
Should we dump all data and start over?
Or should I file an issue?

D


Argh, I guess your database is not called ‘civicrm’. Fixed in r30716, will be fixed in 3.3.beta2 (and you can apply that patch to your install as well).

The patch worked for that specific error, but another one has emerged.  when I go back into a custom field to change the Check Box on Colapse on display on or off for any type of custom field, genreates another DB Error, but not able to display Details.

Joomla Administrator
CiviCRM
Admin
Customize
Custom Data
More, Settings (on an existing Custom Data Set)
Take Check Mark Off, or, Put Check Mark on "Collapse this set on initial display?"
Click on save

(we have already installed one patch)

Sorry. A non-recoverable error has occurred.

--------------------------------------------------------------------------------

DB Error: already exists
Error Details
Database Error Code: Duplicate entry 'Contact' for key 'UI_name_extends', 1062Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_custom_group  SET name = '' , title = 'GHT' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Inline' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 2 , is_active = 1 , is_multiple = 0 , max_multiple = NULL , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 9 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_custom_group  SET name = '' , title = 'GHT' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Inline' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 2 , is_active = 1 , is_multiple = 0 , max_multiple = NULL , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 9 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_custom_group  SET name = '' , title = 'GHT' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Inline' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 2 , is_active = 1 , is_multiple = 0 , max_multiple = NULL , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 9 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']"]
)



Return to home page.


This is still happening with Beta 2.

Dallas

Will try it.

Here is the error from our Joomla install. I have tested this on 2 separate systems with the same results.

Sorry. A non-recoverable error has occurred.

What happened was is that I created a custom data set and didn't like the way I had it configured for data types. The field name was Classifier History.

So I created a new set called called Classifier History Log, created all the data fields as Select. Once I was sure I had recreated all field names, I went back and deleted all fields in Classifier History, then I deleted Classifier History. On the new data set, I only used the label Classifier History Log as a temp name, planning on going back and renaming it to Classifier History, which cuases the result below.

I can not find Classifier History (through the Civi UI) label used any where else.

--------------------------------------------------------------------------------

DB Error: already exists
Error Details
Database Error Code: Duplicate entry 'Contact' for key 'UI_name_extends', 1062
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_custom_group  SET name = '' , title = 'Classifier History' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Tab' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 14 , is_active = 1 , is_multiple = 1 , max_multiple = 99999 , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 40 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_custom_group  SET name = '' , title = 'Classifier History' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Tab' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 14 , is_active = 1 , is_multiple = 1 , max_multiple = 99999 , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 40 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_custom_group  SET name = '' , title = 'Classifier History' , extends = 'Contact' , extends_entity_column_value = NULL , style = 'Tab' , collapse_display = 0 , help_pre = '' , help_post = '' , weight = 14 , is_active = 1 , is_multiple = 1 , max_multiple = 99999 , collapse_adv_display = 0   WHERE (  civicrm_custom_group.id = 40 )   [nativecode=1062 ** Duplicate entry 'Contact' for key 'UI_name_extends']"]
)


Return to home page.


For what it’s worth, note that this issue was fixed after 3.3.beta2 (but should be fixed in 3.3.beta3).

Just updated B3 - confirmed fixed.

Thanks!

D