Error: Unknown column 'suffix' in 'field list' while creating patient in openemr 7.0.1?

ERROR: query failed: select pid, id, lname, fname, mname, suffix, providerID, DATE_FORMAT(DOB,’%m/%d/%Y’) as DOB_TS from patient_data where pid = ‘8’ order by lname ASC, fname ASC
Error: Unknown column ‘suffix’ in ‘field list’

how to sortout this error in openemr 7.0.1?

hi @Divya_Mallela , restore that missing field in the demographics layout?