Difference between revisions of "OpenEMR Patches"

From OpenEMR Project Wiki
(43 intermediate revisions by the same user not shown)
Line 1: Line 1:
= <center>5.0.0 Patch (11/10/17)</center> =
= <center>5.0.2 Patch (8/11/20)</center> =
<span style="color:red;">'''This patch is for OpenEMR version 5.0.0. If you are using a prior OpenEMR version, then you can find most recent patch [[Old_Outdated_OpenEMR_Patches|HERE]] or find out how to upgrade to 5.0.0 [[OpenEMR_Upgrade_Guides|HERE]].'''</span>
<br>
<br>
<br>
=== Download link ===
=== Download link ===
<googa>http://www.open-emr.org/patch/5-0-0-Patch-6.zip|5-0-0-Patch-6.zip|/download/file/patch_5_0_0</googa>
<googa>https://www.open-emr.org/patch/5-0-2-Patch-4.zip|5-0-2-Patch-4.zip|/download/file/patch_5_0_2</googa>
<br>
<br>
<br>
<br>


=== Description ===
=== Description ===
This is the 6th patch. There are 35 files that are changed and this patch also includes the changes from prior patches. '''Please read through the [[OpenEMR_Patches#List_of_files_(5.0.0)|list of modified files]] to ensure you haven't customized any of these, since this will copy over this.'''
This is the 4th patch and also includes changes from prior patches. '''Please read through the [[OpenEMR_Patches#List_of_files_(5.0.2)|list of modified files]] to ensure you haven't customized any of these, since this will copy over this.'''
<br>
<br>
<br>
<br>
Line 19: Line 17:
:::(this script will run automatically and patch the database)
:::(this script will run automatically and patch the database)
:::(if you are using the [[OpenEMR_Multiple_Sites_Module|Multisite Module]], then skip step 2 and [[OpenEMR_Multiple_Sites_Module#Patches|follow these instructions]])
:::(if you are using the [[OpenEMR_Multiple_Sites_Module|Multisite Module]], then skip step 2 and [[OpenEMR_Multiple_Sites_Module#Patches|follow these instructions]])
:3. Remove the setup.php file from the openemr web directory (if you need this file in the future, then can download it at [https://raw.githubusercontent.com/openemr/openemr/rel-500/setup.php setup.php]).
:3. Delete the sql_patch.php file from the openemr web directory


==== Linux ====
==== Linux ====
:1. Move the patch file to the openemr web directory, then type 'unzip 5-0-0-Patch-5.zip', and confirm ok to copy over files.
:1. Move the patch file to the openemr web directory, then type 'unzip 5-0-2-Patch-4.zip', and confirm ok to copy over files.
:2. Open web browser and go to <nowiki>http://your_server_name_or_ip/openemr/sql_patch.php</nowiki>
:2. Open web browser and go to <nowiki>http://your_server_name_or_ip/openemr/sql_patch.php</nowiki>
:::(this script will run automatically and patch the database)
:::(this script will run automatically and patch the database)
:::(if you are using the [[OpenEMR_Multiple_Sites_Module|Multisite Module]], then skip step 2 and [[OpenEMR_Multiple_Sites_Module#Patches|follow these instructions]])
:::(if you are using the [[OpenEMR_Multiple_Sites_Module|Multisite Module]], then skip step 2 and [[OpenEMR_Multiple_Sites_Module#Patches|follow these instructions]])
:3. Remove the setup.php file from the openemr web directory (if you need this file in the future, then can download it at [https://raw.githubusercontent.com/openemr/openemr/rel-500/setup.php setup.php]).
:3. Delete the sql_patch.php file from the openemr web directory
<br>
<br>


=== Fixes and New Features ===
=== Fixes and New Features ===
(note the ones with ** are new with this patch):
(note the ones with ** are new with this patch):
*Critical security fix - reported by Sven Krewitt, fixed by Brady**
*Patient portal improvements - by Jerry Padgett**
*Fix backup module - fixed by Brady**
*Dicom viewer improvements  - by Jerry Padgett**
*Critical security fix - reported by Isaac Sears, fixed by Brady
*Performance improvements -  by Jerry Padgett**
*Fix in Patient PDF report regarding vital signs - reported by Arnab, fixed by Jerry
*PHP 7.4 fixes - fixed by Jerry Padgett**
*Support all diagnostic codes (including ICD10) in post payments - reported by Kim, fixed by Stephen
*Document module fix - reported by Pete Boyd and fixed by Tyler Wrenn**
*Fix delete patient- reported by Terry and APerez; fixed by Stephen
*Calendar fixes - fixed by Jerry Padgett**
*Fix for duplicate procedures in the procedure order edit form - reported by Sherwin and A1Gard, fixed by Sunset systems
*Encounter fixes - fixed by Jerry Padgett**
*Fix for tabs layout in Edge browser - reported by Sunset Systems, fixed by Jerry
*Billing fixes - fixed by Jerry Padgett and Stephen Waite**
*Fix to allow multiple codes of same code type on the layout billing code widget - reported by Alfonso, fixed by Brady
*API fix - fixed by by Stephen Waite**
*Fix dated reminders to show message when forward it - fixed by Matrix
*ICD10 and RxNorm import fixes - fixed by by Stephen Waite**
*Fix to prevent unnecessary encoding errors during upgrade and globals editing - fixed by Brady
*SameSite browser warning fixes - fixed by Brady Miller**
*Fix drawable images in layout based forms with larger image sizes - reported by aperez, fixed by Sunset Systems
*Patient Portal fixes - reported by and fixed by Jerry Padgett
*Fixes for Eye form - fixed by Ray
*MariaDB 10.4 compatibility fix - reported by travis and fixed by Brady Miller
*Fix patient report tool for code_text. - fixed by Daniel
*Encounter improvements -  by Jerry Padgett
*Fix patient report tool for vitals - reported by Arnab, fixed by Arnab, Jerry and Matthew
*Calendar improvement - by Stephen Waite
*Fix fee sheet - reported by Carlos, fixed by Terry
*Billing fix - reported by and fixed by Stephen Waite
*Fix past appointments widget in patient summary screen - fixed by epsdky
*Pharmacy import fix - reported by and fixed by Stephen Waite
*Fix registration feature - reported by Arnab, fixed by Jerry
*Critical security fix - reported by Dennis Brinkrolf (RIPS Technologies), fixed by Jerry Padgett and Brady Miller
*Security fixes - fixed by Brady. The OpenEMR team thanks Wan Ikram, Fikri Fadzil and Jasveer Singh from SEC Consult Vulnerability Lab (https://www.sec-consult.com/) for responsibly reporting the identified issues and working with us as we addressed them.
*Security fixes - reported by Dennis Brinkrolf (RIPS Technologies), Daniel Pflieger, and Visolve, fixed by Jerry Padgett and Brady Miller
*Fix to patient PDF report - reported by Arnab Naha, fixed by Brady Miller and epsdky
*COVID19 ICD10 codes added - by Stephen Waite
*Patient portal security improvements, updates and fixes - by Jerry Padgett
*API security improvements and updates - by Brady Miller and Stephen Waite
*Payment improvements - by Jerry Padgett
*MySQL 8 fix, part 1 - reported by Sanjeev Kumar, fixed by Brady Miller
*MySQL 8 fix, part 2 - reported by Tman and fixed by Amit Meena
*Calendar styling improvements - by Jerry Padgett
*Patient Portal styling improvements - by Jerry Padgett and Tyler Wrenn
*Referral form improvements - by Stephen Waite and Visolve
*Added diagnosis history finder for procedure order form - by Jerry Padgett
*Newcrop Rx improvements - by Ken Chapple
*Rx improvements - by Sherwin Gaddis
*MedEx fixes - by ophthal
*PDF fix - reported by Tyler Wrenn, fixed by Jerry Padgett
*Merge patient fix - reported by APerez, fixed by Brady Miller
*Date of birth autocomplete fix - reported by Philip Herrick, fixed by Stephen Waite
*ICD10 import fix - reported and fixed by Stephen Waite
*Fees checkout fix - reported by Evgenios, fixed by Stephen Waite
*Calendar fix - reported by and fixed by Stephen Waite
*Billing fix - reported by and fixed by Stephen Waite
*Billing statement fixes - reported by Stephen Waite, fixed by Jerry Padgett
*Billing fix in billing/service facility - reported by and fixed by Daniel Pflieger
*Messaging fix - reported by syedyawar and fixed by Visolve and Stephen Waite
*Modules fix - reported by and fixed by Jerry Padgett
*Zip code fix - reported by and fixed by Stephen Waite
*Transaction date fix - reported by and fixed by Sherwin Gaddis
*Fix functional and cognitive status form - reported by Pete Boyd and fixed by Stephen Waite
*Fix pharmacy import - reported by and fixed by Robert Hausam**
*Security fixes - reports by Will Porter ([https://lodestonesecurity.com/ from Lodestone Security]), Mera, Mirna Bassaly, and Brady Miller; fixes by Will Porter ([https://lodestonesecurity.com/ from *Lodestone Security]) and Brady Miller
*Added custom modules support - by Jerry Padgett
*MariaDB critical fix for install/upgrade - reported by Robert Down, fixed by Brady Miller
*Cookie and session fixes - reported by Jerry Padgett, fixed by Brady Miller
*Clear billing log feature added - by Sherwin Gaddis
*Billing manager updates - by Jerry Padgett
*Patient portal fixes - reported and fixed by Jerry Padgett
*CCDA fix - reported and fixed by Jerry Padgett
*Eye form fixes - reported and fixed by Ray Magauran
*User editing fix - reported and fixed by Sherwin Gaddis
*Patient history save fix - reported by CodderEMR, fixed by Stephen Waite
*Patient history fix - reported by Stephen Waite, fixed by Jerry Padgett
*Batch payment fixes - reported by Stephen Waite, fixed by zbig01
*837 claim fix - reported by Ray Magauran, fixed by Stephen Waite
*X12 fix - reported and fixed by Derrik Milligan
*Another X12 fix - reported by Ray Magauran, fixed by Stephen Waite
*Fee sheet fixes - reported by Stephen Waite and Ray Magauran, fixed by Jerry Padgett
*EOB invoice last bill date - reported and fixed by Stephen Waite
*API (patient service) fix - reported and fixed by Stephen Waite
*Code styling fix - reported and fixed by Brady Miller
*MedEx fix - reported and fixed by Jerry Padgett
*New patient add fix - reported by Jeremiah Ocasio, fixed by Stephen Waite
*Calendar scrolling fix - reported and fixed by Aaron Chantrill
*eRX fix - reported by Harley Tuck, fixed by Ken Chapple
*Save and dispense rx  fix - reported and fixed by Dimitry Remish
<br>
<br>


=== List of files (5.0.0) ===
=== List of files (5.0.2) ===
(note the ones prepended with * have new changes with this patch)
<pre>acknowledge_license_cert.html
<pre>acknowledge_license_cert.html
apis/dispatch.php
ci/ci.sh
composer.json
contrib/util/installScripts/InstallerAuto.php
controllers/C_Document.class.php
controllers/C_DocumentCategory.class.php
gacl/gacl_api.class.php
interface/batchcom/batchcom.inc.php
interface/billing/billing_process.php
interface/billing/billing_report.php
interface/billing/clear_log.php
interface/billing/edit_payment.php
interface/billing/new_payment.php
interface/billing/payment_master.inc.php
interface/billing/payment_pat_sel.inc.php
interface/billing/payment_pat_sel.inc.php
interface/fax/fax_dispatch.php
interface/billing/search_payments.php
interface/billing/sl_eob_invoice.php
interface/billing/sl_eob_search.php
interface/eRxStore.php
interface/eRxXMLBuilder.php
interface/forms/LBF/new.php
interface/forms/eye_mag/SpectacleRx.php
interface/forms/eye_mag/SpectacleRx.php
interface/forms/eye_mag/a_issue.php
interface/forms/eye_mag/a_issue.php
interface/forms/eye_mag/css/style.css
interface/forms/eye_mag/css/style.css
interface/forms/eye_mag/help.php
interface/forms/eye_mag/js/eye_base.php
interface/forms/eye_mag/js/eye_base.php
interface/forms/LBF/new.php
interface/forms/eye_mag/php/eye_mag_functions.php
interface/forms/eye_mag/save.php
interface/forms/eye_mag/view.php
interface/forms/fee_sheet/new.php
interface/forms/fee_sheet/review/fee_sheet_justify_view_model.js
interface/forms/fee_sheet/review/initialize_review.js
interface/forms/fee_sheet/review/initialize_review.php
interface/forms/fee_sheet/review/js/fee_sheet_core.js
interface/forms/functional_cognitive_status/save.php
interface/forms/newpatient/common.php
interface/forms/newpatient/save.php
interface/forms/procedure_order/new.php
interface/forms/procedure_order/new.php
interface/forms/vitals/report.php
interface/globals.php
*interface/main/backup.php
interface/login/login.php
*interface/main/backuplog.php
interface/main/backup.php
*interface/main/backuplog.sh
interface/main/calendar/add_edit_event.php
interface/main/calendar/modules/PostCalendar/pnincludes/Date/Calc.php
interface/main/calendar/find_patient_popup.php
interface/main/dated_reminders/dated_reminders_add.php
interface/main/calendar/modules/PostCalendar/pntemplates/default/user/ajax_search.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/day/ajax_template.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/header.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/month/ajax_template.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/week/ajax_template.html
interface/main/calendar/modules/PostCalendar/pnuserapi.php
interface/main/dated_reminders/dated_reminders.php
interface/main/main_info.php
interface/main/messages/css/reminder_style.css
interface/main/messages/js/reminder_appts.js
interface/main/messages/messages.php
interface/main/messages/save.php
interface/main/tabs/js/include_opener.js
interface/main/tabs/main.php
interface/main/tabs/menu/menus/standard.json
interface/main/tabs/templates/patient_data_template.php
interface/modules/zend_modules/config/application.config.php
interface/modules/zend_modules/module/Carecoordination/config/module.config.php
interface/modules/zend_modules/module/Installer/src/Installer/Controller/InstallerController.php
interface/modules/zend_modules/module/Installer/src/Installer/Model/InstModuleTable.php
interface/modules/zend_modules/module/Installer/view/installer/installer/configure.phtml
interface/modules/zend_modules/module/Installer/view/installer/installer/index.phtml
interface/modules/zend_modules/public/js/installer/action.js
interface/new/new_comprehensive.php
interface/orders/pending_followup.php
interface/orders/pending_orders.php
interface/orders/procedure_provider_edit.php
interface/orders/receive_hl7_results.inc.php
interface/orders/single_order_results.inc.php
interface/patient_file/download_template.php
interface/patient_file/encounter/find_code_history.php
interface/patient_file/encounter/forms.php
interface/patient_file/front_payment.php
interface/patient_file/front_payment_cc.php
interface/patient_file/history/encounters.php
interface/patient_file/history/history.php
interface/patient_file/history/history_save.php
interface/patient_file/merge_patients.php
interface/patient_file/pos_checkout.php
interface/patient_file/report/custom_report.php
interface/patient_file/report/custom_report.php
interface/patient_file/report/patient_report.php
interface/patient_file/summary/clinical_reminders_fragment.php
interface/patient_file/summary/create_portallogin.php
interface/patient_file/summary/demographics.php
interface/patient_file/summary/demographics.php
interface/product_registration/product_registration_service.php
interface/patient_file/summary/disc_fragment.php
interface/patient_file/summary/labdata_fragment.php
interface/patient_file/summary/lbf_fragment.php
interface/patient_file/summary/patient_reminders_fragment.php
interface/patient_file/summary/pnotes_fragment.php
interface/patient_file/summary/pnotes_full.php
interface/patient_file/summary/stats.php
interface/patient_file/summary/vitals_fragment.php
interface/patient_file/transaction/print_referral.php
interface/patient_file/transaction/record_request.php
interface/patient_file/transaction/transactions.php
interface/patient_tracker/patient_tracker.php
interface/reports/collections_report.php
interface/reports/insurance_allocation_report.php
interface/reports/ippf_cyp_report.php
interface/reports/pat_ledger.php
interface/reports/patient_list.php
interface/reports/receipts_by_method_report.php
interface/reports/sales_by_item.php
interface/reports/svc_code_financial_report.php
interface/super/edit_layout.php
interface/super/edit_list.php
interface/themes/ajax_calendar.css
interface/themes/tabs_style_compact.css
interface/themes/tabs_style_compact.css
interface/themes/tabs_style_full.css
interface/themes/tabs_style_full.css
library/appointments.inc.php
interface/usergroup/user_admin.php
library/calendar.inc
interface/usergroup/user_info.php
*library/classes/Installer.class.php
interface/usergroup/usergroup_admin.php
library/custom_template/ckeditor/_samples/assets/_posteddata.php
interface/usergroup/usergroup_admin_add.php
interface/weno/admin.php
interface/weno/import_pharmacies.php
interface/weno/pharmacyHelper.php
library/MedEx/API.php
library/MedEx/MedEx.php
library/MedEx/MedEx_background.php
library/ajax/dated_reminders_counter.php
library/ajax/facility_ajax_code.php
library/ajax/upload.php
library/amc.php
library/authentication/common_operations.php
library/authentication/login_operations.php
library/authentication/password_hashing.php
library/billrep.inc
library/classes/Installer.class.php
library/classes/TreeMenu.php
library/clinical_rules.php
library/custom_template/add_template.php
library/custom_template/ajax_code.php
library/dated_reminder_functions.php
library/dialog.js
library/dicom_frame.php
library/edihistory/edih_835_html.php
library/encounter_events.inc.php
library/encounter_events.inc.php
library/FeeSheet.class.php
library/formdata.inc.php
library/globals.inc.php
library/globals.inc.php
library/htmlspecialchars.inc.php
library/invoice_summary.inc.php
library/js/dwv/assets/dwv/decoders/dwv/decode-rle.js
library/js/dwv/assets/dwv/decoders/dwv/rle.js
library/js/dwv/assets/dwv/decoders/pdfjs/arithmetic_decoder.js
library/js/dwv/assets/dwv/decoders/pdfjs/decode-jpeg2000.js
library/js/dwv/assets/dwv/decoders/pdfjs/decode-jpegbaseline.js
library/js/dwv/assets/dwv/decoders/pdfjs/jpg.js
library/js/dwv/assets/dwv/decoders/pdfjs/jpx.js
library/js/dwv/assets/dwv/decoders/pdfjs/readme.md
library/js/dwv/assets/dwv/decoders/pdfjs/util.js
library/js/dwv/assets/dwv/decoders/rii-mango/decode-jpegloss.js
library/js/dwv/assets/dwv/decoders/rii-mango/lossless-min.js
library/js/dwv/assets/dwv/decoders/rii-mango/lossless.js
library/js/dwv/assets/dwv/decoders/rii-mango/readme.md
library/js/dwv/assets/dwv/dist/dwv.js
library/js/dwv/assets/dwv/dist/dwv.min.js
library/js/dwv/assets/dwv/locales/de/overlays.json
library/js/dwv/assets/dwv/locales/de/translation.json
library/js/dwv/assets/dwv/locales/en/overlays.json
library/js/dwv/assets/dwv/locales/en/translation.json
library/js/dwv/assets/dwv/locales/es/overlays.json
library/js/dwv/assets/dwv/locales/es/translation.json
library/js/dwv/assets/dwv/locales/fr/overlays.json
library/js/dwv/assets/dwv/locales/fr/translation.json
library/js/dwv/assets/dwv/locales/it/overlays.json
library/js/dwv/assets/dwv/locales/it/translation.json
library/js/dwv/assets/dwv/locales/jp/overlays.json
library/js/dwv/assets/dwv/locales/jp/translation.json
library/js/dwv/assets/dwv/locales/ro/overlays.json
library/js/dwv/assets/dwv/locales/ro/translation.json
library/js/dwv/assets/dwv/locales/ru/overlays.json
library/js/dwv/assets/dwv/locales/ru/translation.json
library/js/dwv/assets/dwv/locales/zh/overlays.json
library/js/dwv/assets/dwv/locales/zh/translation.json
library/js/dwv/assets/jszip/dist/jszip.js
library/js/dwv/assets/jszip/dist/jszip.min.js
library/js/dwv/dicom_gui.js
library/js/dwv/dicom_launcher.js
library/js/dwv/gui/resources/help/click.png
library/js/dwv/gui/resources/help/double_click.png
library/js/dwv/gui/resources/help/mouse_drag.png
library/js/dwv/gui/resources/help/mouse_wheel.png
library/options.inc.php
library/options.inc.php
library/patient_tracker.inc.php
library/options.js.php
library/report.inc
library/patient.inc
*setup.php
library/payment.inc.php
library/payment_jav.inc.php
library/pid.inc
library/sanitize.inc.php
library/smarty/plugins/function.dispatchPatientDocumentEvent.php
library/standard_tables_capture.inc
library/translation.inc.php
portal/_header.php
portal/account/account.lib.php
portal/account/account.php
portal/account/index_reset.php
portal/account/register.php
portal/add_edit_event_user.php
portal/assets/css/base.css
portal/assets/css/register.css
portal/assets/css/style.css
portal/get_patient_info.php
portal/home.php
portal/import_template_ui.php
portal/index.php
portal/lib/doc_lib.php
portal/lib/download_template.php
portal/messaging/messages.php
portal/patient/_app_config.php
portal/patient/_machine_config.php
portal/patient/fwk/libs/verysimple/Phreeze/GenericRouter.php
portal/patient/fwk/libs/verysimple/Phreeze/Phreezer.php
portal/patient/index.php
portal/patient/libs/Controller/OnsiteActivityViewController.php
portal/patient/libs/Controller/OnsiteDocumentController.php
portal/patient/libs/Controller/OnsitePortalActivityController.php
portal/patient/libs/Controller/PatientController.php
portal/patient/libs/Controller/PortalPatientController.php
portal/patient/libs/Controller/UserController.php
portal/patient/libs/Model/DAO/UserCriteriaDAO.php
portal/patient/libs/Model/DAO/UserDAO.php
portal/patient/libs/Model/DAO/UserMap.php
portal/patient/libs/Reporter/UserReporter.php
portal/patient/scripts/app.js
portal/patient/scripts/app/onsiteactivityviews.js
portal/patient/scripts/app/onsitedocuments.js
portal/patient/scripts/app/onsiteportalactivities.js
portal/patient/scripts/app/patientdata.js
portal/patient/scripts/model.js
portal/patient/templates/DefaultError404.tpl.php
portal/patient/templates/DefaultErrorFatal.tpl.php
portal/patient/templates/OnsiteDocumentListView.tpl.php
portal/patient/templates/PatientListView.tpl.php
portal/patient/templates/ProviderHome.tpl.php
portal/patient/templates/_Footer.tpl.php
portal/patient/templates/_FormsHeader.tpl.php
portal/report/pat_ledger.php
portal/sign/assets/signer_api.js
portal/sign/assets/signer_modal.php
portal/sign/assets/signer_modal.tpl.php
portal/sign/assets/signit.php
portal/sign/css/signer_modal.css
portal/sign/lib/save-signature.php
portal/sign/lib/show-signature.php
sites/default/referral_template.html
sites/default/statement.inc.php
sql/5_0_1-to-5_0_2_upgrade.sql
sql/database.sql
sql/database.sql
sql/patch.sql
sql/patch.sql
*version.php</pre>
src/Billing/Claim.php
src/Billing/X12_5010_837P.php
src/Common/Crypto/CryptoGen.php
src/Common/Http/oeHttpRequest.php
src/Common/Session/SessionUtil.php
src/Common/Utils/RandomGenUtils.php
src/Core/ModulesApplication.php
src/Events/PatientDocuments/PatientDocumentEvent.php
src/Events/PatientReport/PatientReportEvent.php
src/Pharmacy/Services/ImportPharmacies.php
src/RestControllers/AuthRestController.php
src/Services/Globals/GlobalSetting.php
src/Services/InsuranceCompanyService.php
src/Services/PatientService.php
templates/documents/general_list.html
templates/documents/general_upload.html
templates/documents/general_view.html
templates/prescription/general_edit.html
version.php</pre>
<br>
<br>
<br>
<br>

Revision as of 06:42, 11 August 2020

5.0.2 Patch (8/11/20)


Download link

5-0-2-Patch-4.zip

Description

This is the 4th patch and also includes changes from prior patches. Please read through the list of modified files to ensure you haven't customized any of these, since this will copy over this.

Installation instructions

Windows

1. Extract the zipped file into the openemr web directory, and say yes to copying over files
2. Open web browser and go to http://your_server_name_or_ip/openemr/sql_patch.php
(this script will run automatically and patch the database)
(if you are using the Multisite Module, then skip step 2 and follow these instructions)
3. Delete the sql_patch.php file from the openemr web directory

Linux

1. Move the patch file to the openemr web directory, then type 'unzip 5-0-2-Patch-4.zip', and confirm ok to copy over files.
2. Open web browser and go to http://your_server_name_or_ip/openemr/sql_patch.php
(this script will run automatically and patch the database)
(if you are using the Multisite Module, then skip step 2 and follow these instructions)
3. Delete the sql_patch.php file from the openemr web directory


Fixes and New Features

(note the ones with ** are new with this patch):

  • Patient portal improvements - by Jerry Padgett**
  • Dicom viewer improvements - by Jerry Padgett**
  • Performance improvements - by Jerry Padgett**
  • PHP 7.4 fixes - fixed by Jerry Padgett**
  • Document module fix - reported by Pete Boyd and fixed by Tyler Wrenn**
  • Calendar fixes - fixed by Jerry Padgett**
  • Encounter fixes - fixed by Jerry Padgett**
  • Billing fixes - fixed by Jerry Padgett and Stephen Waite**
  • API fix - fixed by by Stephen Waite**
  • ICD10 and RxNorm import fixes - fixed by by Stephen Waite**
  • SameSite browser warning fixes - fixed by Brady Miller**
  • Patient Portal fixes - reported by and fixed by Jerry Padgett
  • MariaDB 10.4 compatibility fix - reported by travis and fixed by Brady Miller
  • Encounter improvements - by Jerry Padgett
  • Calendar improvement - by Stephen Waite
  • Billing fix - reported by and fixed by Stephen Waite
  • Pharmacy import fix - reported by and fixed by Stephen Waite
  • Critical security fix - reported by Dennis Brinkrolf (RIPS Technologies), fixed by Jerry Padgett and Brady Miller
  • Security fixes - reported by Dennis Brinkrolf (RIPS Technologies), Daniel Pflieger, and Visolve, fixed by Jerry Padgett and Brady Miller
  • COVID19 ICD10 codes added - by Stephen Waite
  • Patient portal security improvements, updates and fixes - by Jerry Padgett
  • API security improvements and updates - by Brady Miller and Stephen Waite
  • Payment improvements - by Jerry Padgett
  • MySQL 8 fix, part 1 - reported by Sanjeev Kumar, fixed by Brady Miller
  • MySQL 8 fix, part 2 - reported by Tman and fixed by Amit Meena
  • Calendar styling improvements - by Jerry Padgett
  • Patient Portal styling improvements - by Jerry Padgett and Tyler Wrenn
  • Referral form improvements - by Stephen Waite and Visolve
  • Added diagnosis history finder for procedure order form - by Jerry Padgett
  • Newcrop Rx improvements - by Ken Chapple
  • Rx improvements - by Sherwin Gaddis
  • MedEx fixes - by ophthal
  • PDF fix - reported by Tyler Wrenn, fixed by Jerry Padgett
  • Merge patient fix - reported by APerez, fixed by Brady Miller
  • Date of birth autocomplete fix - reported by Philip Herrick, fixed by Stephen Waite
  • ICD10 import fix - reported and fixed by Stephen Waite
  • Fees checkout fix - reported by Evgenios, fixed by Stephen Waite
  • Calendar fix - reported by and fixed by Stephen Waite
  • Billing fix - reported by and fixed by Stephen Waite
  • Billing statement fixes - reported by Stephen Waite, fixed by Jerry Padgett
  • Billing fix in billing/service facility - reported by and fixed by Daniel Pflieger
  • Messaging fix - reported by syedyawar and fixed by Visolve and Stephen Waite
  • Modules fix - reported by and fixed by Jerry Padgett
  • Zip code fix - reported by and fixed by Stephen Waite
  • Transaction date fix - reported by and fixed by Sherwin Gaddis
  • Fix functional and cognitive status form - reported by Pete Boyd and fixed by Stephen Waite
  • Fix pharmacy import - reported by and fixed by Robert Hausam**
  • Security fixes - reports by Will Porter (from Lodestone Security), Mera, Mirna Bassaly, and Brady Miller; fixes by Will Porter (from *Lodestone Security) and Brady Miller
  • Added custom modules support - by Jerry Padgett
  • MariaDB critical fix for install/upgrade - reported by Robert Down, fixed by Brady Miller
  • Cookie and session fixes - reported by Jerry Padgett, fixed by Brady Miller
  • Clear billing log feature added - by Sherwin Gaddis
  • Billing manager updates - by Jerry Padgett
  • Patient portal fixes - reported and fixed by Jerry Padgett
  • CCDA fix - reported and fixed by Jerry Padgett
  • Eye form fixes - reported and fixed by Ray Magauran
  • User editing fix - reported and fixed by Sherwin Gaddis
  • Patient history save fix - reported by CodderEMR, fixed by Stephen Waite
  • Patient history fix - reported by Stephen Waite, fixed by Jerry Padgett
  • Batch payment fixes - reported by Stephen Waite, fixed by zbig01
  • 837 claim fix - reported by Ray Magauran, fixed by Stephen Waite
  • X12 fix - reported and fixed by Derrik Milligan
  • Another X12 fix - reported by Ray Magauran, fixed by Stephen Waite
  • Fee sheet fixes - reported by Stephen Waite and Ray Magauran, fixed by Jerry Padgett
  • EOB invoice last bill date - reported and fixed by Stephen Waite
  • API (patient service) fix - reported and fixed by Stephen Waite
  • Code styling fix - reported and fixed by Brady Miller
  • MedEx fix - reported and fixed by Jerry Padgett
  • New patient add fix - reported by Jeremiah Ocasio, fixed by Stephen Waite
  • Calendar scrolling fix - reported and fixed by Aaron Chantrill
  • eRX fix - reported by Harley Tuck, fixed by Ken Chapple
  • Save and dispense rx fix - reported and fixed by Dimitry Remish


List of files (5.0.2)

acknowledge_license_cert.html
apis/dispatch.php
ci/ci.sh
composer.json
contrib/util/installScripts/InstallerAuto.php
controllers/C_Document.class.php
controllers/C_DocumentCategory.class.php
gacl/gacl_api.class.php
interface/batchcom/batchcom.inc.php
interface/billing/billing_process.php
interface/billing/billing_report.php
interface/billing/clear_log.php
interface/billing/edit_payment.php
interface/billing/new_payment.php
interface/billing/payment_master.inc.php
interface/billing/payment_pat_sel.inc.php
interface/billing/search_payments.php
interface/billing/sl_eob_invoice.php
interface/billing/sl_eob_search.php
interface/eRxStore.php
interface/eRxXMLBuilder.php
interface/forms/LBF/new.php
interface/forms/eye_mag/SpectacleRx.php
interface/forms/eye_mag/a_issue.php
interface/forms/eye_mag/css/style.css
interface/forms/eye_mag/js/eye_base.php
interface/forms/eye_mag/php/eye_mag_functions.php
interface/forms/eye_mag/save.php
interface/forms/eye_mag/view.php
interface/forms/fee_sheet/new.php
interface/forms/fee_sheet/review/fee_sheet_justify_view_model.js
interface/forms/fee_sheet/review/initialize_review.js
interface/forms/fee_sheet/review/initialize_review.php
interface/forms/fee_sheet/review/js/fee_sheet_core.js
interface/forms/functional_cognitive_status/save.php
interface/forms/newpatient/common.php
interface/forms/newpatient/save.php
interface/forms/procedure_order/new.php
interface/globals.php
interface/login/login.php
interface/main/backup.php
interface/main/calendar/add_edit_event.php
interface/main/calendar/find_patient_popup.php
interface/main/calendar/modules/PostCalendar/pntemplates/default/user/ajax_search.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/day/ajax_template.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/header.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/month/ajax_template.html
interface/main/calendar/modules/PostCalendar/pntemplates/default/views/week/ajax_template.html
interface/main/calendar/modules/PostCalendar/pnuserapi.php
interface/main/dated_reminders/dated_reminders.php
interface/main/main_info.php
interface/main/messages/css/reminder_style.css
interface/main/messages/js/reminder_appts.js
interface/main/messages/messages.php
interface/main/messages/save.php
interface/main/tabs/js/include_opener.js
interface/main/tabs/main.php
interface/main/tabs/menu/menus/standard.json
interface/main/tabs/templates/patient_data_template.php
interface/modules/zend_modules/config/application.config.php
interface/modules/zend_modules/module/Carecoordination/config/module.config.php
interface/modules/zend_modules/module/Installer/src/Installer/Controller/InstallerController.php
interface/modules/zend_modules/module/Installer/src/Installer/Model/InstModuleTable.php
interface/modules/zend_modules/module/Installer/view/installer/installer/configure.phtml
interface/modules/zend_modules/module/Installer/view/installer/installer/index.phtml
interface/modules/zend_modules/public/js/installer/action.js
interface/new/new_comprehensive.php
interface/orders/pending_followup.php
interface/orders/pending_orders.php
interface/orders/procedure_provider_edit.php
interface/orders/receive_hl7_results.inc.php
interface/orders/single_order_results.inc.php
interface/patient_file/download_template.php
interface/patient_file/encounter/find_code_history.php
interface/patient_file/encounter/forms.php
interface/patient_file/front_payment.php
interface/patient_file/front_payment_cc.php
interface/patient_file/history/encounters.php
interface/patient_file/history/history.php
interface/patient_file/history/history_save.php
interface/patient_file/merge_patients.php
interface/patient_file/pos_checkout.php
interface/patient_file/report/custom_report.php
interface/patient_file/report/patient_report.php
interface/patient_file/summary/clinical_reminders_fragment.php
interface/patient_file/summary/create_portallogin.php
interface/patient_file/summary/demographics.php
interface/patient_file/summary/disc_fragment.php
interface/patient_file/summary/labdata_fragment.php
interface/patient_file/summary/lbf_fragment.php
interface/patient_file/summary/patient_reminders_fragment.php
interface/patient_file/summary/pnotes_fragment.php
interface/patient_file/summary/pnotes_full.php
interface/patient_file/summary/stats.php
interface/patient_file/summary/vitals_fragment.php
interface/patient_file/transaction/print_referral.php
interface/patient_file/transaction/record_request.php
interface/patient_file/transaction/transactions.php
interface/patient_tracker/patient_tracker.php
interface/reports/collections_report.php
interface/reports/insurance_allocation_report.php
interface/reports/ippf_cyp_report.php
interface/reports/pat_ledger.php
interface/reports/patient_list.php
interface/reports/receipts_by_method_report.php
interface/reports/sales_by_item.php
interface/reports/svc_code_financial_report.php
interface/super/edit_layout.php
interface/super/edit_list.php
interface/themes/ajax_calendar.css
interface/themes/tabs_style_compact.css
interface/themes/tabs_style_full.css
interface/usergroup/user_admin.php
interface/usergroup/user_info.php
interface/usergroup/usergroup_admin.php
interface/usergroup/usergroup_admin_add.php
interface/weno/admin.php
interface/weno/import_pharmacies.php
interface/weno/pharmacyHelper.php
library/MedEx/API.php
library/MedEx/MedEx.php
library/MedEx/MedEx_background.php
library/ajax/dated_reminders_counter.php
library/ajax/facility_ajax_code.php
library/ajax/upload.php
library/amc.php
library/authentication/common_operations.php
library/authentication/login_operations.php
library/authentication/password_hashing.php
library/billrep.inc
library/classes/Installer.class.php
library/classes/TreeMenu.php
library/clinical_rules.php
library/custom_template/add_template.php
library/custom_template/ajax_code.php
library/dated_reminder_functions.php
library/dialog.js
library/dicom_frame.php
library/edihistory/edih_835_html.php
library/encounter_events.inc.php
library/formdata.inc.php
library/globals.inc.php
library/htmlspecialchars.inc.php
library/invoice_summary.inc.php
library/js/dwv/assets/dwv/decoders/dwv/decode-rle.js
library/js/dwv/assets/dwv/decoders/dwv/rle.js
library/js/dwv/assets/dwv/decoders/pdfjs/arithmetic_decoder.js
library/js/dwv/assets/dwv/decoders/pdfjs/decode-jpeg2000.js
library/js/dwv/assets/dwv/decoders/pdfjs/decode-jpegbaseline.js
library/js/dwv/assets/dwv/decoders/pdfjs/jpg.js
library/js/dwv/assets/dwv/decoders/pdfjs/jpx.js
library/js/dwv/assets/dwv/decoders/pdfjs/readme.md
library/js/dwv/assets/dwv/decoders/pdfjs/util.js
library/js/dwv/assets/dwv/decoders/rii-mango/decode-jpegloss.js
library/js/dwv/assets/dwv/decoders/rii-mango/lossless-min.js
library/js/dwv/assets/dwv/decoders/rii-mango/lossless.js
library/js/dwv/assets/dwv/decoders/rii-mango/readme.md
library/js/dwv/assets/dwv/dist/dwv.js
library/js/dwv/assets/dwv/dist/dwv.min.js
library/js/dwv/assets/dwv/locales/de/overlays.json
library/js/dwv/assets/dwv/locales/de/translation.json
library/js/dwv/assets/dwv/locales/en/overlays.json
library/js/dwv/assets/dwv/locales/en/translation.json
library/js/dwv/assets/dwv/locales/es/overlays.json
library/js/dwv/assets/dwv/locales/es/translation.json
library/js/dwv/assets/dwv/locales/fr/overlays.json
library/js/dwv/assets/dwv/locales/fr/translation.json
library/js/dwv/assets/dwv/locales/it/overlays.json
library/js/dwv/assets/dwv/locales/it/translation.json
library/js/dwv/assets/dwv/locales/jp/overlays.json
library/js/dwv/assets/dwv/locales/jp/translation.json
library/js/dwv/assets/dwv/locales/ro/overlays.json
library/js/dwv/assets/dwv/locales/ro/translation.json
library/js/dwv/assets/dwv/locales/ru/overlays.json
library/js/dwv/assets/dwv/locales/ru/translation.json
library/js/dwv/assets/dwv/locales/zh/overlays.json
library/js/dwv/assets/dwv/locales/zh/translation.json
library/js/dwv/assets/jszip/dist/jszip.js
library/js/dwv/assets/jszip/dist/jszip.min.js
library/js/dwv/dicom_gui.js
library/js/dwv/dicom_launcher.js
library/js/dwv/gui/resources/help/click.png
library/js/dwv/gui/resources/help/double_click.png
library/js/dwv/gui/resources/help/mouse_drag.png
library/js/dwv/gui/resources/help/mouse_wheel.png
library/options.inc.php
library/options.js.php
library/patient.inc
library/payment.inc.php
library/payment_jav.inc.php
library/pid.inc
library/sanitize.inc.php
library/smarty/plugins/function.dispatchPatientDocumentEvent.php
library/standard_tables_capture.inc
library/translation.inc.php
portal/_header.php
portal/account/account.lib.php
portal/account/account.php
portal/account/index_reset.php
portal/account/register.php
portal/add_edit_event_user.php
portal/assets/css/base.css
portal/assets/css/register.css
portal/assets/css/style.css
portal/get_patient_info.php
portal/home.php
portal/import_template_ui.php
portal/index.php
portal/lib/doc_lib.php
portal/lib/download_template.php
portal/messaging/messages.php
portal/patient/_app_config.php
portal/patient/_machine_config.php
portal/patient/fwk/libs/verysimple/Phreeze/GenericRouter.php
portal/patient/fwk/libs/verysimple/Phreeze/Phreezer.php
portal/patient/index.php
portal/patient/libs/Controller/OnsiteActivityViewController.php
portal/patient/libs/Controller/OnsiteDocumentController.php
portal/patient/libs/Controller/OnsitePortalActivityController.php
portal/patient/libs/Controller/PatientController.php
portal/patient/libs/Controller/PortalPatientController.php
portal/patient/libs/Controller/UserController.php
portal/patient/libs/Model/DAO/UserCriteriaDAO.php
portal/patient/libs/Model/DAO/UserDAO.php
portal/patient/libs/Model/DAO/UserMap.php
portal/patient/libs/Reporter/UserReporter.php
portal/patient/scripts/app.js
portal/patient/scripts/app/onsiteactivityviews.js
portal/patient/scripts/app/onsitedocuments.js
portal/patient/scripts/app/onsiteportalactivities.js
portal/patient/scripts/app/patientdata.js
portal/patient/scripts/model.js
portal/patient/templates/DefaultError404.tpl.php
portal/patient/templates/DefaultErrorFatal.tpl.php
portal/patient/templates/OnsiteDocumentListView.tpl.php
portal/patient/templates/PatientListView.tpl.php
portal/patient/templates/ProviderHome.tpl.php
portal/patient/templates/_Footer.tpl.php
portal/patient/templates/_FormsHeader.tpl.php
portal/report/pat_ledger.php
portal/sign/assets/signer_api.js
portal/sign/assets/signer_modal.php
portal/sign/assets/signer_modal.tpl.php
portal/sign/assets/signit.php
portal/sign/css/signer_modal.css
portal/sign/lib/save-signature.php
portal/sign/lib/show-signature.php
sites/default/referral_template.html
sites/default/statement.inc.php
sql/5_0_1-to-5_0_2_upgrade.sql
sql/database.sql
sql/patch.sql
src/Billing/Claim.php
src/Billing/X12_5010_837P.php
src/Common/Crypto/CryptoGen.php
src/Common/Http/oeHttpRequest.php
src/Common/Session/SessionUtil.php
src/Common/Utils/RandomGenUtils.php
src/Core/ModulesApplication.php
src/Events/PatientDocuments/PatientDocumentEvent.php
src/Events/PatientReport/PatientReportEvent.php
src/Pharmacy/Services/ImportPharmacies.php
src/RestControllers/AuthRestController.php
src/Services/Globals/GlobalSetting.php
src/Services/InsuranceCompanyService.php
src/Services/PatientService.php
templates/documents/general_list.html
templates/documents/general_upload.html
templates/documents/general_view.html
templates/prescription/general_edit.html
version.php



Previous Patches

Previous OpenEMR version patches