Situation
Editing a previously saved physical exam form of an encounter. Edited the comment for the GEN system that had a diagnosis (dropdown) previously selected. Error message (below) appeared. Opened the encounter again. Changed from the E46 diagnosis drop-down pick to blank, i.e., no diagnosis. Saved. Then changed the diagnosis for the GEN system back to E46 and saved without further issues. I am not sure if this is reproducible or not. I will attempt to reproduce the issue.
OpenEMR Version
Iβm using OpenEMR version 5.0.1(7)
Browser:
Iβm using: Firefox
Operating System
Iβm using: Amazon AWS (Ubuntu Linux EXPRESS instance)
Error Message
Query Error
ERROR: insert failed: INSERT INTO form_physical_exam ( forms_id, line_id, wnl, abn, diagnosis, comments ) VALUES ( β10567β, βPSYORβ, β0β, β1β, ββ, βAOx0. Did not know name, place, wifeβs name, whether he was married or not, year, month, or time of day.β )
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 βs name, whether he was married or not, year, month, or time of day.β )β at line 1
/var/www/localhost/htdocs/openemr/interface/forms/physical_exam/new.php at 107:sqlInsert