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.
I’m using OpenEMR version 5.0.1(7)
I’m using: Firefox
I’m using: Amazon AWS (Ubuntu Linux EXPRESS instance)
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