Error during upgrade from 4.3.0 to devtip / 5

OpenEMR Development
1

tmccormi wrote on Thursday, September 29, 2016:

Got this error during an upgrade operation:

INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘poag’,‘POAG’, 10,‘ICD10:H40.11X4’,‘eye’)
ERROR: query failed: INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘poag’,‘POAG’, 10,‘ICD10:H40.11X4’,‘eye’)

Error: Unknown column ‘subtype’ in ‘field list’

… devtip/openemr/library/sql_upgrade_fx.php at 675:sqlStatement

2

tmccormi wrote on Thursday, September 29, 2016:

getting ready for a demo to a potentially large customer that will (eventually) need MU2 …

3

tmccormi wrote on Thursday, September 29, 2016:

Got it (thanks Yehster!) had to back the default start point up by one sub release to 4.2.1, it had defaulted to 4.2.2