# I'm not able to install ICD10 in my OpenEMR 5.0.0 **URL:** \ **Category:** Support\ **Created:** [October 28, 2018, 7:39am UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938 "2018-10-28T07:39:41Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Quantice](https://community.open-emr.org/user_avatar/community.open-emr.org/quantice/32/14668_2.png) [@Quantice](https://community.open-emr.org/u/Quantice)\ **Post date:** [October 28, 2018, 7:39am UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/1 "2018-10-28T07:39:41Z")
**Situation** 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) **OpenEMR Version** I’m using OpenEMR version 5.0.0 **Browser** : I’m using Google Chrome **Operating System** I’m using Windows 10. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [October 28, 2018, 3:44pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/2 "2018-10-28T15:44:11Z")
hi @Quantice, try admin-\>other-\>External data loads to install the icd10 version native to 5.0.0 to upgrade to latest release see this [2019 ICD10 Update](https://community.open-emr.org/t/2019-icd10-update/10833/2?u=stephenwaite) ---
**Author:** ![Quantice](https://community.open-emr.org/user_avatar/community.open-emr.org/quantice/32/14668_2.png) [@Quantice](https://community.open-emr.org/u/Quantice)\ **Post date:** [October 29, 2018, 1:14pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/3 "2018-10-29T13:14:11Z")
@stephenwaite I had followed the process of installation before posting here for help. The error I have highlighted above still persists. Do you think there is any other way? Thank you. ---
**Author:** ![brady.miller](https://community.open-emr.org/user_avatar/community.open-emr.org/brady.miller/32/10178_2.png) [@brady.miller](https://community.open-emr.org/u/brady.miller)\ **Post date:** [October 29, 2018, 1:25pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/4 "2018-10-29T13:25:22Z")
hi @Quantice , Some shared hosting services do not allow LOAD DATA LOCAL INFILE command. See the section here for when that is the case: [https://www.open-emr.org/wiki/index.php/Import\_Standard\_Tables#Import.2FUpgrade\_and\_activate\_ICD10](https://www.open-emr.org/wiki/index.php/Import_Standard_Tables#Import.2FUpgrade_and_activate_ICD10) (there is a link to a text file there that you’ll need to import into your database; note this ICD10 code set is from about 4 years ago, but at least you’ll have something) -brady ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [October 29, 2018, 2:56pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/5 "2018-10-29T14:56:25Z")
thanks @Quantice, @brady.miller , here’s a link for the sql import for 2019, [https://www.dropbox.com/s/fgxdmw51r2w3one/icd10\_oe.zip?dl=0](https://www.dropbox.com/s/fgxdmw51r2w3one/icd10_oe.zip?dl=0) ---
**Author:** ![Quantice](https://community.open-emr.org/user_avatar/community.open-emr.org/quantice/32/14668_2.png) [@Quantice](https://community.open-emr.org/u/Quantice)\ **Post date:** [October 30, 2018, 12:45pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/6 "2018-10-30T12:45:52Z")
@brady.miller @stephenwaite I honestly thank you. Let me try all when I’m successful I will let you know. ---
**Author:** ![Quantice](https://community.open-emr.org/user_avatar/community.open-emr.org/quantice/32/14668_2.png) [@Quantice](https://community.open-emr.org/u/Quantice)\ **Post date:** [October 30, 2018, 2:08pm UTC](https://community.open-emr.org/t/im-not-able-to-install-icd10-in-my-openemr-5-0-0/10938/7 "2018-10-30T14:08:51Z")
@brady.miller and @stephenwaite Kindly receive my honest thanks, I’m sorted. Thank you again.