jimmyb727 wrote on Sunday, June 19, 2016:
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/stosbal4/public_html/americanehealth.com/emr/library/translation.inc.php at 36:sqlStatementNoLog
/home/stosbal4/public_html/americanehealth.com/emr/library/globals.inc.php at 2426:xl(Māori)
/home/stosbal4/public_html/americanehealth.com/emr/interface/super/edit_globals.php at 13:require_once(/home/stosbal4/public_html/americanehealth.com/emr/library/globals.inc.php)
I just installed OpenEMR onto a Cpanel shared hosting Linux server, with lots of help. I was able to get it to start working, but have problems: illegal collations in 2 areas (I made separate question posts for them), and an HTTP 500 error. I am new to programming, and new to OpenEMR. Can someone give me a step by step solution, for dumb people, to resolve this problem?