Stephen, Thanks for the offer os assistance. I have inserted the output of the upgrade process as printed on the browser page.
OpenEMR Database Upgrade
Processing 5_0_0-to-5_0_1_upgrade.sql …
ALTER TABLE list_options ADD edit_options TINYINT(1) NOT NULL DEFAULT ‘1’
ALTER TABLE list_options ADD timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
Skipping section #IfNotTable multiple_db
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘therapy_groups_add#addGroup’, ‘/interface/therapy_groups
/index.php?method=addGroup’, 120, ‘{group_name:{presence: true}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘therapy_groups_edit#editGroup’, ‘/interface/therapy_groups
/index.php?method=groupDetails’, 125, ‘{group_name:{presence: true}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘tg_add#add-participant-form’, ‘/interface/therapy_groups
/index.php?method=groupParticipants’, 130, ‘{participant_name:{presence: true}, group_patient_start:{presence: true}}’, 1)
INSERT INTO list_options (list_id,option_id,title,seq,is_default,option_value,mapping,notes,codes,toggle_setting_1,toggle_setting_2,activity,subtype)VALUES
(‘page_validation’,‘add_edit_event#theform_groups’,’/interface/main/calendar/add_edit_event.php?group=true’,150,0,0,’’,’{form_group:{presence: true}}’,’’,0,0,1,’’)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘common#new-encounter-form’, ‘/interface/forms/newGroupEncounter
/common.php’, 160, ‘{pc_catid:{exclusion: ["blank"]}}’, 1)
Skipping section #IfNotTable therapy_groups
Skipping section #IfNotTable therapy_groups_participants
Skipping section #IfNotTable therapy_groups_participant_attendance
Skipping section #IfNotTable therapy_groups_counselors
ALTER TABLE openemr_postcalendar_events ADD pc_gid int(11) DEFAULT 0
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value) VALUES (‘lists’, ‘groupstat’, ‘Group Statuses’, ‘13’, ‘0’, ‘0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes) VALUES (‘groupstat’, ‘-’, ‘- None’, ‘10’, ‘0’, ‘0’, ‘FEFDCF|0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes) VALUES (‘groupstat’, ‘=’, ‘= Took Place’, ‘20’, ‘0’, ‘0’, ‘FF2414|0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes) VALUES (‘groupstat’, ‘>’, ‘> Did Not Take Place’, ‘30’, ‘0’, ‘0’, ‘BFBFBF|0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes) VALUES (‘groupstat’, ‘<’, ‘< Not Reported’, ‘40’, ‘0’, ‘0’, ‘FEFDCF|0’)
INSERT INTO openemr_postcalendar_categories (pc_catname, pc_catcolor, pc_recurrspec, pc_duration ,pc_cattype , pc_active , pc_seq)VALUES (‘Group Therapy’ , ‘#BFBFBF’ ,
‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’,
‘3600’, ‘3’, ‘1’, ‘90’)
Skipping section #IfNotTable form_groups_encounter
ALTER TABLE forms ADD therapy_group_id INT(11) DEFAULT NULL
ALTER TABLE registry ADD patient_encounter TINYINT NOT NULL DEFAULT ‘1’
ALTER TABLE registry ADD therapy_group_encounter TINYINT NOT NULL DEFAULT ‘0’
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value) VALUES (‘lists’, ‘attendstat’, ‘Group Attendance Statuses’, ‘15’, ‘0’, ‘0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes, toggle_setting_1) VALUES (‘attendstat’, ‘-’, ‘- Not Reported’, ‘10’, ‘0’, ‘0’, ‘FEFDCF|0’, ‘0’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes, toggle_setting_1) VALUES (‘attendstat’, ‘@’, ‘@ Attended’, ‘20’, ‘0’, ‘0’, ‘FF2414|0’, ‘1’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes, toggle_setting_1) VALUES (‘attendstat’, ‘?’, ‘? Did Not Attend’, ‘30’, ‘0’, ‘0’, ‘BFBFBF|0’,
‘1’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes, toggle_setting_1) VALUES (‘attendstat’, ‘~’, ‘~ Late Arrival’, ‘40’, ‘0’, ‘0’, ‘BFBFBF|0’, ‘1’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, notes, toggle_setting_1) VALUES (‘attendstat’, ‘x’, ‘x Cancelled’, ‘50’, ‘0’, ‘0’, ‘FEFDCF|0’, ‘0’)
INSERT INTO registry (name, state, directory, sql_run, unpackaged, date, priority, category, nickname, patient_encounter, therapy_group_encounter) VALUES (‘Group Attendance Form’, 1,
‘group_attendance’, 1, 1, ‘2015-10-15 00:00:00’, 0, ‘Clinical’, ‘’,0,1)
INSERT INTO registry (name, state, directory, sql_run, unpackaged, date, priority, category, nickname, patient_encounter, therapy_group_encounter) VALUES (‘New Group Encounter
Form’, 1, ‘newGroupEncounter’, 1, 1, ‘2015-10-15 00:00:00’, 0, ‘Clinical’, ‘’,0,1)
Skipping section #IfTable form_therapy_groups_attendance
Skipping section #IfNotTable form_group_attendance
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’, ‘files_white_list’, ‘Files type white list’)
Skipping section #IfNotTable onsite_documents
Skipping section #IfNotTable onsite_mail
Skipping section #IfNotTable onsite_messages
Skipping section #IfNotTable onsite_online
Skipping section #IfNotTable onsite_portal_activity
Skipping section #IfNotTable onsite_signatures
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Onsite Portal’, ‘’, 1, rght, rght + 5 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Patient’, ‘’, (select id from categories where name = ‘Onsite Portal’), rght + 1, rght + 2 from categories where name =
‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Reviewed’, ‘’, (select id from categories where name = ‘Onsite Portal’), rght + 3, rght + 4 from categories where name =
‘Categories’
UPDATE categories SET rght = rght + 6 WHERE name = ‘Categories’
UPDATE categories_seq SET id = (select MAX(id) from categories)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default, notes ) VALUES (‘apptstat’,’^’,’^ Pending’,70,0,‘FEFDCF|0’)
ALTER TABLE registry ADD aco_spec varchar(63) NOT NULL default ‘encounters|notes’
UPDATE registry SET aco_spec = ‘patients|appt’ WHERE directory = ‘newpatient’
UPDATE registry SET aco_spec = ‘patients|appt’ WHERE directory = ‘newGroupEncounter’
UPDATE registry SET aco_spec = ‘encounters|coding’ WHERE directory = ‘fee_sheet’
UPDATE registry SET aco_spec = ‘encounters|coding’ WHERE directory = ‘misc_billing_options’
UPDATE registry SET aco_spec = ‘patients|lab’ WHERE directory = ‘procedure_order’
Skipping section #IfNotColumnType lbf_data field_value longtext
ALTER TABLE issue_types ADD aco_spec varchar(63) NOT NULL default ‘patients|med’
ALTER TABLE categories ADD aco_spec varchar(63) NOT NULL default ‘patients|docs’
Skipping section #IfNotColumnType onsite_mail owner varchar(128)
ALTER TABLE openemr_postcalendar_events CHANGE pc_facility pc_facility int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘facility id for this event’
ALTER TABLE form_misc_billing_options ADD onset_date date default NULL
UPDATE list_options SET option_id = ‘DK’, title = ‘Ordering Provider’ WHERE list_id = ‘provider_qualifier_code’ AND option_id = ‘dk’
UPDATE list_options SET option_id = ‘DN’, title = ‘Referring Provider’, is_default = ‘1’ WHERE list_id = ‘provider_qualifier_code’ AND option_id = ‘dn’
INSERT INTO list_options (list_id, option_id, title, seq, is_default) VALUES (‘provider_qualifier_code’, ‘DQ’, ‘Supervising Provider’, ‘30’, ‘0’)
ALTER TABLE users ADD main_menu_role VARCHAR(50) NOT NULL DEFAULT ‘standard’
ALTER TABLE openemr_postcalendar_categories ADD COLUMN aco_spec VARCHAR(63) NOT NULL DEFAULT ‘encounters|notes’
INSERT INTO list_options (list_id,option_id,title) VALUES (‘lists’,‘apps’,‘Apps’)
INSERT INTO list_options (list_id,option_id,title,seq,is_default,activity) VALUES (‘apps’,’*OpenEMR’,‘main/main_screen.php’,10,1,0)
INSERT INTO list_options (list_id,option_id,title,seq,is_default,activity) VALUES (‘apps’,‘Calendar’,‘main/calendar/index.php’,20,0,0)
ALTER TABLE list_options CHANGE list_id list_id VARCHAR(100) NOT NULL DEFAULT ‘’
ALTER TABLE list_options CHANGE option_id option_id VARCHAR(100) NOT NULL DEFAULT ‘’
OpenEMR Database Upgrade http://localhost/openemr/sql_upgrade.php
1 of 4 7/12/2018, 1:47 AM
ALTER TABLE layout_options CHANGE list_id list_id VARCHAR(100) NOT NULL DEFAULT ‘’
ALTER TABLE layout_options CHANGE list_backup_id list_backup_id VARCHAR(100) NOT NULL DEFAULT ‘’
Skipping section #IfNotTable patient_birthday_alert
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES(‘ICD10’, ‘CMS’, ‘2017-10-01’, ‘2018-ICD-10-
PCS-Order-File.zip’, ‘264b342310236f2b3927062d2c72cfe3’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES(‘ICD10’, ‘CMS’, ‘2017-10-01’, ‘2018-ICD-10-
CM-General-Equivalence-Mappings.zip’, ‘787a025fdcf6e1da1a85be779004f670’)
UPDATE supported_external_dataloads SET load_filename=‘2018-ICD-10-Code-Descriptions.zip’ WHERE load_filename=‘2018-ICD-10-Code-Dedcriptions.zip’ AND
load_release_date=‘2017-10-01’
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES(‘ICD10’, ‘CMS’, ‘2017-10-01’, ‘2018-ICD-10-
Code-Descriptions.zip’, ‘6f9c77440132e30f565222ca9bb6599c’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES(‘ICD10’, ‘CMS’, ‘2017-10-01’, ‘2018-ICD-10-
PCS-General-Equivalence-Mappings.zip’, ‘bb73c80e272da28712887d7979b1cebf’)
ALTER TABLE x12_partners DROP COLUMN x12_version
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES(‘page_validation’, ‘add_edit_event#theform_prov’, ‘/interface/main/calendar
/add_edit_event.php?prov=true’, 170, ‘{}’, 1)
ALTER TABLE claims ADD COLUMN submitted_claim TEXT COMMENT ‘This claims form claim data’
ALTER TABLE billing ADD COLUMN revenue_code varchar(6) NOT NULL DEFAULT “” COMMENT ‘Item revenue code’
ALTER TABLE codes ADD COLUMN revenue_code varchar(6) NOT NULL DEFAULT “” COMMENT ‘Item revenue code’
ALTER TABLE users ADD weno_prov_id VARCHAR(15) DEFAULT NULL
ALTER TABLE prescriptions ADD ntx INT(2) DEFAULT NULL
ALTER TABLE prescriptions ADD rtx INT(2) DEFAULT NULL
ALTER TABLE prescriptions ADD txDate DATE NOT NULL
ALTER TABLE pharmacies ADD ncpdp INT(12) DEFAULT NULL
ALTER TABLE pharmacies ADD npi INT(12) DEFAULT NULL
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘state’,‘PR’,‘Puerto Rico’,39,0)
Skipping section #IfNotTable erx_drug_paid
Skipping section #IfNotTable erx_rx_log
Skipping section #IfNotTable erx_narcotics
UPDATE globals SET gl_value=‘style_red.css’ WHERE gl_name=‘css_header’ AND gl_value=‘style_flat_red.css’
UPDATE globals SET gl_value=‘style_manila.css’ WHERE gl_name=‘css_header’ AND gl_value=‘style_tan.css’
UPDATE globals SET gl_value=‘style_light.css’ WHERE gl_name=‘css_header’ AND (gl_value=‘style_babyblu.css’ OR gl_value=‘style_metal.css’ OR gl_value=‘style_oemr.css’
OR gl_value=‘style_purple.css’ OR gl_value=‘style_radiant.css’ OR gl_value=‘style_sky_blue.css’)
UPDATE user_settings SET setting_value=‘style_red.css’ WHERE setting_label=‘global:css_header’ AND setting_value=‘style_flat_red.css’
UPDATE user_settings SET setting_value=‘style_manila.css’ WHERE setting_label=‘global:css_header’ AND setting_value=‘style_tan.css’
UPDATE user_settings SET setting_value=‘style_light.css’ WHERE setting_label=‘global:css_header’ AND (setting_value=‘style_babyblu.css’ OR setting_value=‘style_metal.css’ OR
setting_value=‘style_oemr.css’ OR setting_value=‘style_purple.css’ OR setting_value=‘style_radiant.css’ OR setting_value=‘style_sky_blue.css’)
ALTER TABLE facility CHANGE country_code country_code varchar(30) NOT NULL default ‘’
ALTER TABLE layout_options CHANGE group_name group_name varchar(255) NOT NULL default ‘’
ALTER TABLE forms ADD COLUMN issue_id bigint(20) NOT NULL default 0 COMMENT ‘references lists.id to identify a case’
ALTER TABLE forms ADD COLUMN provider_id bigint(20) NOT NULL default 0 COMMENT ‘references users.id to identify a provider’
Skipping section #IfNotTable layout_group_properties
Skipping section #ConvertLayoutProperties
ALTER TABLE openemr_postcalendar_categories ADD pc_constant_id VARCHAR (255) default NULL
UPDATE openemr_postcalendar_categories SET pc_constant_id = LOWER(REPLACE (pc_catname,’ ', '’))
ALTER TABLE openemr_postcalendar_categories ADD UNIQUE (pc_constant_id)
ALTER TABLE facility ADD facility_taxonomy VARCHAR(15) DEFAULT NULL
Skipping section #IfNotTable medex_icons
Skipping section #IfNotTable medex_outgoing
Skipping section #IfNotTable medex_prefs
Skipping section #IfNotTable medex_recalls
INSERT INTO background_services (name, title, active, running, next_run, execute_interval, function, require_once, sort_order) VALUES(‘MedEx’, ‘MedEx Messaging
Service’, 0, 0, ‘2017-05-09 17:39:10’, 0, ‘start_MedEx’, ‘/library/MedEx/MedEx_background.php’, 100)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype)
VALUES(‘apptstat’, ‘AVM’, ‘AVM Confirmed’, 110, 0, 0, ‘’, ‘F0FFE8|0’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype)
VALUES(‘apptstat’, ‘CALL’, ‘Callback requested’, 130, 0, 0, ‘’, ‘FFDBE2|5’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype)
VALUES(‘apptstat’, ‘SMS’, ‘SMS Confirmed’, 90, 0, 0, ‘’, ‘F0FFE8|0’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype)
VALUES(‘apptstat’, ‘EMAIL’, ‘EMAIL Confirmed’, 20, 0, 0, ‘’, ‘FFEBE3|0’, ‘’, 0, 0, 1, ‘’)
ALTER TABLE log_comment_encrypt ADD version tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0 for mycrypt and 1 for openssl’
ALTER TABLE form_misc_billing_options CHANGE icn_resubmission_number icn_resubmission_number VARCHAR(35) DEFAULT NULL
ALTER TABLE users ADD patient_menu_role VARCHAR(50) NOT NULL DEFAULT ‘standard’
Updating global configuration defaults…
Updating Access Controls…
UPGRADING ACCESS CONTROLS TO VERSION 4:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
‘Physicians’ group ‘write’ ACL is present.
‘Clinicians’ group ‘write’ ACL is present.
‘Clinicians’ group ‘addonly’ ACL is present.
‘Front Office’ group ‘write’ ACL is present.
‘Accounting’ group ‘write’ ACL is present.
Adding new objects
The ‘Patient Reminders (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
The ‘Clinical Reminders/Alerts (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
The ‘Disclosures (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
The ‘Prescriptions (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
The ‘Amendments (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
The ‘Lab Results (write,addonly optional)’ object in the ‘Patients’ section has been successfully added.
OpenEMR Database Upgrade http://localhost/openemr/sql_upgrade.php
2 of 4 7/12/2018, 1:47 AM
Updating the ACLs(Access Control Lists)
Successfully placed the ‘Patient Reminders (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Disclosures (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Prescriptions (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Amendments (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Physicians’ group ‘write’ ACL.
UPGRADING ACCESS CONTROLS TO VERSION 5:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
Adding new object sections
The ‘Groups’ object section has been successfully added.
Adding new objects
The ‘Multipledb’ object in the ‘Administration’ section has been successfully added.
The ‘View/Add/Update groups’ object in the ‘Groups’ section has been successfully added.
The ‘View/Create/Update groups appointment in calendar’ object in the ‘Groups’ section has been successfully added.
The ‘Group encounter log’ object in the ‘Groups’ section has been successfully added.
The ‘Group detailed log of appointment in patient record’ object in the ‘Groups’ section has been successfully added.
The ‘Send message from the permanent group therapist to the personal therapist’ object in the ‘Groups’ section has been successfully added.
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Updating the ACLs(Access Control Lists)
Successfully placed the ‘View/Add/Update groups’ object of the ‘Groups’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘View/Create/Update groups appointment in calendar’ object of the ‘Groups’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Group encounter log’ object of the ‘Groups’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Group detailed log of appointment in patient record’ object of the ‘Groups’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Send message from the permanent group therapist to the personal therapist’ object of the ‘Groups’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Multipledb’ object of the ‘Administration’ section into the ‘Administrators’ group ‘write’ ACL.
UPGRADING ACCESS CONTROLS TO VERSION 6:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
‘Physicians’ group ‘write’ ACL is present.
‘Clinicians’ group ‘addonly’ ACL is present.
‘Clinicians’ group ‘write’ ACL is present.
‘Front Office’ group ‘view’ ACL is present.
‘Front Office’ group ‘write’ ACL is present.
‘Accounting’ group ‘view’ ACL is present.
‘Emergency Login’ group ‘write’ ACL is present.
Adding new object sections
The ‘Menu’ object in the ‘Administration’ section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Updating the ACLs(Access Control Lists)
Successfully placed the ‘Menu’ object of the ‘Administration’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Authorize - my encounters’ object of the ‘Encounters’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Coding - my encounters (write,wsome optional)’ object of the ‘Encounters’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Notes - my encounters (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Less-private information (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Sign Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Patient Reminders (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Disclosures (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Prescriptions (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Amendments (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Authorize - my encounters’ object of the ‘Encounters’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Coding - my encounters (write,wsome optional)’ object of the ‘Encounters’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Notes - my encounters (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Less-private information (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘View/Create/Update groups appointment in calendar’ object of the ‘Groups’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Group encounter log’ object of the ‘Groups’ section into the ‘Physicians’ group ‘write’ ACL.
Successfully placed the ‘Transactions (write optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Patient Reminders (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Disclosures (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Prescriptions (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Amendments (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘addonly’ ACL.
Successfully placed the ‘View/Create/Update groups appointment in calendar’ object of the ‘Groups’ section into the ‘Clinicians’ group ‘write’ ACL.
Successfully placed the ‘Group encounter log’ object of the ‘Groups’ section into the ‘Clinicians’ group ‘write’ ACL.
OpenEMR Database Upgrade http://localhost/openemr/sql_upgrade.php
3 of 4 7/12/2018, 1:47 AM
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Front Office’ group ‘view’ ACL.
Successfully placed the ‘View/Create/Update groups appointment in calendar’ object of the ‘Groups’ section into the ‘Front Office’ group ‘write’ ACL.
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Accounting’ group ‘view’ ACL.
Successfully placed the ‘Multipledb’ object of the ‘Administration’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Menu’ object of the ‘Administration’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Authorize - my encounters’ object of the ‘Encounters’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Coding - my encounters (write,wsome optional)’ object of the ‘Encounters’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Notes - my encounters (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Less-private information (write,addonly optional)’ object of the ‘Encounters’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Sign Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Patient Reminders (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Clinical Reminders/Alerts (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Disclosures (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Prescriptions (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Amendments (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Lab Results (write,addonly optional)’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘View/Add/Update groups’ object of the ‘Groups’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘View/Create/Update groups appointment in calendar’ object of the ‘Groups’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Group encounter log’ object of the ‘Groups’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Group detailed log of appointment in patient record’ object of the ‘Groups’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Send message from the permanent group therapist to the personal therapist’ object of the ‘Groups’ section into the ‘Emergency Login’ group ‘write’ ACL.
UPGRADING ACCESS CONTROLS TO VERSION 7:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
‘Emergency Login’ group ‘write’ ACL is present.
Adding new object sections
The ‘Manage modules’ object in the ‘Administration’ section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Successfully placed the ‘Manage modules’ object of the ‘Administration’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Manage modules’ object of the ‘Administration’ section into the ‘Emergency Login’ group ‘write’ ACL.
Updating the ACLs(Access Control Lists)
UPGRADING ACCESS CONTROLS TO VERSION 8:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
‘Emergency Login’ group ‘write’ ACL is present.
Adding new object sections
The ‘Documents Delete’ object in the ‘Patients’ section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Successfully placed the ‘Documents Delete’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Documents Delete’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Updating the ACLs(Access Control Lists)
DONE upgrading access controls
Updating version indicators…
Database and Access Control upgrade finished.
OpenEMR Database Upgrade http://localhost/openemr/sql_upgrade.php
4 of 4 7/12/2018, 1:47 AM
