Forums

After update to the v6.0.27 forms made on previous version does not work, "fail" error above Message and Event loader

serguei_kp 07 Apr, 2019
Hello,
My form no more sends confirmation email nor shows a confirmation message and Loop event saving data to table does not work any more.
Can you please, in detail, explain how to alter forms made with v6.0.21 to make it work on v6.0.27?


Best regards.
serguei_kp 07 Apr, 2019
When I hit Save button I've got this error message:
[!--StartFragment--]1054
- Unknown column '0' in 'field list'[!--EndFragment--]
serguei_kp 07 Apr, 2019
I've activated the error report on my site and see this error on the front end after from submitting:
Notice: Undefined offset: 1 in/home/aramisvosv/www/libraries/cegcore2/admin/extensions/chronofc/helpers/parser.php on line97

I've this error on two test sites, one is running on PHP 5.6 another on PHP 7.2
Max_admin 07 Apr, 2019
Please post a screenshot for your setup section, and for the Loop config!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
serguei_kp 07 Apr, 2019
Thank you I will do it in few minutes, while I do it may be you can take a look on the backup of the form?
serguei_kp 07 Apr, 2019
[file=11987]Prod_for_coach_booking_pages_v_1_06_Apr_2019_18_42_22.cf6bak[/file]
Max_admin 07 Apr, 2019
Ok, I checked the form, but its not easy to debug this here without the tables, so please create a form copy, delete all the unnecessary setup actions and keep only the loop and the Save, then test the form, does it have the same error ? if yes then you may try to disable the "Auto save fields" setting in the "Save data", does it solve the issue ?

You will be doing this on a form copy!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
serguei_kp 07 Apr, 2019
Auto save fields are disabled,
serguei_kp 07 Apr, 2019
I noticed that if I disable Google reCaptcha there is no error: 1054- Unknown column '0' in 'field list'
but still nothing saved to the data table.
serguei_kp 07 Apr, 2019
I deleted everything in Setup except the Loop event, but the problem is still here.

serguei_kp 07 Apr, 2019
But when I restore the old version v6.0.21 it works fine on the same site.
Except this error message:
Notice: Undefined offset: 1 in/home/aramistaak/www/test3/libraries/cegcore2/admin/extensions/chronofc/helpers/parser.php on line83
serguei_kp 07 Apr, 2019
If you want, I can give you admin access on my test site?
Max_admin 07 Apr, 2019
No need for login, please add a debugger after the loop and paste the debug report here!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
serguei_kp 07 Apr, 2019
I added debugger, but it does not work, I see only the same page with the error.
Max_admin 07 Apr, 2019
Answer
1 Likes
Ok, its your "Save data" in the loop, the data provider is wrong, it should be
{var:loop_event16.row}
Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
serguei_kp 07 Apr, 2019
Yes, thank you it woks!
Did it changed since v6.0.21? Because that is what I have on my test site {data:loop_event16.row} and it works on v6.0.21?
Max_admin 07 Apr, 2019
Yes, there was a small change which caused this conflict, I have adjusted this now!

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.