Bug on viewing globals

OpenEMR Development
1

merlinsilk wrote on Monday, September 21, 2015:

I managed to get the latest version from github (as I want to start contributing) and got this all running locally, but I get this error when viewing the globals under admin:
Merlin

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/html/oemr/library/translation.inc.php at 36:sqlStatementNoLog
/var/www/html/oemr/library/globals.inc.php at 2180:xl(Māori)
/var/www/html/oemr/interface/super/edit_globals.php at 12:require_once(/var/www/html/oemr/library/globals.inc.php)

2

visolveemr wrote on Monday, September 21, 2015:

Hello Merlin

As mentioned in the error, this is because of mix of collations. This can be fixed using the solution discussed in this thread.

Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com | Phone: 408-850-2243
Demo’s @ ViSolve Demo Library

3

bradymiller wrote on Monday, September 21, 2015:

Hi,
This is a sign that your default database collation and encoding is not correct (it should be UTF8).
Also ensure you select a UTF8 compliant collation in Step 2 of Install.
-brady
OpenEMR

4

fsgl wrote on Monday, September 21, 2015:

To convert entire database, see this.

5

merlinsilk wrote on Tuesday, September 22, 2015:

Thank you all so much - got it all squared out. - M