Error 1054 Unknown column in 'field list'

Resolve a database column error in a custom form.

Overview

The error occurs because a previously added field was removed from the database table, but the form's save action still references it.
Clear the form cache, delete the existing save data action, and recreate it without enabling the auto-manage table option.

Answered
ChronoForms v6
om omidhz 20 Oct, 2018
When I was making and troubleshooting multiple forms, few columns were added to my joomla.users form by accident.
I created a custom user registration form that was working perfectly fine. When I returned and deleted those extra fields from the joomla.users form, now I get the error
1054 Unknown column "users.street" in "field list". If I add the field the jooma.user table, the error goes away.
I checked my custom form and I don't have anyting in the form to save "street" in database.
I'm not sure why this is causing an issue and how to fix it.
he healyhatman 23 Oct, 2018
Answer
Clear the cache, delete the save data action and save the form and then recreate your save data action. Make sure you DO NOT have the "Auto manage table" checked
This topic is locked and no more replies can be posted.