CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Can't upgrade 4.3.5 to 4.4.1
Pages: [1]

Author Topic: Can't upgrade 4.3.5 to 4.4.1  (Read 2111 times)

jeffw

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 6.20
  • MySQL version: 5.0.77
  • PHP version: 5.3.3
Can't upgrade 4.3.5 to 4.4.1
November 21, 2013, 12:06:15 am
I get:


CiviCRM Upgrade Tasks
Status message
Operating in maintenance mode. Go online.
[Error: Update Line Item Data]
Error Field   Error Value
Type   DB_Error
Code   -5
Message   DB Error: already exists
Mode   16
UserInfo   UPDATE civicrm_line_item cli LEFT JOIN civicrm_financial_item cfi ON cli.id = cfi.entity_id SET cli.label = 'Monthly Member', cli.price_field_id = 23, cli.price_field_value_id = 60, cfi.financial_account_id = 2, cfi.description = 'Monthly Member', cli.financial_type_id = 6 WHERE cfi.entity_table = 'civicrm_line_item' AND cli.entity_table = 'civicrm_contribution' AND cli.id IN (20581,20581,20581,20735,20735,20735,20922,20922,20922,21293); [nativecode=1062 ** Duplicate entry 'civicrm_contribution-16930-60-23' for key 'UI_line_item_value']
DebugInfo   UPDATE civicrm_line_item cli LEFT JOIN civicrm_financial_item cfi ON cli.id = cfi.entity_id SET cli.label = 'Monthly Member', cli.price_field_id = 23, cli.price_field_value_id = 60, cfi.financial_account_id = 2, cfi.description = 'Monthly Member', cli.financial_type_id = 6 WHERE cfi.entity_table = 'civicrm_line_item' AND cli.entity_table = 'civicrm_contribution' AND cli.id IN (20581,20581,20581,20735,20735,20735,20922,20922,20922,21293); [nativecode=1062 ** Duplicate entry 'civicrm_contribution-16930-60-23' for key 'UI_line_item_value']
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))   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: alread…', -5, 16, Array, 'UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-5, 16, Array, 'UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -5, null, null, 'UPDATE civicrm_l…', 'DB_Error', true)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-5, null, null, null, '1062 ** Duplicat…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('UPDATE civicrm_l…')   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Core/DAO.php:158
11   CRM_Core_DAO->query('UPDATE civicrm_l…', true)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Core/DAO.php:905
12   CRM_Core_DAO::executeQuery('UPDATE civicrm_l…', Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:1066
13   CRM_Upgrade_Incremental_php_FourThree::updateLineItemData(Object(CRM_Queue_TaskContext), '4.3.6')   unknown:unknown
14   call_user_func_array(Array, Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/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)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Core/Invoke.php:289
21   CRM_Core_Invoke::runItem(Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Core/Invoke.php:72
22   CRM_Core_Invoke::_invoke(Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/sites/all/modules/civicrm/drupal/civicrm.module:437
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/includes/menu.inc:517
26   menu_execute_active_handler()   /home/ccmcweb/yesfairelections.org/htdocs/drupal-7.19/index.php:21
27   {main}   

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Can't upgrade 4.3.5 to 4.4.1
November 21, 2013, 08:23:55 am
Just to let you know that we are investigating this, and think we have a sense of what is causing the issue.

I don't think it will be necessary, but if we are unable to track down the source of this error, might it be possible for us to have a copy of the database you were trying to upgrade? There is a script in civicrm's bin directory that can anonymize all of the personal information in the database easily before you send it us (in a typical Drupal installation it is at sites/all/modules/civicrm/bin/encryptDB.php).
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

jeffw

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 6.20
  • MySQL version: 5.0.77
  • PHP version: 5.3.3
Re: Can't upgrade 4.3.5 to 4.4.1
November 21, 2013, 05:57:22 pm
Sure, just let me know.

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Can't upgrade 4.3.5 to 4.4.1
November 24, 2013, 12:24:30 pm
Pradeep tells me that he does need the database. Could you encrypt it and upload it to https://spideroak.com/browse/share/ForJeffW/MyRoomKey using the password I am sending via email.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

homebrewruss

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Can't upgrade 4.3.5 to 4.4.1
December 04, 2013, 03:08:56 am
Hi there,
We are getting an identical error upgrading from 4.2.9 to 4.4.2.  Did you get anywhere with debugging this at all?

Thanks
Russ

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Can't upgrade 4.3.5 to 4.4.1
December 04, 2013, 07:33:46 am
We didn't get a db from Jeff in the end, after a mixup on a secure upload password.

Could you run bin/encryptDB.php on your db and upload it to
https://spideroak.com/browse/share/ForJeffW/MyRoomKey

I can provide you with the password for upload if you Skype me at JosephPMurray or email me joe dot murray at jmaconsulting dot biz.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

circlebails

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
  • CiviCRM version: 4.1.X 4.2.X
  • CMS version: Drupal-6.X / Drupal-7.X
  • MySQL version: 5.1
  • PHP version: 5.2.16/17, 5.3
Re: Can't upgrade 4.3.5 to 4.4.1
January 06, 2014, 06:35:06 am
I'm also seeing this:

[Error: Update Line Item Data]
Error Field   Error Value
Type   DB_Error
Code   -5
Message   DB Error: already exists
Mode   16
UserInfo   UPDATE civicrm_line_item cli LEFT JOIN civicrm_financial_item cfi ON cli.id = cfi.entity_id SET cli.label = 'Donor conceived adult', cli.price_field_id = 41, cli.price_field_value_id = 241, cfi.financial_account_id = 2, cfi.description = 'Donor conceived adult', cli.financial_type_id = 2 WHERE cfi.entity_table = 'civicrm_line_item' AND cli.entity_table = 'civicrm_contribution' AND cli.id IN (10441,28161); [nativecode=1062 ** Duplicate entry 'civicrm_contribution-2661-241-41' for key 'UI_line_item_value']
DebugInfo   UPDATE civicrm_line_item cli LEFT JOIN civicrm_financial_item cfi ON cli.id = cfi.entity_id SET cli.label = 'Donor conceived adult', cli.price_field_id = 41, cli.price_field_value_id = 241, cfi.financial_account_id = 2, cfi.description = 'Donor conceived adult', cli.financial_type_id = 2 WHERE cfi.entity_table = 'civicrm_line_item' AND cli.entity_table = 'civicrm_contribution' AND cli.id IN (10441,28161); [nativecode=1062 ** Duplicate entry 'civicrm_contribution-2661-241-41' for key 'UI_line_item_value']
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/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: alread?', -5, 16, Array, 'UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-5, 16, Array, 'UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -5, null, null, 'UPDATE civicrm_l?', 'DB_Error', true)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-5, null, null, null, '1062 ** Duplicat?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('UPDATE civicrm_l?')   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Core/DAO.php:160
11   CRM_Core_DAO->query('UPDATE civicrm_l?', true)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Core/DAO.php:907
12   CRM_Core_DAO::executeQuery('UPDATE civicrm_l?', Array)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:1068
13   CRM_Upgrade_Incremental_php_FourThree::updateLineItemData(Object(CRM_Queue_TaskContext), '4.3.6')   unknown:unknown
14   call_user_func_array(Array, Array)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /var/www/html/dcn/drupal-7.24/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/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Core/Invoke.php:289
21   CRM_Core_Invoke::runItem(Array)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Core/Invoke.php:72
22   CRM_Core_Invoke::_invoke(Array)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /var/www/html/dcn/drupal-7.24/sites/all/modules/civicrm/drupal/civicrm.module:456
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /var/www/html/dcn/drupal-7.24/includes/menu.inc:517
26   menu_execute_active_handler()   /var/www/html/dcn/drupal-7.24/index.php:21
27   {main}

I have a copy of the database and can anonamise it if needed?

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Can't upgrade 4.3.5 to 4.4.1
January 06, 2014, 07:36:05 am
Yes, please anonymize it and upload it to the url above. I would like to send you a password for the upload securely: do you have a Skype login?
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

circlebails

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
  • CiviCRM version: 4.1.X 4.2.X
  • CMS version: Drupal-6.X / Drupal-7.X
  • MySQL version: 5.1
  • PHP version: 5.2.16/17, 5.3
Re: Can't upgrade 4.3.5 to 4.4.1
January 06, 2014, 11:17:47 pm
I'm bails-bails on skype. If you'd like to send me the password.

Thanks

Bails

Tass

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
    • Holos
  • CiviCRM version: 4.5.3.
  • CMS version: Joomla 2.5.27
  • MySQL version: 5.5.32
  • PHP version: 5.3.28-pl3-gentoo
Re: Can't upgrade 4.3.5 to 4.4.1
January 17, 2014, 08:33:03 am
Hi, I think I have simillar problem.
Upgrading on joomla 2.5.17 from Civi 4.1.5. to 4.4.3

I get:

[Error: Upgrade DB to 4.2.alpha1: Participant (9 => 5008)]
Error Field   Error Value
Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16

UserInfo   SELECT cp.id as participant_id, cp.fee_amount, cp.fee_level,ce.is_monetary, cpse.price_set_id, cpf.id as price_field_id, cpfv.id as price_field_value_id FROM civicrm_participant cp LEFT JOIN civicrm_line_item cli ON cli.entity_id=cp.id and cli.entity_table = 'civicrm_participant' LEFT JOIN civicrm_event ce ON ce.id=cp.event_id LEFT JOIN civicrm_price_set_entity cpse ON cp.event_id = cpse.entity_id and cpse.entity_table = 'civicrm_event' LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cpse.price_set_id LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id AND cpfv.label = cp.fee_level WHERE (cp.id BETWEEN 9 AND 5008) AND cli.entity_id IS NULL AND cp.fee_amount IS NOT NULL [nativecode=1267 ** Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']

DebugInfo   SELECT cp.id as participant_id, cp.fee_amount, cp.fee_level,ce.is_monetary, cpse.price_set_id, cpf.id as price_field_id, cpfv.id as price_field_value_id FROM civicrm_participant cp LEFT JOIN civicrm_line_item cli ON cli.entity_id=cp.id and cli.entity_table = 'civicrm_participant' LEFT JOIN civicrm_event ce ON ce.id=cp.event_id LEFT JOIN civicrm_price_set_entity cpse ON cp.event_id = cpse.entity_id and cpse.entity_table = 'civicrm_event' LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cpse.price_set_id LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id AND cpfv.label = cp.fee_level WHERE (cp.id BETWEEN 9 AND 5008) AND cli.entity_id IS NULL AND cp.fee_amount IS NOT NULL [nativecode=1267 ** Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']

PEAR_Exception: DB Error: unknown error in unknown on line unknown       
- DB_Error: DB Error: unknown error 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))   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, ' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-1, 16, Array, ' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, ' SELECT cp.id…', 'DB_Error', true)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-1, null, null, null, '1267 ** Illegal …')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery(' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query(' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query(' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query(' SELECT cp.id…')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:160
11   CRM_Core_DAO->query(' SELECT cp.id…', true)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:907
12   CRM_Core_DAO::executeQuery(' SELECT cp.id…', Array)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:725
13   CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_convertParticipants(Object(CRM_Queue_TaskContext), '9', 5008)   unknown:unknown
14   call_user_func_array(Array, Array)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /mnt/data/accounts/v/vanatomas/data/www/development/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)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:289
21   CRM_Core_Invoke::runItem(Array)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:72
22   CRM_Core_Invoke::_invoke(Array)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/admin.civicrm.php:116
24   civicrm_invoke()   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/components/com_civicrm/admin.civicrm.php:40
25   require_once('/mnt/data/accoun…')   /mnt/data/accounts/v/vanatomas/data/www/development/libraries/joomla/application/component/helper.php:383
26   JComponentHelper::executeComponent('/mnt/data/accoun…')   /mnt/data/accounts/v/vanatomas/data/www/development/libraries/joomla/application/component/helper.php:351
27   JComponentHelper::renderComponent('com_civicrm')   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/includes/application.php:153
28   JAdministrator->dispatch()   /mnt/data/accounts/v/vanatomas/data/www/development/administrator/index.php:46
29   {main}   

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Can't upgrade 4.3.5 to 4.4.1
January 20, 2014, 09:04:03 am
Tass, could you open a separate thread on the forum - your error is different (about participants rather than line_items), and it is for code upgrading to 4.2.alpha1 (as part of going to 4.4.3).

Thanks, and good luck.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

circlebails

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
  • CiviCRM version: 4.1.X 4.2.X
  • CMS version: Drupal-6.X / Drupal-7.X
  • MySQL version: 5.1
  • PHP version: 5.2.16/17, 5.3
Re: Can't upgrade 4.3.5 to 4.4.1
January 27, 2014, 12:13:35 am
Hi Joe

I've taken a look at this again and the issue seems to occur when e.g.

+-------+----------------------+-----------+----------------+-----------------------+-----+------------+------------+-------------------+----------------------+
| id    | entity_table         | entity_id | price_field_id | label                 | qty | unit_price | line_total | participant_count | price_field_value_id |
+-------+----------------------+-----------+----------------+-----------------------+-----+------------+------------+-------------------+----------------------+
| 28161 | civicrm_contribution |     27171 |             41 | Family membership     |   1 |      35.00 |      35.00 |                 0 |                  211 |
| 28171 | civicrm_contribution |     27171 |             41 | Another contribution type |   1 |       5.00 |       5.00 |                 0 |                  241 |
+-------+----------------------+-----------+----------------+-----------------------+-----+------------+------------+-------------------+----------------------+
 
During the update it appears to be trying to update the first occurrence with the data from the second, where there multiple contributions with the same entity id.

I have a suspicion this CiviCRM started on a version before price sets as the resulting UI for this particular contribution page is distinctly odd!

Thanks

Bails

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Can't upgrade 4.3.5 to 4.4.1
January 28, 2014, 05:07:13 pm
Bails - Can you respond to Pradeep's comment:

http://issues.civicrm.org/jira/browse/CRM-14111?focusedCommentId=56622&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-56622

It seems like there's 'unexpected' data already in the DB prior to upgrade query given the UI_line_item_value unique index on the line_item table. 

That said, if you have a suggestion for how to handle the situation - that would be most helpful at this point (other than bypassing that 'fix' that was added for this issue: http://issues.civicrm.org/jira/browse/CRM-12844 by commenting out the the UpdateLineItemData task).
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Can't upgrade 4.3.5 to 4.4.1

This forum was archived on 2017-11-26.