Help, error "ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON "

Management and Administration
#1

Hi!!!
I’m 100% new in OpenEMR, I just installed it on my web. The problem comes when trying to configure it once installed, everything works fine untill I click on “settings” and i get this message:

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 ‘=’

/var/www/vhosts/16/200773/webspace/httpdocs/luistlopez.com/profesional/library/translation.inc.php at 36:sqlStatementNoLog
/var/www/vhosts/16/200773/webspace/httpdocs/luistlopez.com/profesional/library/globals.inc.php at 2732:xl(Māori)
/var/www/vhosts/16/200773/webspace/httpdocs/luistlopez.com/profesional/interface/super/edit_globals.php at 32:require_once(/var/www/vhosts/16/200773/webspace/httpdocs/luistlopez.com/profesional/library/globals.inc.php)

Does anyone know what the problem is? What should I do to fix it?

Thanks in advance from a newby

#2

Hi luistlopez,
To fix this kind Error follow these steps
SET collation_connection = ‘utf8_general_ci’
then for your databases
ALTER DATABASE db CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
Replace the db with the DATABASE and table with appropriate table that has collations issue…
Please let us know if this helps.

Thanks,
ViSolve

#3

This is something that was fixed in the patch. Recommend installing most recent patch:
http://www.open-emr.org/wiki/index.php/OpenEMR_Patches

#4

thank you so much!!!

Will keep an eye on new patches!