CiviCRM Community Forums (archive)

Hi,

I have 5 civicrm sites but only one fails with updating. I cannot find a fix. Joomla 2.5.11. Error:

Type: DB_Error
Code: -1
Message: DB Error: unknown error
Mode: 16
UserInfo:
INSERT INTO civicrm_financial_account (name, contact_id, financial_account_type_id, description, account_type_code, is_active) SELECT cft.name, @domainContactId, @opval, cft.name as description, 'INC', 1 FROM civicrm_financial_type cft LEFT JOIN civicrm_entity_financial_account ceft ON ceft.entity_id = cft.id AND ceft.account_relationship = @option_value_rel_id AND ceft.entity_table = 'civicrm_financial_type' LEFT JOIN civicrm_financial_account ca ON LOWER(ca.name) = LOWER(cft.name) WHERE ceft.entity_id IS NULL AND ca.id IS NULL [nativecode=1267 ** Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
DebugInfo:
INSERT INTO civicrm_financial_account (name, contact_id, financial_account_type_id, description, account_type_code, is_active) SELECT cft.name, @domainContactId, @opval, cft.name as description, 'INC', 1 FROM civicrm_financial_type cft LEFT JOIN civicrm_entity_financial_account ceft ON ceft.entity_id = cft.id AND ceft.account_relationship = @option_value_rel_id AND ceft.entity_table = 'civicrm_financial_type' LEFT JOIN civicrm_financial_account ca ON LOWER(ca.name) = LOWER(cft.name) WHERE ceft.entity_id IS NULL AND ca.id IS 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))
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2
PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'INSERT INTO civi…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/DB.php:969
3
DB_Error->DB_Error(-1, 16, Array, 'INSERT INTO civi…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4
PEAR->raiseError(null, -1, null, null, 'INSERT INTO civi…', 'DB_Error', true)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1905
5
DB_common->raiseError(-1, null, null, null, '1267 ** Illegal …')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6
DB_mysql->mysqlRaiseError()
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7
DB_mysql->simpleQuery('INSERT INTO civi…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8
DB_common->query('INSERT INTO civi…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php:284
9
CRM_Utils_File::sourceSQLFile('mysql://root:roo…', ' -- CRM-12466 IN…', null, true)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:159
10
CRM_Upgrade_Form->source(' -- CRM-12466 IN…', true)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:299
11
CRM_Upgrade_Form->processLocales('/Volumes/Macinto…', '4.3.4')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:323
12
CRM_Upgrade_Form->processSQL('4.3.4')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:952
13
CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), '4.3.4')
unknown:unknown
14
call_user_func_array(Array, Array)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15
CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
16
CRM_Queue_Runner->runNext(true)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17
{closure}()
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18
CRM_Queue_ErrorPolicy->call(Object(Closure))
/Volumes/Macintosh HD 2/helen/htdocs/my_site/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)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:258
21
CRM_Core_Invoke::runItem(Array)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:70
22
CRM_Core_Invoke::_invoke(Array)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:52
23
CRM_Core_Invoke::invoke(Array)
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/admin.civicrm.php:116
24
civicrm_invoke()
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/components/com_civicrm/admin.civicrm.php:40
25
require_once('/Volumes/Macinto…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/libraries/joomla/application/component/helper.php:383
26
JComponentHelper::executeComponent('/Volumes/Macinto…')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/libraries/joomla/application/component/helper.php:351
27
JComponentHelper::renderComponent('com_civicrm')
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/includes/application.php:153
28
JAdministrator->dispatch()
/Volumes/Macintosh HD 2/helen/htdocs/my_site/administrator/index.php:46
29
{main}

Thanks in advance,
Helen