OpenEMR-4.1.1 release: external dataloads sec

Management and Administration
1

fndtn357 wrote on Saturday, September 01, 2012:

tried to install ICD9 Staged Release : csmv30_master_descriptions.zip
ERROR: query failed: LOAD DATA LOCAL INFILE ‘/tmp/ICD9/CMS30_DESC_SHORT_DX.txt’ INTO TABLE icd9_dx_code FIELDS TERMINATED BY ‘’ (@var) SET revision = 0, dx_code = trim(Substring(@var, 1, 5)),short_desc = trim(Substring(@var, 7, 60))
Error: The used command is not allowed with this MySQL version

install ICD10 Staged Release : 2012_PCS_long_and_abbreviated_title.zip, DiagnosisGEMS_2012.zip, ICD10OrderFiles_2012.zip, ProcedureGEMS_2012.zip, ReimbursementMapping._2012.zip
ERROR: query failed: LOAD DATA LOCAL INFILE ‘/tmp/ICD10/icd10pcs_order_2012.txt’ INTO TABLE icd10_pcs_order_code FIELDS TERMINATED BY ‘’ (@var) SET revision = 0, pcs_code = trim(Substring(@var, 7, 7)),valid_for_coding = trim(Substring(@var, 15, 1)),short_desc = trim(Substring(@var, 17, 60)),long_desc = trim(Substring(@var, 78, 300))
Error: The used command is not allowed with this MySQL version

UPDATE: mysql  Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2

2

anonymous wrote on Sunday, September 02, 2012:

I have the same exact problem. Good thing I tested the update on Virtualbox though.

I started Ubuntu 11.10 and updated to 12.04.1 after installing the new OpenEMR on my Virtualbox. This updated everything to the latest version, including to the latest mysql.  Same exact error. What version of 5.5 is the external dataload supporting? And how do we install that version of mysql from an update?

3

anonymous wrote on Sunday, September 02, 2012:

I meant to say btw that I updated from 4.1.0(13) to 4.1.1 as per instructions on the Wiki. Then upgraded Ubuntu 11.10 to 12.04.1

4

mcaloon wrote on Sunday, September 02, 2012:

Hello,
     My testing was done using:

mysql  Ver 14.14 Distrib 5.5.22, for osx10.6 (i386) using readline 5.1

I did not run into this error during any of my testing.

Mac

5

bradymiller wrote on Sunday, September 02, 2012:

Hi,
Bug fix is described on this thread:
http://sourceforge.net/projects/openemr/forums/forum/202506/topic/5598755
-brady
OpenEMR