Database Error - On Definition, Translation Tab

hashimea · December 22, 2018, 5:30am

May i know how to fix this error. Happening with fresh setup.

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 utf8_general_ci LIKE ? AND ( ll.lang_id = 1 OR ll.lang_id=? ) ORDER BY lc.constant_name COLLATE utf8_general_ci

Error: COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘latin1’

brady.miller · December 23, 2018, 12:16am

hi @hashimea ,
Are you creating a database before the OpenEMR setup? If so, then need to ensure the database is set to use UTF8.
-brady

hashimea · December 25, 2018, 7:29am

Converting the database to UTF8 fixed this issue. Thank You

undici · January 3, 2021, 6:52pm

Hi,
I got the first part: ALTER DATABASE DBNAMEHERE CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci .
But can you please share how you converted all your tables? I am new-ish to PHPMy Admin and SQL Queries, but follow directions pretty well.
Thanks

undici · January 7, 2021, 11:37pm

Thanks, I started over and selected utf8_general_ci on database creation.