arnabnaha wrote on Saturday, December 04, 2010:
Hi…
I am trying to upgrade the database after extracting the openemr files from the recent commit of the github. I am getting the following errors after i upgrade from the 3.2 database by using localhost/openemr/sql_upgrade…A part of it is pasted below…
Skipping section #IfNotTable eligibility_response
Skipping section #IfNotTable eligibility_verification
Skipping section #IfNotRow2D list_options list_id lists option_id smoking_status
UPDATE layout_options SET seq=2 WHERE form_id = ‘HIS’ AND field_id=‘coffee’
UPDATE layout_options SET data_type=32,seq=1,fld_length=0,list_id=‘smoking_status’ WHERE form_id = ‘HIS’ AND field_id=‘tobacco’
Skipping section #IfMissingColumn drug_sales distributor_id
Skipping section #IfNotRow2D list_options list_id abook_type option_id dist
Skipping section #IfNotRow2D list_options list_id adjreason option_value 1
Skipping section #IfNotRow2D user_settings setting_label billing_ps_expand setting_user 0
ALTER TABLE listsADD reaction varchar(255) NOT NULL DEFAULT ‘’
ERROR: query failed: ALTER TABLE listsADD reaction varchar(255) NOT NULL DEFAULT ‘’
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘reaction varchar(255) NOT NULL DEFAULT ‘’’ at line 1
How to solve this…