An error message similar to the one below will be displayed when the FormBuilder component tries to save.
We can break the message down so it is easier to understand.
Unknown column 'my_last3' This is telling us that there is a column in the database that does not exist in the form. The element in my form that used to be called "my_last3" was renamed to "hello_world" but the database did not rename the column as well.
in '_data10849_test_error' This is simply telling me the profile ID and the form name where the error occurred.
You can dismiss the error and it will not re-appear so long as you do not add a new element and then "bump into" the unknown element while moving the new ones around. To remedy this error we can do one of two things.
If the form is live and users are actively capturing data you will want to use the first approach.
1. If you know which element(s) are causing the issue then you can simply fill in data for those specific elements on the form that has trouble. If you are unsure what elements are causing the issue then collect a record and make sure to fill in all the inputs on that page so that when the record is submitted the database will add in the appropriate column. If you hide elements conditionally make sure that you trigger the conditions to expose all elements and enter in some data.
2. If the form is not live, the easiest way to remedy this problem is to change the "Input Type" to something other than the current input and save. You can then switch it back to the original type and the error message will be gone.
Please sign in to leave a comment.