I have been trying to install ICD10 in my OpenEMR 5.0.0 in openEMR 5.0.0 but got disappointed by the error below. I have hosted my EMR in a shared server. Kindly help. Thanks.
ERROR: query failed: LOAD DATA LOCAL INFILE ‘/tmp/ICD10/2017_I10gem.txt’ INTO TABLE icd10_gem_dx_10_9 FIELDS TERMINATED BY ‘’ (@var) SET revision = 0, dx_icd10_source = trim(Substring(@var, 1, 7)),dx_icd9_target = trim(Substring(@var, 9, 5)),flags = trim(Substring(@var, 15, 5))
Error: The used command is not allowed with this MySQL version
/home/iyompqhj/public_html/clinicinfo/library/standard_tables_capture.inc at 363:sqlStatement
/home/iyompqhj/public_html/clinicinfo/interface/code_systems/standard_tables_manage.php at 102:icd_import(ICD10)
I’m using OpenEMR version 5.0.0
I’m using Google Chrome
I’m using Windows 10.