Multi Language Tool Issue

Support
#1

Situation
I have a clean installation of OpenEMR on Windows 10. 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.0.2

Browser:
I’m using: Google Chrome

Operating System
I’m using: Windows 10

Logs
Did you check the logs?

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)
#2

Hola @serge , fijate que en openemr/sites/default/sqlconf.php este asi: $db_encoding = ‘utf8mb4’; sino deberías cambiar las tablas lang_definition, lang_custon y lang_constants a utf8mb4_general_ci.
Suerte, Saludos
Luis

#3

Hola tengo el mismo problema en mi instalacion en windows 10, ya chequee openemr/sites/default/sqlconf.php y esta asi: $db_encoding = ‘utf8mb4’;

Todas las tablas tienen el cotejamiento utf8mb4_general_ci.

El mensaje de error es el siguiente:

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)

Gracias de antemano por su ayuda.

#4

Prueba en sqlconf.php:
$disable_utf8_flag = false;

O, si lo pones true. Comenta $db_encoding = ‘utf8mb4’;

Suerte.
Luis.

#5

hola, seguí los procedimientos sugeridos, no funcionó :pensive: