Error in Immunizations

nursejeff wrote on Tuesday, April 01, 2014:

I have noticed a problem when printing the immunization record.

When the document is printed the Expiration Date is incorrectly today’s date.

Can anyone confirm this.

Jeff Guillory Jr.
NP Health Clinic

fsgl wrote on Wednesday, April 02, 2014:

It’s a bug either printing in PDF or HTML.

Don’t know where to fix it.

cmswest wrote on Wednesday, April 02, 2014:

researching this and couldn’t load imms in my test system then realized that i hadn’t set default timezone in php.ini file

this is a nice link: http://open-emr.org/wiki/index.php/Common_Installation_Problems

anyways, i will continue debugging(hopefully the missing expiration date and not my own personal problems)

cmswest wrote on Wednesday, April 02, 2014:

add
",i1.expiration_date " . to the end of this line:

and then replace this

with this:

if (isset($row[‘expiration_date’])) {
$temp_date = new DateTime($row[‘expiration_date’]);
$data[$current][xl(‘Expiration’) . “\n” . xl(‘Date’)] = $temp_date->format(‘Y-m-d’);
}
else{
$data[$current][xl(‘Expiration’) . “\n” . xl(‘Date’)] = ‘’;//$temp_date->format(‘Y-m-d’);
}

sorry about lousy formatting

cmswest wrote on Thursday, April 03, 2014:

fsgl wrote on Thursday, April 03, 2014:

Thanks, Stephen for the fix.

Thought I try it out on my test copy. Jeff and I were aware of the timezone problem from another thread.

Got nowhere fast because the json extension is missing, There is no access to the database. Not knowing what exactly is amiss, I would guess it is one of the dependencies. The GDebi Installer can be hit or miss. If all else fails, I’ll re-install Brady’s package.

Not a big deal because it’s the test copy. Really glad, however, the production copy is on a Windows device.

cmswest wrote on Thursday, April 03, 2014:

try this from the terminal apt-get install php5-json

fsgl wrote on Thursday, April 03, 2014:

Json installed successfully, but exactly the same error message preventing access to the database. Must be missing other stuff.

cmswest wrote on Thursday, April 03, 2014:

did you restart apache2?

sudo service apache2 restart

fsgl wrote on Thursday, April 03, 2014:

Les gens de la Nouvelle-Angletere sont les meilleurs!

Xampp Control had always been a guide post in Windows. Usually would remember to turn Apache off and on, but no such animal in Linux Mint.

Now have access to phpMyAdmin and bug fixed for both PDF and HTML printing.

Mille grazie.

cmswest wrote on Thursday, April 03, 2014:

avec plaisir

jcahn2 wrote on Thursday, April 03, 2014:

From the dreaded command line:

sudo apache2ctl graceful

will restart apache without hurting anyone’s feelings (will only restart apache if it is inactive).

jackfruit501 wrote on Friday, April 04, 2014:

I wonder if cmdline $’ sudo /etc/init.d/mysql restart ’ will help. I had to reboot or to do this and to restart apache2 as well everytime I upgrade/update any emr.

fsgl wrote on Friday, April 04, 2014:

The Terminal is like old crusty professors in medical school with the demeanor of the Old Testament God but the best interests of students in their hearts.

fsgl wrote on Friday, April 04, 2014:

Makes sense to do both after an upgrade.

In this case because changes occurred only in the apache2 folder, I would think that only one restart was required.

bradymiller wrote on Saturday, April 05, 2014:

Hi Stephen,

Thanks for the fix. Committed it to the codebase and it will be in the next 4.1.2 patch.

-brady
OpenEMR