# Error in Immunizations

**URL:** <https://community.open-emr.org/t/error-in-immunizations/1256>\
**Category:** Management and Administration\
**Created:** [April 1, 2014, 10:32pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256 "2014-04-01T22:32:55Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 1, 2014, 10:32pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/1 "2014-04-01T22:32:55Z")

</div>

**[nursejeff](https://sourceforge.net/u/nursejeff/)** wrote on [Tuesday, April 01, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#6e70):

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 2, 2014, 11:45am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/2 "2014-04-02T11:45:16Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Wednesday, April 02, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#0c78):

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

Don’t know where to fix it.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 2, 2014, 11:30pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/3 "2014-04-02T23:30:09Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Wednesday, April 02, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#8ec7):

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](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)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 2, 2014, 11:43pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/4 "2014-04-02T23:43:53Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Wednesday, April 02, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#1fd5):

add  
",i1.expiration\_date " . to the end of this line:

> <https://github.com/stephenwaite/openemr/blob/master/library/immunization_helper.php#L35>

and then replace this

> <https://github.com/stephenwaite/openemr/blob/master/interface/patient_file/summary/shot_record.php#L76-L77>

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 2:21am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/5 "2014-04-03T02:21:57Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#e015):

> <https://github.com/stephenwaite/openemr/commit/3480bdf01dd4573f8bade5720158152e91862dc6>

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 1:55pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/6 "2014-04-03T13:55:08Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#4e59):

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.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 2:21pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/7 "2014-04-03T14:21:30Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#659e):

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 3:12pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/8 "2014-04-03T15:12:03Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#9cae):

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 3:22pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/9 "2014-04-03T15:22:58Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#446e):

did you restart apache2?

sudo service apache2 restart

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 5:57pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/10 "2014-04-03T17:57:55Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#a63d):

_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._

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 6:57pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/11 "2014-04-03T18:57:21Z")

</div>

**[cmswest](https://sourceforge.net/u/cmswest/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#960a):

avec plaisir

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 3, 2014, 11:32pm UTC](https://community.open-emr.org/t/error-in-immunizations/1256/12 "2014-04-03T23:32:20Z")

</div>

**[jcahn2](https://sourceforge.net/u/jcahn2/)** wrote on [Thursday, April 03, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#a63d/7fe4):

From the dreaded command line:

sudo apache2ctl graceful

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 4, 2014, 12:02am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/13 "2014-04-04T00:02:54Z")

</div>

**[jackfruit501](https://sourceforge.net/u/jackfruit501/)** wrote on [Friday, April 04, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#702f):

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.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 4, 2014, 10:47am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/14 "2014-04-04T10:47:30Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Friday, April 04, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#a63d/7fe4/b4b9):

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.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 4, 2014, 10:53am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/15 "2014-04-04T10:53:51Z")

</div>

**[fsgl](https://sourceforge.net/u/fsgl/)** wrote on [Friday, April 04, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#702f/9e12):

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.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 5, 2014, 3:26am UTC](https://community.open-emr.org/t/error-in-immunizations/1256/16 "2014-04-05T03:26:12Z")

</div>

**[bradymiller](https://sourceforge.net/u/bradymiller/)** wrote on [Saturday, April 05, 2014](https://sourceforge.net/p/openemr/discussion/202505/thread/81b591c7/#416a):

Hi Stephen,

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

-brady  
[OpenEMR](http://www.open-emr.org/)