Situation
I’m trying to set it up to work in Spanish, but there are some words that the translation doesn’t work but when I try using the Multilanguage Tool I keep getting an error.
OpenEMR Version
I’m using OpenEMR version 7.0.2
Browser:
Edge
Operating System
Windows 10
Search
Yes, but there are no solutions
Logs
Did you check the logs?
Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
´´´ SQL Statement failed on preparation: SELECT lc.cons_id, lc.constant_name, ld.def_id, ld.definition, ld.lang_id FROM lang_definitions AS ld RIGHT JOIN ( lang_constants AS lc, lang_languages AS ll ) ON ( lc.cons_id = ld.cons_id AND ll.lang_id = ld.lang_id ) WHERE lc.constant_name COLLATE utf8mb4_general_ci LIKE ? AND ( ll.lang_id = 1 OR ll.lang_id=? ) ORDER BY lc.constant_name, BINARY lc.constant_name, ld.lang_id COLLATE utf8mb4_general_ci’
Query Error
ERROR: query failed: SELECT lc.cons_id, lc.constant_name, ld.def_id, ld.definition, ld.lang_id FROM lang_definitions AS ld RIGHT JOIN ( lang_constants AS lc, lang_languages AS ll ) ON ( lc.cons_id = ld.cons_id AND ll.lang_id = ld.lang_id ) WHERE lc.constant_name COLLATE utf8mb4_general_ci LIKE ? AND ( ll.lang_id = 1 OR ll.lang_id=? ) ORDER BY lc.constant_name, BINARY lc.constant_name, ld.lang_id COLLATE utf8mb4_general_ci
Error: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’
C:\xampp\htdocs\openemr\interface\language\lang_definition.php at 216:sqlStatement
C:\xampp\htdocs\openemr\interface\language\language.php at 96:require_once(C:\xampp\htdocs\openemr\interface\language\lang_definition.php) ´´´