Global error

ookdoeii wrote on Monday, March 06, 2017:

Hi,

Yesterday I installed the CMS package openemr 5. But I get this error. What can I do about it?

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 '='


/home/sven/domein.nl/library/translation.inc.php at 36:sqlStatementNoLog
/home/sven/domein.nl/library/globals.inc.php at 2732:xl(Māori)
/home/sven/domein.nl/interface/super/edit_globals.php at 32:require_once(/home/sven/domein.nl/library/globals.inc.php)

Thnx!

cmswest wrote on Monday, March 06, 2017:

here’s a related thread:

https://sourceforge.net/p/openemr/discussion/202505/thread/d440db8c/?limit=25&page=1#c72a

bradymiller wrote on Tuesday, March 07, 2017:

Hi,
Also. If you created the initial database separately (for example on a shared host), rec a reinstall and ensure that you set the database to use UTF8 encoding when you create the database on the reinstall (it appears you set it to latin1 instead, which will just cause headaches down the road).
-brady
OpenEMR