joomla db error when saving form

Question

I get the following joomla error when saving a form with Apply:


An error has occurred.

    1091 Can't DROP 'descrizione'; check that column/key exists

Descrizione is a textarea.

I have to reload the form and update the form because everything added from the last saved session is lost.

I'm not sure but it isn't happening every time I apply but once yes and once no.

Any suggestion?

Thank you
maxx

cf v6.0.12 joomla 3.8.2

emmexx · Accepted Answer

I solved, sort of, by changing all other fields in the form that had the word descrizione in the name or id.

I didn't have duplicated names or ids but:

textarea -> name = descrizione, id = descrizione
textbox in a repeater -> [Model][{var::area_repeater111.key}][descrizione]

...

I changed

[Model][{var::area_repeater111.key}][descrizione]

to

[Model][{var::area_repeater111.key}][desc]

and the error disappeared. Iḿ not sure why.

maxx

joomla db error when saving form

Resolve a Joomla database error when saving a form in ChronoForms.

Overview