CiviCRM Community Forums (archive)

Error: Upgrade DB to 4.2.alpha1: SQL]
Error Field   Error Value
Type   DB_Error
Code   -5
Message   DB Error: already exists
Mode   16
UserInfo   CREATE TABLE `civicrm_sms_provider` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'SMS Provider ID', `name` varchar(64) DEFAULT NULL COMMENT 'Provider internal name points to option_value of option_group sms_provider_name', `title` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Provider name visible to user', `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `api_type` int(10) unsigned NOT NULL COMMENT 'points to value in civicrm_option_value for group sms_api_type', `api_url` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `api_params` text COLLATE utf8_unicode_ci COMMENT 'the api params in xml, http or smtp format', `is_default` tinyint(4) DEFAULT '0', `is_active` tinyint(4) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 [nativecode=1050 ** Table 'civicrm_sms_provider' already exists]
DebugInfo   CREATE TABLE `civicrm_sms_provider` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'SMS Provider ID', `name` varchar(64) DEFAULT NULL COMMENT 'Provider internal name points to option_value of option_group sms_provider_name', `title` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Provider name visible to user', `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `api_type` int(10) unsigned NOT NULL COMMENT 'points to value in civicrm_option_value for group sms_api_type', `api_url` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `api_params` text COLLATE utf8_unicode_ci COMMENT 'the api params in xml, http or smtp format', `is_default` tinyint(4) DEFAULT '0', `is_active` tinyint(4) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 [nativecode=1050 ** Table 'civicrm_sms_provider' already exists]
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))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: alread…', -5, 16, Array, 'CREATE TABLE `ci…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB.php:968
3   DB_Error->DB_Error(-5, 16, Array, 'CREATE TABLE `ci…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -5, null, null, 'CREATE TABLE `ci…', 'DB_Error', true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/common.php:1903
5   DB_common->raiseError(-5, null, null, null, '1050 ** Table 'c…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('CREATE TABLE `ci…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('CREATE TABLE `ci…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Utils/File.php:287
9   CRM_Utils_File->sourceSQLFile('mysql://CiviCRM4…', ' SELECT @wo…', null, true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:152
10   CRM_Upgrade_Form->source(' SELECT @wo…', true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:292
11   CRM_Upgrade_Form->processLocales('/var/www/vhosts/…', '4.2.alpha1')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:316
12   CRM_Upgrade_Form->processSQL('4.2.alpha1')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:290
13   CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_runSql(Object(CRM_Queue_TaskContext), '4.2.alpha1')   unknown:unknown
14   call_user_func_array(Array, Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php:186
21   CRM_Core_Invoke::invoke(Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module:500
22   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
23   call_user_func_array('civicrm_invoke', Array)   /var/www/vhosts/XXX/httpdocs/includes/menu.inc:516
24   menu_execute_active_handler()   /var/www/vhosts/XXX/httpdocs/index.php:21
25   {main}   

• civicrm_extenstion
• civicrm_managed
• civicrm_queue_item
• civicrm_sms-provider

CiviCRM Upgrade Tasks
Error message

    Warning: file_get_contents(sites/all/modules/civicrm/drupal/../packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js): failed to open stream: No such file or directory in _locale_parse_js_file() (line 1488 of /var/www/vhosts/XXX/httpdocs/includes/locale.inc).
    Warning: file_get_contents(sites/all/modules/civicrm/drupal/../js/jquery/jquery.crmrowhighlighter.js): failed to open stream: No such file or directory in _locale_parse_js_file() (line 1488 of /var/www/vhosts/XXX/httpdocs/includes/locale.inc).

Status message
Operating in maintenance mode. Go online.
[Error: Upgrade DB to 4.2.alpha2]
Error Field   Error Value
Type   DB_Error
Code   -3
Message   DB Error: constraint violation
Mode   16
UserInfo   ALTER TABLE civicrm_group ADD CONSTRAINT `FK_civicrm_group_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`CiviCRM4_EU`., CONSTRAINT `FK_civicrm_group_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DE)]
DebugInfo   ALTER TABLE civicrm_group ADD CONSTRAINT `FK_civicrm_group_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DELETE SET NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`CiviCRM4_EU`., CONSTRAINT `FK_civicrm_group_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DE)]
PEAR_Exception: DB Error: constraint violation in unknown on line unknown
- DB_Error: DB Error: constraint violation 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))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: constr…', -3, 16, Array, 'ALTER TABLE civi…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB.php:968
3   DB_Error->DB_Error(-3, 16, Array, 'ALTER TABLE civi…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -3, null, null, 'ALTER TABLE civi…', 'DB_Error', true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/common.php:1903
5   DB_common->raiseError(-3, null, null, null, '1452 ** Cannot a…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('ALTER TABLE civi…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE civi…')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Utils/File.php:287
9   CRM_Utils_File->sourceSQLFile('mysql://CiviCRM4…', ' SELECT @wo…', null, true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:152
10   CRM_Upgrade_Form->source(' SELECT @wo…', true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:292
11   CRM_Upgrade_Form->processLocales('/var/www/vhosts/…', '4.2.alpha2')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:316
12   CRM_Upgrade_Form->processSQL('4.2.alpha2')   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Upgrade/Form.php:558
13   CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.2.alpha2', '4.1.6', '4.2.1', '/tmp/civicrm-pos…')   unknown:unknown
14   call_user_func_array(Array, Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php:186
21   CRM_Core_Invoke::invoke(Array)   /var/www/vhosts/XXX/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module:500
22   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
23   call_user_func_array('civicrm_invoke', Array)   /var/www/vhosts/XXX/httpdocs/includes/menu.inc:516
24   menu_execute_active_handler()   /var/www/vhosts/XXX/httpdocs/index.php:21
25   {main}