Bronchitis form fails insert query after its initial save (reproducible)


(Ralf Lukner MD PhD) #1

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


(Stephen Waite) #2

hi @Ralf_Lukner, not able to reproduce this on 5.0.2 dev demo pt phil belford