Regarding error on the Settings page

system · March 7, 2017, 10:11am

saurabh261187 wrote on Tuesday, March 07, 2017:

I am getting the following error on the settings page. What may be the possible solution for the same ?

ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1

Error: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’

/home/nextechinc/domains/repository.in/public_html/library/translation.inc.php at 36:sqlStatementNoLog
/home/nextechinc/domains/repository.in/public_html/library/globals.inc.php at 2732:xl(Māori)
/home/nextechinc/domains/repository.in/public_html/interface/super/edit_globals.php at 32:require_once(/home/nextechinc/domains/repository.in/public_html/library/globals.inc.php)

system · March 7, 2017, 10:39am

visolveemr wrote on Tuesday, March 07, 2017:

Hi Saurabh ,

Please refer the following link :
https://sourceforge.net/p/openemr/discussion/202505/thread/d440db8c/?limit=25&page=1#c72a

and let us know if you have any concerns.

Visolve

system · March 7, 2017, 10:47am

bradymiller wrote on Tuesday, March 07, 2017:

Hi,

This bug seems to be coming up a lot. In the codebase, maybe we should remove the utf8 characters from the pdf settings label array? thoughts?

github.com

openemr/openemr/blob/master/library/globals.inc.php#L2764


    xl('Enable Weno eRx Service') . ' ' . xl('Contact Open Med Practice, www.openmedpractice.com for subscribing to the Weno Free eRx service.')
),


'weno_account_id' => array(
    xl('Weno eRx Account Id'),
    'text',
    '',
    xl('Account Id issued for Weno eRx service.')
),


'weno_account_pass' => array(
    xl('Weno eRx Account Pass'),
    'text',
    '',
    xl('Account Id issued for Weno eRx service.')
),


'weno_provider_id' => array(
    xl('Weno eRx Clinic ID'),
    'text',
    '',

github.com

openemr/openemr/blob/master/library/globals.inc.php#L2765


),


'weno_account_id' => array(
    xl('Weno eRx Account Id'),
    'text',
    '',
    xl('Account Id issued for Weno eRx service.')
),


'weno_account_pass' => array(
    xl('Weno eRx Account Pass'),
    'text',
    '',
    xl('Account Id issued for Weno eRx service.')
),


'weno_provider_id' => array(
    xl('Weno eRx Clinic ID'),
    'text',
    '',
    xl('Account Id issued for Your clinics eRx service.')

github.com

openemr/openemr/blob/master/library/globals.inc.php#L2785


    xl('Account Id issued for Your clinics eRx service.')
),


'ccda_alt_service_enable' => array(
    xl('Enable C-CDA Alternate Service'),
    array(
        0 => xl('Off'),
        1 => xl('Care Coordination Only'),
        2 => xl('Portal Only'),
        3 => xl('Both'),
    ),
    '0',
    xl('Enable C-CDA Alternate Service')
),


'phimail_enable' => array(
    xl('Enable phiMail Direct Messaging Service'),
    'bool',                           // data type
    '0',
    xl('Enable phiMail Direct Messaging Service')
),

-brady
OpenEMR

system · March 7, 2017, 3:55pm

sunsetsystems wrote on Tuesday, March 07, 2017:

Not sure I understand why those characters cause the “Illegal mix of collations” error?

system · March 13, 2017, 8:25am

bradymiller wrote on Monday, March 13, 2017:

Hi,

I don’t fully understand it, but characters that can not be represented with latin encoding appear to be unmasking issues when there are hybrid utf8/latin and full latin databases. Here’s a minor fix to prevent this issue in the future:

thoughts?

-brady
OpenEMR