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
dazza1223 wrote:
Wed 09 Sep 2020 6:12 pm
yup use this

https://cumuluswiki.org/a/ImportCumulusFile
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.