Page 1 of 1
MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 6:42 am
by flort
I updated to the latest build and have found an issue when updating with the Dayfile editor. Changes to Chill Hours, High 24 Hour Rain, and High 24 Hour Rain Time are not being written to the MySQL database. The following screenshots demonstrate what I am seeing -
CMX prior to making any changes
CMX before change.jpg
Database prior to making any changes
SQL before change.jpg
CMX after changes
CMX after change.jpg
Database after changes
SQL after change.jpg
Also, if I decide to only populate some of the fields the ones left as null value are changed as below -
Selected CMX fields updated
CMX update humidex and 24 hour rain only.jpg
Resulting change in Database
SQL after humidex and 24 hour rain only.jpg
Regards,
Trevor
Re: MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 8:10 am
by mcrossley
Can you try flushing your browser cache please.- I tested the dayfile editor, and checked it again just now and it works OK for me.
Re: MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 9:01 am
by flort
Hi Mark,
I flushed everything but still no change. The changes are saved in CMX but not being reflected in MySQL for those 3 fields. All other fields are updating fine.
Regards,
Trevor
Re: MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 10:27 am
by mcrossley
Ah, I understand now. Yes, the database update on edit for the new fields got missed, now fixed for the next release.
Re: MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 11:23 am
by flort
Thanks Mark. The other thing I highlighted was that if you update a record that has null values and you only update some of the fields then it changes the null values to -9999.0. Is that the expected behaviour or should it leave it as a null value? Refer back to the last 2 screenshots to understand what I'm talking about.
Regards,
Trevor
Re: MySQL database not updating correctly in Build 3202
Posted: Thu 25 Aug 2022 12:30 pm
by mcrossley
It's expected, but not ideal. Unfortunately this version of Cumulus like C1 has no concept of null values, so I'll have to add code to cope with that.
Re: MySQL database not updating correctly in Build 3202
Posted: Mon 29 Aug 2022 11:24 am
by flort
Hi Mark,
Just confirming that Chill Hours, High 24 Hour Rain, and High 24 Hour Rain Time are now updating in the MySQL Database. Also, it is handling null values correctly.
Thanks for the changes.
Regards,
Trevor
Re: MySQL database not updating correctly in Build 3202
Posted: Mon 29 Aug 2022 7:34 pm
by mcrossley