Notes section error

OpenEMR Development
1

bb2013 wrote on Friday, November 01, 2013:

One user with front desk staff ACL privileges gets this error when she tries to access patient notes under the demographics section. We are using 4.1.2.

ERROR: query failed: select genericname2, genericval2 from patient_data where

pid=? order by date DESC limit 0,1

Error: Unknown column ‘genericname2’ in ‘field list’

Somehow she can still access notes but this error always appears.
Any ideas would be greatly appreciated.

2

mdsupport wrote on Friday, November 01, 2013:

Someone changed the layout for demographics and instead of marking these standard fields as not in use, they chose to delete. That deletes the column from table and you get missing fields.

To fix, go to layout and add ‘genericname2’ field in any tab - just set to not in use.