I get the following error when Globals under Administration is selected .Help Thanks
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 ‘=’
/home1/onlinfr9/public_html/KL/library/translation.inc.php at 36:sqlStatementNoLog
/home1/onlinfr9/public_html/KL/library/globals.inc.php at 2022:xl(Māori)
/home1/onlinfr9/public_html/KL/interface/super/edit_globals.php at 12:require_once(/home1/onlinfr9/public_html/KL/library/globals.inc.php)
This looks like an SQL error. Can you include a little more info? Here are some questions I have for you that will help me assist you.
Is this a new install?
Did you recently upgrade?
If you recently upgraded and if you didn’t use the upgrade script, you might want to. You can do so by following these instructions.
go to the following link http://openemr/admin.php (if you have a different name for openemr on your local host replace ‘openemr’ with your local host name.
If “upgrade database” is an option, click on it. Select the last version that you had. Scroll through the output and make sure that there isn’t any “red” type. If there is, you may need to select an earlier version.
Once you have all green or all black feedback (no errors) run the sql patch. You do this by going to the following link http://openemr/sql_patch.php.
If the following instructions don’t help, please let me know of any changes you may have made.
Please let me know if you deleted a list. (administration->lists)
Please let me know if you made changes to layouts. (administration->layouts)
I am also facing the same issue. I have setup a new database to try 4.2.0, in both the local server as well as the online server I can not access the “Globals” option in Administration pannel.
Even after I run the query in SQL error still persists.
How can I find out the location of the table to change in manually.
Attached are the screen shot of the successful query execution and error even after that.
Please help