sure, have you tried this Upgrade icd10 code set ?
I ran mysql under root console and got an error of 1064 (42000) at line 1: you have an error in your sql syntax. So I tried running the same thing in my PHPadmin without the quotes and it seemed to run fine. When I go to the external database tab and click on ICD 10, I don’t see an upgrade button to run the upgrade. Is it done or did I miss something?
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