I am trying to Edit Definitions for the English (Standard) language on my installation. I go to Administration > Other > Language and I click Edit Definitions. SHould I see a list of current definitions and constants? If so, I am not seeing any. When I hit search, with or without terms entered into the Definition field, I get this 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 ) ORDER BY lc.constant_name COLLATE utf8_general_ci
Hi,
Search with an empty constants and definition field should show the listing of constants with fields to enter definitions for them. Sounds like a bug. What version of OpenEMR is this, what operating system and in Adminsitration->Other->Databases->'Click openemr in top left link of left phpmyadmin frame->what are you seeing in the ‘collation’ row?
-brady OpenEMR
Hi,
Is this an upgrade (from a previous OpenEMR version) or a new install? (important to know, because new installs should be using utf8 based collations, but there is a flag that can be set if you desire support for latin1_swedish instead).
-brady OpenEMR
This is a brand-new install. I had to choose the option where I created my own databases when I did the install, because the installer could not login to my mysql server for some reason. SO I had no option to select the Collation during the install process.
latin1_swedish support is the old standard that was used for English, but if you are creating a new install, I highly recommend NOT doing this. You should create a UTF8 encoded database (with a UTF8 compatible encoding), so I suggest you drop your current install and try again. Here’s some instructions on creating a UTF8 encoded database: http://pario.no/2008/01/27/mysql-create-utf8-database/