MySQL database not updating correctly in Build 3202

[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

[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.

[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

[mcrossley]

Ah, I understand now. Yes, the database update on edit for the new fields got missed, now fixed for the next release.

[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

[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.

[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

[mcrossley]