jimmyb727 wrote on Friday, June 10, 2016:
I am new to both programming and also to OpenEMR. I installed the OpenEMR onto a Cpanel shared hosting environment, with help, then began to use it. I clicked onto Administration, then Globals, and received the error below in the next post. Can someone give me a step by step instruction, for dumb people, so i can fix this?
jimmyb727 wrote on Friday, June 10, 2016:
Administration – Globals
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)
jimmyb727 wrote on Friday, June 10, 2016:
Cpanel shared hosting Linux server
tmccormi wrote on Friday, June 10, 2016:
I have this issue all the time on those files (yesterday in fact) trying to upgrade from older database versions to current.
Sometimes this fixes it im mysql:
ALTER DATABASE openemr CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE lang_definitions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE lang_constants CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
Sometimes I have to dump the table to text sql, and edit the CHAR SET in the structure. DROP the two tables and import the fixed dump.