Page 1 of 1
MySQL Out of range value for column 'ChillHours'
Posted: Thu 04 Apr 2024 8:17 am
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.
Re: MySQL Out of range value for column 'ChillHours'
Posted: Thu 04 Apr 2024 9:21 am
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!
Re: MySQL Out of range value for column 'ChillHours'
Posted: Thu 04 Apr 2024 10:24 am
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