Error on upgrading old database

dkdipak1 wrote on Monday, February 09, 2015:

Dear Team,

I tried upgrading 4.1.2 to 4.2.0, everything went well. Thanks to detailed wiki creators. However, on upgrading to old data i got the errors and that led , the “module” from left navigation removed. and when I click on globals I get these errors: please help.

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

C:\xampp\htdocs\openemr\library\translation.inc.php at 36:sqlStatementNoLog
C:\xampp\htdocs\openemr\library\globals.inc.php at 2022:xl(Māori)
C:\xampp\htdocs\openemr\interface\super\edit_globals.php at 12:require_once(C:\xampp\htdocs\openemr\library\globals.inc.php)

Thanks,
Dipak

visolveemr wrote on Monday, February 09, 2015:

Hello Dipak

You can look into these solutions mentioned in this link and to avoid this issue in future follow the instruction discussed here.

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

blankev wrote on Monday, February 09, 2015:

Be sure to have PHP upgraded to a version higher than 5.3 It helped me with the Left menu invisible screen. Need to do a reboot to get things working after the PHP upgrade.

This is probably also mentioned it the suggested links