Forums

error 1060 Duplicate column name

Maxvl 25 Nov, 2018
Hello
When adding a new field (it is not in the database) to the form created above
there is always an error 1060 Duplicate column name ...

After clearing the cache -from the second time can add a field
healyhatman 25 Nov, 2018
Answer
Don't use Auto Manage Table. Make your table yourself, much more reliable.
rslyra 27 Mar, 2020
Hi.

I know this a old post, but it is the only about this subject.

What means "Don't use Auto Manage Table".

1 - I didn't find this option to disable it.
2 - How you load and save data? Custom blocks?
healyhatman 27 Mar, 2020
Auto Manage Table, a checkbox in the Save Data action, automatically adds or deletes columns to your selected data table when you save your form. It's fine when you're just dumping data in a table and don't care about data validation or format or anything..
rslyra 27 Mar, 2020
And if you disable it, you use the "Data override" on the Save Data?
rslyra 27 Mar, 2020
I disable "Auto manage the data table". Then insert my new field and save. Ok. Then enable "Auto manage the data table" and save. Ok.

Let's see how long I go with this.
This topic is locked and no more replies can be posted.