maybe missed something, you should see this
Installed Release
Name: ICD10
Revision: CMS
Release Date: 2017-10-01
The installed version and the staged files are the same.Nope it didn’t work then. I still have
Installed Release
Name: ICD10
Revision: CMS
Release Date: 2014-10-01
Staged Releases
2018-ICD-10-CM-General-Equivalence-Mappings.zip
2018-ICD-10-Code-Descriptions.zip
2018-ICD-10-PCS-General-Equivalence-Mappings.zip
2018-ICD-10-PCS-Order-File.zip
Reimbursement_Mapping_dx_2015.zip
Reimbursement_Mapping_pr_2015.zip
The staged files release dates are not all from the same release.
Follow these instructions for installing or upgrading the following database: ICD10
hi @CalvinTy, try to go through each of these steps and report back if one fails
this might be easier for the sql step
mysql -u [username] -p [dbname] -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");"Yup… That’s how I did it. After I downloaded all the 4 files and cleared out all previous zipped codes in ./contri/ICD10 folder, I copy & paste this
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”);
into my PHPMyAdmin sql query. I didn’t get any error. But when I go to external data, no upgrade button
I tried your suggestion above and I get an error 1064 (42000) at line 1: you have an error in your SQL syntax; check the manual that corresponds to your server version.
My SQL server version is 14.14 & PHP is 5.3.10
ok, please try this
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');"
and please make sure to copy the downloaded 2018 files to the contrib/icd10 folder
Thank you so much for your help and patience. I have deleted everything from that folder and downloaded the 4 zip files again. I applied your second mysql command by copy & paste and nothing. So strange… no error output but didn’t take either.
it’s pesky :), it should have prompted you for a password at least (-p option)
after you download the zip files you have to move them to the openemr/contrib/icd10 folder in case you forgot to do that
It did. then nothing. I downloaded the files directly into the icd10 folder.
ok, then it took 
you can navigate to the admin->other->external data load
it didn’t take. Here is the current version
Installed Release
Name: ICD10
Revision: CMS
Release Date: 2014-10-01
Staged Releases
2018-ICD-10-CM-General-Equivalence-Mappings.zip
2018-ICD-10-Code-Descriptions.zip
2018-ICD-10-PCS-General-Equivalence-Mappings.zip
2018-ICD-10-PCS-Order-File.zip
The number of staged files is incorrect. Only place the files that you wish to install/upgrade to.
Follow these instructions for installing or upgrading the following database: ICD10
remove all files except those downloaded
Exactly, I have just those 4 files in the folder
might be a permissions problem on the files
What do you think the permission problem? I have Ubuntu. Last check, everything is root “chown”. What is everyone’s file ownership?
most everyone uses www-data:
also dbl check the file names match the sql statements
I think that has been the problem with this whole ordeal. I’ll try it in the morning and will let the members here know. I am still puzzled in that during the installation process, when do people set their privileges to www-data. After install, I get root. Now, I need to refresh my memory on how to chown the directory and subdirectories… Crazy
it’s usually the last step in securing the code base, chown -R www-data: /var/www/html/openemr works on current ubuntu
dbl check on 12.04, openemr might be under /var/www
after chown this AM, it is still not a go. However, it did solve my other problem with running sql_upgrade.php
hi @CalvinTy, sorry, forgot you’re on 4.2.0, there’s some code level changes, you probably should upgrade to 5.0.0 and then do the icd10 upgrade
here’s the code change from 2016 2016 and 2017 ICD10 Updates