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

**URL:** <https://community.open-emr.org/t/error-unknown-column-suffix-in-field-list-while-creating-patient-in-openemr-7-0-1/21343>\
**Category:** Onboarding\
**Created:** [October 12, 2023, 6:20pm UTC](https://community.open-emr.org/t/error-unknown-column-suffix-in-field-list-while-creating-patient-in-openemr-7-0-1/21343 "2023-10-12T18:20:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Divya\_Mallela](https://community.open-emr.org/user_avatar/community.open-emr.org/divya_mallela/32/19171_2.png) [@Divya\_Mallela](https://community.open-emr.org/u/Divya_Mallela)\
**Post date:** [October 12, 2023, 6:20pm UTC](https://community.open-emr.org/t/error-unknown-column-suffix-in-field-list-while-creating-patient-in-openemr-7-0-1/21343/1 "2023-10-12T18:20:03Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\
**Post date:** [October 12, 2023, 10:46pm UTC](https://community.open-emr.org/t/error-unknown-column-suffix-in-field-list-while-creating-patient-in-openemr-7-0-1/21343/2 "2023-10-12T22:46:50Z")

</div>

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