OpenEMR Globals settings is not working in version 4.2.0

[Dr Anzar Thahir]

Good morning my dear brothers and sisters

I have a problem in accessing the Globals settings in the latest version of OpenEMR 4.2.0.

I am getting a php error while try to load the Globals. The error message is as follows

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 '='

C:\xampp\htdocs\emr420\library\translation.inc.php at 36:sqlStatementNoLog
C:\xampp\htdocs\emr420\library\globals.inc.php at 2022:xl(Māori)
C:\xampp\htdocs\emr420\interface\super\edit_globals.php at 12:require_once(C:\xampp\htdocs\emr420\library\globals.inc.php)

I downloaded it twice and tried in my local server as well as webserver, but it is not working. The same time Version 4.1.0 installed in the same servers are working very fine.

What shall I do? Please help

I am a Doctor and not a IT personal,

Dr Anzar Thahir

dranzarthahir@gmail.com

[Tony McCormick]

You have to fix the table in the database to use UTF-8 instead of latin1_bin

Can't tell if it's lang_definitions or lang_constants or both

using mysql (or PHPMYADMIN)

alter table <some_table> convert to character set utf8 collate utf8_general_ci;

Tony