Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

MySQL Out of range value for column 'ChillHours'

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
User avatar
rogerthn
Posts: 547
Joined: Thu 11 Apr 2013 6:31 pm
Weather Station: Ecowitt GW1000/GW1003
Operating System: Raspberry Pi OS bullseye aarch64
Location: Trollhättan Sweden
Contact:
Contact rogerthn

MySQL Out of range value for column 'ChillHours'

Post by rogerthn »

I did have some invalid wind yesterday and needed to update, but.
MysQL Dayfile ChillHours do have decimal(5,2) and the Dayfile Viewer/Editor have vaules > 999.99, hence update did fail.
I did change to decimal(7,2) and my update was OK.
Image
Top
User avatar
mcrossley
Posts: 14384
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:
Contact mcrossley

Re: MySQL Out of range value for column 'ChillHours'

Post by mcrossley »

The table definition was changed back in v3.20.0

There is a script in the distribution zip - /MXutils/v3.20.0-AlterMySqlTables.sql - that adds the ChillHours column with decimal(7,2) to old tables that did not have it.

I don't remember if originally, I had said to use (5,2) or not!
Top
User avatar
rogerthn
Posts: 547
Joined: Thu 11 Apr 2013 6:31 pm
Weather Station: Ecowitt GW1000/GW1003
Operating System: Raspberry Pi OS bullseye aarch64
Location: Trollhättan Sweden
Contact:
Contact rogerthn

Re: MySQL Out of range value for column 'ChillHours'

Post by rogerthn »

mcrossley wrote: ↑Thu 04 Apr 2024 9:21 am The table definition was changed back in v3.20.0

There is a script in the distribution zip - /MXutils/v3.20.0-AlterMySqlTables.sql - that adds the ChillHours column with decimal(7,2) to old tables that did not have it.
OK, must have missed that
mcrossley wrote: ↑Thu 04 Apr 2024 9:21 am I don't remember if originally, I had said to use (5,2) or not!
No worries
Image
Top
Post Reply

Return to “Cumulus MX version 3 (since build 3043)”