no need to keep the brackets, your db name is openemr and the username and password is the mysql credentials
you could test connecting to the mysql engine first with
mysql -u root -p openemr
and then you should be prompted for the mysql password which might be empty so just hit enter
I tried the commands you listed on XAMPP shell and it is giving me the following error message…
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘Order-File.zip, 264b342310236f2b3927062d2c72cfe3)’ at line 1
Did I do something wrong?
no, sorry, think we’re missing a double quote at the very end of the above posted command; i’ve corrected it
It worked!
Right now I am trying to actually install the new codes…
AND IT WORKED!
It just finished installing the new ICD 10 codes!
Thank you very much for being so patient and resolve this problem with me!
Thank you!
I am using 4.2.0 on Ubuntu 12LTS and I can’t upgrade the ICD10 codes. Can you help me too?
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