unknown column in field list: neither column in table nor field in form exists

Resolve a 1054 error for an unknown column in a CF form.

Overview

The error occurs because CF caches old database column names, even after renaming them in the table and form.
Clear the CF cache via the admin area's "More" menu to force the system to reload the current table structure.

Answered
ChronoForms v7
kg kgriffin 29 Oct, 2020
I am getting a 1054 error when trying to view my form with a Read Data. It says: Unknown column 'scholapp.date' in 'fieldlist'. At one point there was a column "date" in the table, but I changed it to "date_submitted". The field in the form is named accordingly. I have no idea why it keeps looking for the column "date".

I went through some suggestions for a similar situation someone had in Chronoform6: clearing my browser cache, deleting the Read Data, saving the form, then recreating the Read Data. It said something about unchecking "Auto Manage Table" but I cannot find anything like that in Chronoform7.

I do not know where to go from here.
Max_admin Max_admin 29 Oct, 2020
Answer
in the v7 admin area top menu, click the more option "..." then choose "Clear cache", that will clear the tables fields cache!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.