db read conditions corrupted??

How to fix corrupted CF database read conditions after saving.

Overview

The issue occurs when conditions using date parameters are saved and then automatically change upon reloading the form editor.
Use the correct date format without a placeholder for static values and ensure logical operators are properly set. The developer has confirmed a fix will be included in a future update.

Ni NickOg 03 Apr, 2019

An odd one - I am finding that when I set conditions as below

db read conditions corrupted?? image 1

then save and test - all works fine.

Then I reload and edit the form the settings are changing.

db read conditions corrupted?? image 2

I have checked it several times. Has anyone else hit this???

Can I switch back to the Where Window????

Nick

he healyhatman 03 Apr, 2019

Not sure but the $ in the date is only needed in the second one, as in when you have a parameter to pass. The first one can just be {date:Y}

he healyhatman 03 Apr, 2019

Also wouldn't you want an OR operator in between those?

Ni NickOg 03 Apr, 2019

I was re-reading your notes in that paper by Max earlier today and had sorted that out in my mind. Thanks..
Yes, it should be OR as you suggest
intYear = {date:Y) OR intYear <= {date Y$ + 1 years}
or
intYear >= {date:Y) AND intYear <= {date Y$ + 1 years}

I think, 🙄
I will try that tomorrow.

Nick

he healyhatman 03 Apr, 2019

Definitely the second one.

Max_admin 04 Apr, 2019

Answer

Hi,

Thank you for reporting this, it should be fixed in the next update!

Best regards

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Ni NickOg 08 Apr, 2019

1 Likes

That's fixed it Max - Thanks.

Next one - can we have a 'fold' for a complete event and section. 🤣🤣

Great stuff
Regards

Nick

Max_admin 08 Apr, 2019

Hi Nick,

No problem!

Next one - can we have a 'fold' for a complete event and section

Yes, this is on the todo list!🙂

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.