Ayuda/ Help with error when entering settings

Management and Administration
1

Hello, I installed OpenEMR on a server and when I go to “settings”, the following error appears:

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/opensalv/public_html/library/translation.inc.php at 36:sqlStatementNoLog
/home/opensalv/public_html/library/globals.inc.php at 2732:xl(Māori)
/home/opensalv/public_html/interface/super/edit_globals.php at 32:require_once(/home/opensalv/public_html/library/globals.inc.php)

Login with language: Spanish (Latin American)
also wirh : Spanish (Spain)

2

Hello eliseoiie,

Please refer the following link Error messages after installation .
Hope this will help you and let us know if you have any clarifications.

ViSolve

1 Like
3

Hi @eliseoiie ,

This issue is resolved if you install the most recent patch for 5.0.0:
http://www.open-emr.org/wiki/index.php/OpenEMR_Patches

-brady

1 Like
4

Hi @brady.miller ,
Thanks for your reply, update! But the patients do not appear to me any more.
But when looking for them appear:

error2_pacientes_hosting.jpg1366×768 128 KB

I was also with XAMPP and the following error appears:

DataTables warning: table id=pt_table - Invalid JSON response. For more information about this error, please see 1. Warning: Invalid JSON response

error2_pacientes.png1366×768 127 KB

help please

5

Hello eliseoiie,

Can you please check your apache error log to find the cause of this issue ? We couldn’t able to reproduce this issue in our systems.
Check with your patient details whether they are having any invalid characters or not ? Some times any invalid characters will break the data table response.

Thanks,
ViSolve