Page 1 of 1
Mysql databse error
Posted: Mon 07 Sep 2020 7:02 pm
by The PIT
I've noticed in mxdiags that it's complaining that there isn't a feelslike column in the Monthly table and it's correct.
I've added it using toad does it matter I can't set the Null value?
Re: Mysql databse error
Posted: Mon 07 Sep 2020 7:52 pm
by water01
In build 3076 "Feels Like" was implemented and in that release notice
viewtopic.php?p=142085#p142085 there is MySQL update file UpdateMYSQL-b3076.zip that adds this field and additional "Feels Like" fields to the MySQL database.
I would suggest you read this release notice and back out your field addition and then run the .sql file to correctly update the database file.
Re: Mysql databse error
Posted: Tue 08 Sep 2020 7:12 pm
by The PIT
Ran the script via toad but it didn't do anything.
So I deleted the database and created it once again via cumulusmx and the column is there
Re: Mysql databse error
Posted: Wed 09 Sep 2020 6:09 pm
by The PIT
Is there anyway to regenerate the previous monthly database values?
Re: Mysql databse error
Posted: Wed 09 Sep 2020 6:12 pm
by dazza1223
Re: Mysql databse error
Posted: Wed 09 Sep 2020 6:14 pm
by water01
But make sure you use that latest one released in the same build 3076.
Re: Mysql databse error
Posted: Sun 13 Sep 2020 1:21 pm
by The PIT
I got there before you for once. One file has an error in it but don't know which. Anyway database seems populated now.