dkdipak1 wrote on Monday, February 09, 2015:
Dear Team,
I tried upgrading 4.1.2 to 4.2.0, everything went well. Thanks to detailed wiki creators. However, on upgrading to old data i got the errors and that led , the “module” from left navigation removed. and when I click on globals I get these errors: please help.
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\openemr\library\translation.inc.php at 36:sqlStatementNoLog
C:\xampp\htdocs\openemr\library\globals.inc.php at 2022:xl(Māori)
C:\xampp\htdocs\openemr\interface\super\edit_globals.php at 12:require_once(C:\xampp\htdocs\openemr\library\globals.inc.php)
Thanks,
Dipak