Situation
The bronchitis form for an encounter will fail to insert after it is initially saved, edited, and then another save is attempted. Workaround is to delete the form and create a new one. This is reproducible.
OpenEMR Version
I’m using OpenEMR version 5.0.1(7)
Browser:
I’m using: Firefox
Operating System
I’m using: Amazon AWS EXPRESS
Logs
2019-05-27 00:00:00 Test cachectic normal none n/a n/a on None None None None
Query Error
ERROR: insert failed: update form_bronchitis set pid = 53,groupname=‘Default’,user=‘rlukner’,authorized=1,activity=1, date = NOW(), bronchitis_date_of_illness=‘2019-05-27 00:00:00’, bronchitis_hpi=‘Test’, bronchitis_ops_fever=’’, bronchitis_ops_cough=’’, bronchitis_ops_dizziness=’’, bronchitis_ops_chest_pain=’’, bronchitis_ops_dyspnea=’’, bronchitis_ops_sweating=’’, bronchitis_ops_wheezing=’’, bronchitis_ops_malaise=’’, bronchitis_ops_sputum=’’, bronchitis_ops_appearance=‘cachectic’, bronchitis_ops_all_reviewed=’’, bronchitis_review_of_pmh=’’, bronchitis_review_of_medications=’’, bronchitis_review_of_allergies=’’, bronchitis_review_of_sh=’’, bronchitis_review_of_fh=’’, bronchitis_tms_normal_right=’’, bronchitis_tms_normal_left=’’, bronchitis_nares_normal_right=’’, bronchitis_nares_normal_left=’’, bronchitis_tms_thickened_right=’’, bronchitis_tms_thickened_left=’’, bronchitis_tms_af_level_right=’’, bronchitis_tms_af_level_left=’’, bronchitis_nares_swelling_right=’’, bronchitis_nares_swelling_left=’’, bronchitis_tms_retracted_right=’’, bronchitis_tms_retracted_left=’’, bronchitis_nares_discharge_right=’’, bronchitis_nares_discharge_left=’’, bronchitis_tms_bulging_right=’’, bronchitis_tms_bulging_left=’’, bronchitis_tms_perforated_right=’’, bronchitis_tms_perforated_left=’’, bronchitis_tms_nares_not_examined=’’, bronchitis_no_sinus_tenderness=’’, bronchitis_oropharynx_normal=’’, bronchitis_sinus_tenderness_frontal_right=’’, bronchitis_sinus_tenderness_frontal_left=’’, bronchitis_oropharynx_erythema=’’, bronchitis_oropharynx_exudate=’’, bronchitis_oropharynx_abcess=’’, bronchitis_oropharynx_ulcers=’’, bronchitis_sinus_tenderness_maxillary_right=’’, bronchitis_sinus_tenderness_maxillary_left=’’, bronchitis_oropharynx_appearance=‘normal’, bronchitis_sinus_tenderness_not_examined=’’, bronchitis_oropharynx_not_examined=’’, bronchitis_heart_pmi=’’, bronchitis_heart_s3=’’, bronchitis_heart_s4=’’, bronchitis_heart_click=’’, bronchitis_heart_rub=’’, bronchitis_heart_murmur=‘none’, bronchitis_heart_grade=‘n/a’, bronchitis_heart_location=‘n/a’, bronchitis_heart_normal=’’, bronchitis_heart_not_examined=’’, bronchitis_lungs_bs_normal=’’, bronchitis_lungs_bs_reduced=’’, bronchitis_lungs_bs_increased=’’, bronchitis_lungs_crackles_lll=’’, bronchitis_lungs_crackles_rll=’’, bronchitis_lungs_crackles_bll=’’, bronchitis_lungs_rubs_lll=’’, bronchitis_lungs_rubs_rll=’’, bronchitis_lungs_rubs_bll=’’, bronchitis_lungs_wheezes_lll=’’, bronchitis_lungs_wheezes_rll=’’, bronchitis_lungs_wheezes_bll=’’, bronchitis_lungs_wheezes_dll=’’, bronchitis_lungs_normal_exam=‘on’, bronchitis_lungs_not_examined=’’, bronchitis_diagnostic_tests=’’, diagnosis1_bronchitis_form=‘None’, diagnosis2_bronchitis_form=‘None’, diagnosis3_bronchitis_form=‘None’, diagnosis4_bronchitis_form=‘None’, bronchitis_additional_diagnosis=’’, bronchitis_treatment=’’ where id=
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 ‘’ at line 83
/var/www/localhost/htdocs/openemr/interface/forms/bronchitis/save.php at 101:sqlInsert