Globals error

sandeepdhanjal wrote on Monday, January 18, 2016:

Hi
I’m new to OpenEMR please help I’ve uploaded EMR to my hosting server and getting this message while click on globals link

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 ‘=’

/emr/library/translation.inc.php at 36:sqlStatementNoLog
/emr/library/globals.inc.php at 2054:xl(Māori)
/emr/interface/super/edit_globals.php at 12:require_once(/emr/library/globals.inc.php)

fsgl wrote on Monday, January 18, 2016:

See this.