Forums

Hi guys
​
I Use joomla 3.10 under PHP 7.3
​
I read data from a table.
I put some "Where conditions to the SQL statement"
I write some conditions like "table field1 = {session:field1}", "table field2 IN {data:fieldB}" and so on...
I save my form, then I close my form
I try: is good.
I open my form to modify the Where conditions: values are empty!!! ... but my form works very well!
​
What can I do!!!
​
Edit: In chronoform table #__chronoforms3_forms7, field=functions, I can see my values !!! but not in the form!!!
​
Edit2:!!!:
There is A VERY BIG BUG in Chronoforms 7 with SQL Where Conditions (Joomla 3.10/PHP 7.3)
If you modify one condition, the modification is not recorded when you apply.
You have to delete and rewrite all the where conditions!

Hi guys
​
I've found origin of this bug:
​
CF7 v.7.0.7 is buging to save Forms. So when you restore Forms 7.0.7 in 7.0.8, datas don't appear in the SQL "Where conditions to the SQL statement".
​
Exemple:
Save by CF7.V07:

"value":["{data:actv}"]

The same saved by CF7 V08:

"value":"{data:actv}"

Conclusion:
Backup forms by CF07 are bad...

Hi Colnem,
​
Please check to see if Max has fixed this bug in v7.0.9
​
Bob

Hi
​
No bug in 7.0.8/7.0.9: The bug is in 7.0.7. But if you download Forms in 7.0.7, you are this bug uploading in 7.0.8/7.0.9.
​
They are some bugs in this last version.
For exemple, Data Base Elements With SQL Where Conditions including operator 'NOT LIKE': after save, you can't open this element to edit it, because 'NOT LIKE' operator is not defined in php conditions files!
​
I'm building a list of bugs...

The NOT LIKE bug is fixed here for the next update, but the "lost conditions" bug is already fixed in 7.0.9, a form with a broken condition in 7.0.7 will not work of course, you have to fix the condition first then save the form again for it to work!

How can I "fix the condition first then save the form again" or edit a backup of a form made in 7.0.7 from SITE A work on SITE B with 7.0.9 on it? A container or Multifield Event's Values using Equals are lost on save. New Event Values are also lost on save with 7.0.9 on SITE B. If I have to, I will build a new form of this type from scratch on SITE B. Hoping to avoid that!
Thank you for any help you offer!

I started the form from scratch and work after first save. The Event's Values are lost after reopening, editing and saving again. Only if I save. Opening does not retrieve the values or populate the fields for the next save. Please help me, outside of this, my forms would be done!

Please post the steps of creating this bug and I will test it here!

So I first add a container and a dropdown (dropdown 7) in it with no label, only Field Name and three options. The first option has no Value only Text and the next two are the only 2 options.
I create 2 multi-fields in the same container and set the hidden and events plus options on each of the two. The first multi-field has 3 Events. One is Hide if ANY Match (IF) Dropdown 7 Equals (option 2 from dropdown), Show if ANY Match IF Dropdown 7 Equals Value Option 1 and Hide if ANY match IF Dropdown 7 is empty.
The second multi field has Show and Hide swapped to show the second multifield and hide the first multifield.
This all works great upon clicking the Apply Button the one up top not the Quick one and this all works in both Admin & Front views and once I save and reload editor or close and reopen for edit the values are not in the field in the Events. If I close the form without saving the form events still work in both front and admin. I can send you the form privately... Max, I have more respect for you and your work than I can ever put into words and thank you.

After clicking "Save changes and reload editor" the Fields where the Value was and should be, are empty. A subsequent Front View proves the the Events are saved in the database yet not repopulating the Events Value data in the editor. Any future edit erases the Value as the field is subsequently saved from editor "empty".

I see the same behaviour as PaulSandman for form field events. If you:

1) Create a field and add an event with a value and save it and close the form it works in the front end
2) If you then open the form in the backend and edit the field with the event, the value for the event condition is lost and if saved without retyping the value the event will not work as intended.

If you open the form but do not edit the field(s) with the events all is ok, ie the value is not lost, which is a workaround whilst building forms albeit a bit inconvenient.

It is a lot more than "a bit inconvenient". The forms cannot be edited, saved and reopened. I cannot build every form every time I open it.

This was fixed QUICKLY.

I tested this here, it works fine, field created, 1 event added, form saved with "apply" or save icon then page reloaded, the event is still there.

Please send me a form backup with the event undisplayed, I mean with just one save as you said, please use the contact form.

I have sent you (separately) a backup of a simple form created from the "contact form" template. The form has two fields, the second field is initially hidden.
The second field has two events:
* if the value in the first field is >10, it will display the second field.
* if the value in the first field is <= 10 it will hide the second field.

Without further edits the forms works as expected.

To recreate the issue:
1) open the form in admin
2) edit the second field, - you should see the where clause values are missing.
3) Save the form
4) Open the front end view of the form and the display of the second field no longer works.

if you do not edit the second field, but instead just edit the first or add a third field (say), all is ok.
Using php 8.0.26 and Joomla 3.10.11 and chronoforms 7.0.9

I noticed there is now a 7.0.10 version, which has the field event issue fixed. Many thanks.

so the issue you posted is fully fixed ?

Yes, the issue I had with form field event condition values not being reloaded on modification of the field is fixed in CF 7.0.10. Many thanks for the rapid turnaround.

Yes, I too can confirm that this latest version has functionality fully restored! Incredible work, this is GREAT! Thank You!