repetear does not save to sql

How to save data from a form with a repeater area to the database.

Overview

The issue occurs because the auto-manage database feature does not support array-style field names generated by repeaters.
Manually create the database table and add the fields to the data override list, or consider saving repeated entries to a separate table or encoding them as JSON for storage.

Answered
ChronoForms v6
em emrahsevgi 31 Dec, 2018
hi;

I have a multipage form which form's last page has a repeater area with multiply option. I attached screenshots of events and last page fields. My form does not save datas to form's database. I can not find my mistake.

Happy new year!

thanks for your help.

Debugger result is:

repetear does not save to sql image 1



repetear does not save to sql image 2
repetear does not save to sql image 3
he healyhatman 31 Dec, 2018
Auto manage doesn't work with array style field names. Build your database table manually and manually add the fields to the data override list
em emrahsevgi 31 Dec, 2018
thanks for your answer. But repater is creating fields on database. I checked in phpmyadmin. Form does not saving repeater are or unrepeater area. Problem is not only on repater fields. And if a user wants creating much more fields by multiply button, how can I know how much field I will create.

If I can not do this by multiply can I do that according to dropdown data provider?

thanks and happy new year
em emrahsevgi 31 Dec, 2018
thanks for your answer. But repater is creating fields on database. I checked in phpmyadmin. Form does not saving repeater area or unrepeater area. Problem is not only on repater fields.
And if a user wants creating much more fields by multiply button, how can I know how much field I will create. If I can not do this by multiply can I do that according to dropdown data provider?
thanks and happy new year
he healyhatman 31 Dec, 2018
Need to either save each as an entry on another table and reference the parent table, or JSON encode them and save them as a TEXT or JSON field in the database.
em emrahsevgi 31 Dec, 2018
I removed repeater area and fields. But form does not save datas to joomla database. I attached phpmyadmin screenshot and debugger result screenshots. thank you.

repetear does not save to sql image 4
repetear does not save to sql image 5
Gr GreyHead 31 Dec, 2018
Answer
2 Likes
Hi emrahsevgi,

The Debugger output you have posted does not show any evidence of a DB Save action.

Bob
This topic is locked and no more replies can be posted.