error 1060 Duplicate column name

Resolve a duplicate column name error when adding a new field in ChronoForms.

Overview

The error occurs because the Auto Manage Table feature attempts to create a column that already exists.
Disable the Auto Manage Table option in the Save Data action, manually add the field to your database table, and then re-enable the feature if needed.

Ma 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

he healyhatman 25 Nov, 2018

Answer

Don't use Auto Manage Table. Make your table yourself, much more reliable.

rs 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?

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

rs rslyra 27 Mar, 2020

And if you disable it, you use the "Data override" on the Save Data?

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