SOLVED: There was an OpenEMR SQL Escaping ERROR of the following string country_of_origin

infrastructure
question

(Sherwin Gaddis) #1

I made a mistake and deleted the layout_group_properties and layout_options table.
I restored them from a previous backup.

Now, when we try to use the patient search, there is a DataTable error message that comes up.
When I look in the console under the network, this error message appears.

    <br><span style='color:red;font-weight:bold;'>There was an OpenEMR SQL Escaping ERROR of the following string country_of_origin</span><br>

How can I fix this?

Figured out what this was.

This error comes when the LBF does not match the table columns.

I added the missing table columns.