CiviCRM Community Forums (archive)

Hi guys,

Upgrading from 4.2.9 to 4.3.0, I get the following error:

------ SNIP -------

[Error: Upgrade DB to 4.3.alpha1: SQL]
Error Field  Error Value
Type   DB_Error
Code   -5
Message   DB Error: already exists
Mode   16
UserInfo   ALTER TABLE civicrm_custom_field ADD UNIQUE INDEX `UI_name_custom_group_id` (`name`, `custom_group_id`) [nativecode=1062 ** Duplicate entry 'Please_describe_your_relevant_experiences_and_what_you_would_con' for key 'UI_name_custom_group_id']
DebugInfo   ALTER TABLE civicrm_custom_field ADD UNIQUE INDEX `UI_name_custom_group_id` (`name`, `custom_group_id`) [nativecode=1062 ** Duplicate entry 'Please_describe_your_relevant_experiences_and_what_you_would_con' for key 'UI_name_custom_group_id']
PEAR_Exception: DB Error: already exists in unknown on line unknown
- DB_Error: DB Error: already exists in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: alread…', -5, 16, Array, 'ALTER TABLE civi…')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-5, 16, Array, 'ALTER TABLE civi…')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -5, null, null, 'ALTER TABLE civi…', 'DB_Error', true)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-5, null, null, null, '1062 ** Duplicat…')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('ALTER TABLE civi…')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE civi…')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php:284
9   CRM_Utils_File::sourceSQLFile('mysql://root:wH0…', ' SELECT @wo…', null, true)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:159
10   CRM_Upgrade_Form->source(' SELECT @wo…', true)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:299
11   CRM_Upgrade_Form->processLocales('/srv/spacegenera…', '4.3.alpha1')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:323
12   CRM_Upgrade_Form->processSQL('4.3.alpha1')   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:880
13   CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), '4.3.alpha1')   unknown:unknown
14   call_user_func_array(Array, Array)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:258
21   CRM_Core_Invoke::runItem(Array)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:70
22   CRM_Core_Invoke::_invoke(Array)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/admin.civicrm.php:95
24   civicrm_invoke()   /srv/spacegeneration.org/public_html/administrator/components/com_civicrm/admin.civicrm.php:40
25   require_once('/srv/spacegenera…')   /srv/spacegeneration.org/public_html/libraries/joomla/application/component/helper.php:383
26   JComponentHelper::executeComponent('/srv/spacegenera…')   /srv/spacegeneration.org/public_html/libraries/joomla/application/component/helper.php:351
27   JComponentHelper::renderComponent('com_civicrm')   /srv/spacegeneration.org/public_html/administrator/includes/application.php:153
28   JAdministrator->dispatch()   /srv/spacegeneration.org/public_html/administrator/index.php:46
29   {main}   

--------- SNIP ---------

I have a database backup from before the change, but I really do want to figure out what is going wrong - as I need to upgrade our database to the newest version to handle a gamebreaking bug.

If anyone is able to help us out, that would be much appreciated.

emilevictor, your basic issue is:

Duplicate entry 'Please_describe_your_relevant_experiences_and_what_you_would_con' for key 'UI_name_custom_group_id']
Do you perchance have two custom fields both starting with Please_describe_your_relevant_experiences_and_what_you_would ?

LenInkster, your problem is different. Your upgrade is choking on this SQL:

ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2
and I would ask your host why that query is failing. Perhaps first check that the FK exists.