CiviCRM Community Forums (archive)

Hi, I have problem when upgrading from Civi 4.1.5. to 4.4.3.

Upgrading on joomla 2.5.17 from Civi 4.1.5. to 4.4.3
MySQL: 5.1.56
PHP: 5.3.6-pl1-gentoo

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}   

Thanks for any help!

Hi, thanks for a reply, upgrading per version was successfull.
I upgraded:
4.1.5 > 4.2.0
4.2.0 > 4.3.7
4.3.7 > 4.4.4

Seems everything works great now.
Thanks!