Jaanus
Super Moderator
Hi,
databasejoin element that is
rendering in "repeat" mode (checkbox, multiselect)
AND is also itself in repeated group
cannot submit data and
after submission attempt it returns this error message:
Store row failed:
Unknown column 'params' in 'field list' SQL=UPDATE `teos_perf_koos` SET `time_date`='2012-07-11 21:56:00',`teos_id`='333',`lisas`='42',`muutis`='0',`alg_id`='0',`koosseis`='',`params`=NULL WHERE id='60'
`teos_perf_koos` is a joined table.
join is from main table teos_mus_vers.id to teos_perf_koos.teos_id
`koosseis` is a field originally behind of dbjoin element.
'params' is actually an empty field with unknown purpose in the table `teos_perf_koos_repeat_koosseis` that exists behind the dbjoin element when it is in repeated mode.
In my case Fabrik form thought in some unknown reasons that this 'params' field is in the joined `teos_perf_koos` table. (Could this cause that data was not submitted?)
Unfortunately this time I couldn't find the exact source of the issue, so I ask help here. Otherwise you found a pull request instead.
P.S. rendering in form view and adding new values from frontend worked well, also displaying of earlier submitted data.
databasejoin element that is
rendering in "repeat" mode (checkbox, multiselect)
AND is also itself in repeated group
cannot submit data and
after submission attempt it returns this error message:
Store row failed:
Unknown column 'params' in 'field list' SQL=UPDATE `teos_perf_koos` SET `time_date`='2012-07-11 21:56:00',`teos_id`='333',`lisas`='42',`muutis`='0',`alg_id`='0',`koosseis`='',`params`=NULL WHERE id='60'
`teos_perf_koos` is a joined table.
join is from main table teos_mus_vers.id to teos_perf_koos.teos_id
`koosseis` is a field originally behind of dbjoin element.
'params' is actually an empty field with unknown purpose in the table `teos_perf_koos_repeat_koosseis` that exists behind the dbjoin element when it is in repeated mode.
In my case Fabrik form thought in some unknown reasons that this 'params' field is in the joined `teos_perf_koos` table. (Could this cause that data was not submitted?)
Unfortunately this time I couldn't find the exact source of the issue, so I ask help here. Otherwise you found a pull request instead.
P.S. rendering in form view and adding new values from frontend worked well, also displaying of earlier submitted data.