ICD10 Installation Error


#1

Hello I’m using OpenEMR
Version Number: v5.0.1 (7)

OS: Mint 19.1
Browser, Firefox and Chromium

Hello I did a fresh install of OpenEMR on Mint and found that I could not search for ICD 10 or CPT codes in Fee Sheet. Do I have to enable anything to make it work?

Update. It seemed that I didn’t install ICD10.

However I have trouble when trying to install

Admin -> External Load Data -> ICD10 -> Install

icd10_querry_error

I followed the link and downloaded the 4 files.

Went to phpmyadmin and copy and paste the following into sql

INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-Order-File.zip", "264b342310236f2b3927062d2c72cfe3"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-CM-General-Equivalence-Mappings.zip", "787a025fdcf6e1da1a85be779004f670"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-Code-Descriptions.zip", "6f9c77440132e30f565222ca9bb6599c"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-General-Equivalence-Mappings.zip", "bb73c80e272da28712887d7979b1cebf");

Output

Back to External Load_data and this came up


I also tried to use command

mysql -u root -p openemr -e "INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-PCS-Order-File.zip', '264b342310236f2b3927062d2c72cfe3'); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-CM-General-Equivalence-Mappings.zip', '787a025fdcf6e1da1a85be779004f670'); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-Code-Descriptions.zip', '6f9c77440132e30f565222ca9bb6599c'); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-PCS-General-Equivalence-Mappings.zip', 'bb73c80e272da28712887d7979b1cebf');"

It still gives me the same problem

Additional information
root@test-pc:/home/test# sudo ls -lrt /var/www/openemr/contrib/icd10
total 6712
-rw-rw-r-- 1 www-data www-data 126 Sep 29 2018 README
-rw-rw-r-- 1 www-data www-data 1640538 Jul 7 16:56 2018-ICD-10-PCS-Order-File.zip
-rw-rw-r-- 1 www-data www-data 1114989 Jul 7 16:56 2018-ICD-10-CM-General-Equivalence-Mappings.zip
-rw-rw-r-- 1 www-data www-data 2775671 Jul 7 16:56 2018-ICD-10-Code-Descriptions.zip
-rw-rw-r-- 1 www-data www-data 1327378 Jul 7 16:56 2018-ICD-10-PCS-General-Equivalence-Mappings.zip

Here is the folder of contribution


(Brady Miller) #3

hi @cornutaurus ,
See this thread:
New php default setting of mysqli.allow_local_infile that will be causing issues


#4

Thank you. Got it to work