paanii13 wrote on Wednesday, July 27, 2011:
After installing the most recent openEMR, I noticed that out immunization data was gone. I checked the database to see if the data was truly deleted, and thankfully the data was still there. I replaced the new immunizations.php file with the previous version but the problem still persists. However, now I can view the immunization history on the edit page.
Has anyone encountered this problem yet?
bradymiller wrote on Thursday, July 28, 2011:
Hi,
This is likely a bug. For 4.0 we now support standardized CVX immunization labeling, however the code was also written to continue to support the previous way of labeling immunizations. There was recently an unrelated bug fix in this code and I suspect this is what is causing your behavior. Will plan to look into it and will ensure it’s fixed before the official 4.1 release (also feel free to post a bug in the tracker).
-brady
bradymiller wrote on Tuesday, August 23, 2011:
Hi,
Just committed the fix for this to sourceforge. Please try it out and let us know if it corrects your problem:
http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=commitdiff;h=b59c069b4aedf512e0f91986e18deb6b8f29a4ba
thanks,
-brady
OpenEMR
sunsetsystems wrote on Tuesday, August 30, 2011:
By the way, where are the CVX codes? I see a code type for them but nothing to load them. Also the Immunizations list has a column to refer to them but no values in that column.
Incidentally there is a typo in the header for that list, it says “ CVX Code Mapping”.
bradymiller wrote on Tuesday, August 30, 2011:
Hi Rod,
They are loaded on new installations from the file:
cvx_codes.sql
and also during ugprades from the normal upgrade sql file.
The immunization list column is to allow users to map their current immunizations to a cvx immunization (when you click save it will actually insert the applicable cvx code into each applicable immunization record).
Oddly, I’m not seeing the “ CVX Code Mapping” on current master branch with firefox 6 on windows (server is ubuntu).
-brady
sunsetsystems wrote on Tuesday, August 30, 2011:
Might be browser-dependent. A View Source of the frame includes this line:
<td><b>    CVX Code Mapping</b></td>
Semicolons are missing.
I’ll have to check why the CVX codes did not get loaded on the site that I upgraded.
bradymiller wrote on Tuesday, August 30, 2011:
Hi Rod,
My bad on the nbsp semicolons; just fixed this and committed to sourceforge master and rel-410 branches.
-brady
drbowen wrote on Tuesday, September 06, 2011:
OpenEMR 4.1.0 dev-tip.
Something is seriously wrong with the immunizations query. We seem to be getting an infinitely repeating loop on the script that reports the immunizations on the demographics page. The data seems to inserted correctly into the immunizations table (only 3 new rows).
When I look at one of the affected patients the “immunization” area looks like it contains several hundred to a few thousand CPT codes (I think), followed by lots of HCPCs codes, Then finally dozens of “Influenza 1” records. All of these have todays day on each line:
2011-09-03 - Presbyopia-correct funct
…
2011-09-03 - Knee-shin exo variable f
…
2011-09-03 - Influenza 1
This bug seems to associated with leaving out the cvx_code. This abnormal behavior only occurs if the cvx-code is left blank and not other patient where it was entered correctly.
Sam Bowen, MD
drbowen wrote on Tuesday, September 06, 2011:
Doesn’t it seem that the cvx_code should be a required field?
Sam Bowen, MD
bradymiller wrote on Wednesday, September 07, 2011:
Hi,
This should work with both a entered and blank CVX code (to support previous versions). Note there is a way to map immunizations to cvx codes in the Adminsitration->Lists.
That being said, obviously something is seriously wrong with the query. I just committed something to the queries that may fix this. If still having issues, test the query in the patient demographics, immunization screen, and the Print (PDF or HTML) immunizations from the immunization screen.
Also, were the CVX codes imported into your codes table during the upgrade?
-brady
drbowen wrote on Wednesday, September 07, 2011:
The cvx_codes were loaded with the upgrade. I think the problem arose from two of our lower performing assistants not taking the time to learn which was the correct code. I have solved the problem with staff education but the query still needs to be fixed.
Sam Bowen, MD
bradymiller wrote on Thursday, September 08, 2011:
Hi,
I can’t recreate the specific problem your having, but am noting another issue if do not place anything in the Immunization (CVX Code) entry on the immunization entry screen. So, agree, that input into this field needs to be mandatory (when it is shown).
-brady
bradymiller wrote on Tuesday, September 13, 2011:
Hi,
Just committed a fix to sourceforge(both master and rel-410 branches( that makes the cvx_code field required.
-brady
voipbound wrote on Wednesday, November 30, 2011:
I have having this error…
ERROR: query failed: select i1.id as id, i1.immunization_id as immunization_id, i1.cvx_code as cvx_code, c.code_text_short as cvx_text, if (i1.administered_date, concat(i1.administered_date,’ - '), substring(i1.note,1,20)) as immunization_data from immunizations i1 left join codes c on CAST(IFNULL(i1.cvx_code,0) AS CHAR) = c.code left join code_types ct on c.code_type = ct.ct_id where i1.patient_id = ? AND (( i1.cvx_code = ‘0’ OR i1.cvx_code IS NULL ) OR ( ( i1.cvx_code != ‘0’ AND i1.cvx_code IS NOT NULL ) AND ct.ct_key = ‘CVX’) ) order by i1.administered_date desc
Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’
This is after upgrading from 4.0 to 4.1.0. Does anyone have any idea how I can fix this problem. It’s just irritating to see. BTW I am Ubuntu, mysql 5.1, and apache
bradymiller wrote on Thursday, December 01, 2011:
Hi,
This issue and how to fix it is covered here:
http://sourceforge.net/projects/openemr/forums/forum/202504/topic/4722200
-brady
robik62 wrote on Monday, May 13, 2013:
After installing the Latest openEMR 4.1.1 in october2012 just found out when running immunization report - report shows only immunizations done before upgrade and nothing after upgrade was done, is there a solution to fix it?