Forums

Error 1054 Unknown column in 'field list'

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.
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.