Situation
Demographics layout groups are not properly converted during 5.0.2 upgrade. Suggested fix used here (group_id fix 5.0.1 upgrade by stephenwaite · Pull Request #1596 · openemr/openemr · GitHub), however previously used layout groups are lost.
OpenEMR Version
5.0.0 (6) -> 5.0.2
Browser:
Firefox current
Operating System
Server: Ubuntu 18.04.3
Logs
‘’‘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 ‘’
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)
CREATE TABLE erx_drug_paid ( drugid int(11) NOT NULL AUTO_INCREMENT, drug_label_name varchar(45) NOT NULL, ahfs_descr varchar(45) NOT NULL, ndc bigint(12) NOT NULL, price_per_unit decimal(5,2) NOT NULL, avg_price decimal(6,2) NOT NULL, avg_price_paid int(6) NOT NULL, avg_savings decimal(6,2) NOT NULL, avg_percent decimal(6,2) NOT NULL, PRIMARY KEY (drugid) ) ENGINE=InnoDB
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 KEY (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’
Processing 5_0_1-to-5_0_2_upgrade.sql …
UPDATE background_services SET require_once=’/library/MedEx/MedEx_background.php’ WHERE name=‘MedEx’
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘proc_type’,‘fgp’,‘Custom Favorite Group’ ,50,0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘proc_type’,‘for’,‘Custom Favorite Item’ ,60,0)
Skipping section #IfNotTable form_eye_base
ALTER TABLE lists ADD list_option_id VARCHAR (100) DEFAULT NULL COMMENT ‘Reference to list_options table’
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘messages#new_note’,’/interface/main/messages/messages.php’,150, ‘{form_datetime:{futureDate:{message: “Must be future date”}}, reply_to:{presence: {message: “Please choose a patient”}}}’, 1)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2018-10-01’, ‘2019-ICD-10-CM-Code-Descriptions.zip’, ‘b23e0128eb2dce0cb007c31638a8dc00’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2018-10-01’, ‘2019-ICD-10-PCS-Order-File.zip’, ‘eb545fe61ada9efad0ad97a669f8671f’)
Skipping section #IfNotTable login_mfa_registrations
ALTER TABLE users_secure ADD COLUMN last_challenge_response datetime DEFAULT NULL
ALTER TABLE users_secure ADD COLUMN login_work_area text
Skipping section #IfNotColumnType onsite_messages sender_id VARCHAR(64)
ALTER TABLE form_eye_mag_dispense ADD COLUMN CTLODQUANTITY varchar(255) DEFAULT NULL
ALTER TABLE form_eye_mag_dispense ADD COLUMN CTLOSQUANTITY varchar(255) DEFAULT NULL
Skipping section #IfMissingColumn medex_prefs status
UPDATE list_options SET notes=’{“form_title”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘add_edit_issue#theform’
UPDATE list_options SET notes=’{“pc_catid”:{“exclusion”: ["_blank"]}}’ WHERE list_id=‘page_validation’ AND option_id=‘common#new_encounter’
UPDATE list_options SET notes=’{“form_patient”:{“presence”: {“message”: “Patient Name Required”}}}’ WHERE list_id=‘page_validation’ AND option_id=‘add_edit_event#theform’
UPDATE list_options SET notes=’{“rumple”:{“presence”: {“message”:“Required field missing: Please enter the User Name”}}, “stiltskin”:{“presence”: {“message”:“Please enter the password”}}, “fname”:{“presence”: {“message”:“Required field missing: Please enter the First name”}}, “lname”:{“presence”: {“message”:“Required field missing: Please enter the Last name”}}}’ WHERE list_id=‘page_validation’ AND option_id=‘usergroup_admin_add#new_user’
UPDATE list_options SET notes=’{“fname”:{“presence”: {“message”:“Required field missing: Please enter the First name”}}, “lname”:{“presence”: {“message”:“Required field missing: Please enter the Last name”}}}’ WHERE list_id=‘page_validation’ AND option_id=‘user_admin#user_form’
UPDATE list_options SET notes=’{“facility”:{“presence”: true}, “ncolor”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘facility_admin#facility-form’
UPDATE list_options SET notes=’{“facility”:{“presence”: true}, “ncolor”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘facilities_add#facility-add’
UPDATE list_options SET notes=’{“group_name”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘therapy_groups_add#addGroup’
UPDATE list_options SET notes=’{“group_name”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘therapy_groups_edit#editGroup’
UPDATE list_options SET notes=’{“participant_name”:{“presence”: true}, “group_patient_start”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘tg_add#add-participant-form’
UPDATE list_options SET notes=’{“pc_catid”:{“exclusion”: ["_blank"]}}’ WHERE list_id=‘page_validation’ AND option_id=‘common#new-encounter-form’
UPDATE list_options SET notes=’{“form_group”:{“presence”: true}}’ WHERE list_id=‘page_validation’ AND option_id=‘add_edit_event#theform_groups’
UPDATE list_options SET notes=’{“form_datetime”:{“futureDate”:{“message”: “Must be future date”}}, “reply_to”:{“presence”: {“message”: “Please choose a patient”}}}’ WHERE list_id=‘page_validation’ AND option_id=‘messages#new_note’
Skipping section #IfNotTable api_token
ALTER TABLE pnotes ADD update_by bigint(20) default NULL
ALTER TABLE pnotes ADD update_date DATETIME DEFAULT NULL
Skipping section #IfNotColumnType onsite_documents full_document MEDIUMBLOB
ALTER TABLE facility ADD mail_street VARCHAR(30) default NULL
ALTER TABLE facility ADD mail_street2 VARCHAR(30) default NULL
ALTER TABLE facility ADD mail_city VARCHAR(50) default NULL
ALTER TABLE facility ADD mail_state VARCHAR(3) default NULL
ALTER TABLE facility ADD mail_zip VARCHAR(10) default NULL
ALTER TABLE facility ADD oid VARCHAR(255) NOT NULL DEFAULT ‘’ COMMENT ‘HIEs CCDA and FHIR an OID is required/wanted’
Skipping section #IfNotTable keys
ALTER TABLE amendments MODIFY pid bigint(20) NOT NULL COMMENT ‘Patient ID from patient_data’
ALTER TABLE billing MODIFY pid bigint(20) default NULL
ALTER TABLE dated_reminders MODIFY pid bigint(20) NOT NULL
ALTER TABLE drug_sales MODIFY pid bigint(20) NOT NULL default ‘0’
ALTER TABLE form_ros MODIFY pid bigint(20) NOT NULL
ALTER TABLE issue_encounter MODIFY pid bigint(20) NOT NULL
Skipping section #IfNotColumnType onsite_documents pid bigint(20) unsigned
ALTER TABLE patient_access_onsite MODIFY pid bigint(20)
ALTER TABLE patient_access_offsite MODIFY pid bigint(20) NOT NULL
ALTER TABLE form_eye_mag_wearing MODIFY PID bigint(20) NOT NULL
Skipping section #IfNotColumnType therapy_groups_participants pid bigint(20)
Skipping section #IfNotColumnType therapy_groups_participant_attendance pid bigint(20)
ALTER TABLE notification_log MODIFY pid bigint(20) NOT NULL
ALTER TABLE documents MODIFY foreign_id bigint(20) default NULL
ALTER TABLE batchcom MODIFY patient_id bigint(20) NOT NULL default ‘0’
ALTER TABLE claims MODIFY patient_id bigint(20) NOT NULL
ALTER TABLE immunizations MODIFY patient_id bigint(20) default NULL
ALTER TABLE prescriptions MODIFY patient_id bigint(20) default NULL
ALTER TABLE ar_session MODIFY patient_id bigint(20) NOT NULL
ALTER TABLE documents ADD encrypted TINYINT(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0->No,1->Yes’
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘CQM_VALUESET’, ‘NIH_VSAC’, ‘2017-09-29’,‘ep_ec_only_cms_20170929.xml.zip’,‘38d2e1a27646f2f09fcc389fd2335c50’)
ALTER TABLE eligibility_verification CHANGE response_id response_id VARCHAR(32) DEFAULT NULL
Skipping section #IfNotTable benefit_eligibility
DROP TABLE eligibility_response
ALTER TABLE x12_partners CHANGE processing_format processing_format ENUM(‘standard’,‘medi-cal’,‘cms’,‘proxymed’,‘oa_eligibility’,‘availity_eligibility’) DEFAULT NULL
ALTER TABLE insurance_companies ADD eligibility_id VARCHAR(32) DEFAULT NULL
ALTER TABLE insurance_companies ADD x12_default_eligibility_id INT(11) DEFAULT NULL
ALTER TABLE users_secure ADD login_fail_counter INT(11) DEFAULT ‘0’
ALTER TABLE x12_partners ADD x12_dtp03 CHAR(1) DEFAULT ‘A’
ALTER TABLE procedure_order ADD order_diagnosis VARCHAR(255) DEFAULT ‘’
DROP TABLE erx_drug_paid
Skipping section #IfNotTable erx_weno_drugs
Imported eRx Weno Drug Data
DROP TABLE openemr_postcalendar_limits
DROP TABLE openemr_postcalendar_topics
DROP TABLE openemr_session_info
DROP TABLE array
DROP TABLE config
DROP TABLE config_seq
DROP TABLE geo_country_reference
DROP TABLE geo_zone_reference
Skipping section #IfMissingColumn form_eye_acuity BINOCVA
UPDATE list_options SET seq= 1022 WHERE list_id=‘Eye_QP_RETINA_defaults’ AND option_id=‘ODPERIPH_0’
UPDATE list_options SET seq= 1024 WHERE list_id=‘Eye_QP_RETINA_defaults’ AND option_id=‘OSPERIPH_0’
UPDATE list_options SET seq= 1026 WHERE list_id=‘Eye_QP_RETINA_defaults’ AND option_id=‘OUPERIPH_0’
UPDATE list_options SET title= ‘clear’, seq = 505 WHERE list_id=‘Eye_Defaults_for_GENERAL’ AND option_id=‘ODPERIPH’
UPDATE list_options SET title= ‘clear’, seq = 515 WHERE list_id=‘Eye_Defaults_for_GENERAL’ AND option_id=‘OSPERIPH’
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(‘Eye_QP_RETINA_defaults’, ‘ODVITREOUS_0’, ‘vit: clear field’, 910, 0, 0, ‘VITREOUS’, ‘’, ‘’, 0, 0, 1, ‘OD’)
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(‘Eye_QP_RETINA_defaults’, ‘OSVITREOUS_0’, ‘vit: clear field’, 920, 0, 0, ‘VITREOUS’, ‘’, ‘’, 0, 0, 1, ‘OS’)
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(‘Eye_QP_RETINA_defaults’, ‘OUVITREOUS_0’, ‘vit: clear field’, 930, 0, 0, ‘VITREOUS’, ‘’, ‘’, 0, 0, 1, ‘OU’)
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(‘Eye_QP_RETINA_defaults’, ‘ODVITREOUS_float’, ‘vit: floater’, 940, 0, 0, ‘VITREOUS’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OD’)
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(‘Eye_QP_RETINA_defaults’, ‘OSVITREOUS_float’, ‘vit: floater’, 950, 0, 0, ‘VITREOUS’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OS’)
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(‘Eye_QP_RETINA_defaults’, ‘OUVITREOUS_float’, ‘vit: floater’, 960, 0, 0, ‘VITREOUS’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OU’)
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(‘Eye_QP_RETINA_defaults’, ‘ODVITREOUS_pvd’, ‘vit: PVD’, 970, 0, 0, ‘VITREOUS’, ‘PVD’, ‘’, 0, 0, 0, ‘OD’)
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(‘Eye_QP_RETINA_defaults’, ‘OSVITREOUS_pvd’, ‘vit: PVD’, 980, 0, 0, ‘VITREOUS’, ‘PVD’, ‘’, 0, 0, 0, ‘OS’)
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(‘Eye_QP_RETINA_defaults’, ‘OUVITREOUS_pvd’, ‘vit: PVD’, 990, 0, 0, ‘VITREOUS’, ‘PVD’, ‘’, 0, 0, 0, ‘OU’)
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(‘Eye_QP_RETINA_defaults’, ‘ODVITREOUS_vh’, ‘vit: hemorrhage’, 1000, 0, 0, ‘VITREOUS’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OD’)
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(‘Eye_QP_RETINA_defaults’, ‘OSVITREOUS_vh’, ‘vit: hemorrhage’, 1010, 0, 0, ‘VITREOUS’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OS’)
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(‘Eye_QP_RETINA_defaults’, ‘OUVITREOUS_vh’, ‘vit: hemorrhage’, 1020, 0, 0, ‘VITREOUS’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OU’)
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.
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.
The ‘Authorize - my encounters’ object of the ‘Encounters’ section is already found in the ‘Administrators’ group ‘write’ ACL.
The ‘Coding - my encounters (write,wsome optional)’ object of the ‘Encounters’ section is already found in the ‘Administrators’ group ‘write’ ACL.
The ‘Notes - my encounters (write,addonly optional)’ object of the ‘Encounters’ section is already found in 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.
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)
UPGRADING ACCESS CONTROLS TO VERSION 9:
Checking to ensure all the proper ACL(access control list) are present:
‘Administrators’ group ‘write’ ACL is present.
‘Accounting’ group ‘view’ ACL is present.
‘Clinicians’ group ‘view’ ACL is present.
‘Emergency Login’ group ‘write’ ACL is present.
‘Front Office’ group ‘view’ ACL is present.
‘Physicians’ group ‘view’ ACL is present.
Adding new object sections
Adding new objects
The ‘Patient Report’ object in the ‘Patients’ section has been successfully added.
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Administrators’ group ‘write’ ACL.
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Accounting’ group ‘view’ ACL.
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Clinicians’ group ‘view’ ACL.
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Emergency Login’ group ‘write’ ACL.
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Front Office’ group ‘view’ ACL.
Successfully placed the ‘Patient Report’ object of the ‘Patients’ section into the ‘Physicians’ group ‘view’ ACL.
Updating the ACLs(Access Control Lists)
DONE upgrading access controls
Updating version indicators…
Database and Access Control upgrade finished.’’’
