CiviCRM Community Forums (archive)

Hello All,
I have a Drupal 7 site using CiviCRM 4.3.5 and wanted to begin using a few of the cool CiviExtensions (Stripe), but had an error when trying to see the available extensions.  So, I figured it was time to upgrade to the stable 4.4.6.  However, when I tried going straight from 4.3.5 to 4.4.6 it failed with "4.4.0 db error".  So I thought I need to do this in steps, so was able to successfully get to 4.3.8 (Extensions still didn't work...), but when trying to upgrade to 4.4.6 it still failed at the 4.4.0 DB step.  So... decided to try 4.4.1 ... same failure point... then tried 4.4.0 and it still failed but with a lot more verbiage ---

[Error: Consolidate activity contacts]
Error Field Error Value
Type DB_Error
Code -5
Message DB Error: already exists
Mode 16
UserInfo INSERT INTO civicrm_activity_contact (activity_id, contact_id, record_type_id) SELECT activity_id, target_contact_id, 3 as record_type_id FROM civicrm_activity_target [nativecode=1062 ** Duplicate entry '1-328-3' for key 'UI_activity_contact']
DebugInfo INSERT INTO civicrm_activity_contact (activity_id, contact_id, record_type_id) SELECT activity_id, target_contact_id, 3 as record_type_id FROM civicrm_activity_target [nativecode=1062 ** Duplicate entry '1-328-3' for key 'UI_activity_contact']
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/www/htdocs/sites/all/modules/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: alread…', -5, 16, Array, ' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/packages/DB.php:969
3 DB_Error->DB_Error(-5, 16, Array, ' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -5, null, null, ' INSERT INTO civ…', 'DB_Error', true) /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/common.php:1905
5 DB_common->raiseError(-5, null, null, null, '1062 ** Duplicat…') /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery(' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/common.php:1216
8 DB_common->query(' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9 DB_DataObject->_query(' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10 DB_DataObject->query(' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php:158
11 CRM_Core_DAO->query(' INSERT INTO civ…', true) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php:905
12 CRM_Core_DAO::executeQuery(' INSERT INTO civ…') /srv/www/htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourFour.php:175
13 CRM_Upgrade_Incremental_php_FourFour::activityContacts(Object(CRM_Queue_TaskContext)) unknown:unknown
14 call_user_func_array(Array, Array) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16 CRM_Queue_Runner->runNext(true) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17 {closure}() /srv/www/htdocs/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /srv/www/htdocs/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) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php:289
21 CRM_Core_Invoke::runItem(Array) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php:72
22 CRM_Core_Invoke::_invoke(Array) /srv/www/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23 CRM_Core_Invoke::invoke(Array) /srv/www/htdocs/sites/all/modules/civicrm/drupal/civicrm.module:436
24 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') unknown:unknown
25 call_user_func_array('civicrm_invoke', Array) /srv/www/htdocs/includes/menu.inc:517
26 menu_execute_active_handler() /srv/www/htdocs/index.php:21
27 {main}

So... how does one get to 4.4.x if it fails on the 4.4.0 DB upgrade step?

I originally forgot to add my mysql version -- mysql-community-server-5.1.46-2.18.i586 running on OpenSUSE 11.3
Would it help if I upgraded my version mysql?

-- UPDATE --- upgraded my OS and mysql to mysql-community-server-5.1.57-0.3.1.i586, but when I tried to go to 4.4.6 again it fails with the error -- [Error: Upgrade DB to 4.4.0]

Thanks,
Patrick