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?
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.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
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.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
Mysql databse error
Moderator: mcrossley
-
- Posts: 3215
- Joined: Sat 13 Aug 2011 9:33 am
- Weather Station: Ecowitt HP2551
- Operating System: Windows 10 64bit
- Location: Burnham-on-Sea
- Contact:
Re: Mysql databse error
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.
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.
-
- Posts: 260
- Joined: Thu 10 Dec 2009 6:15 pm
- Weather Station: Davis VP2 Wireless
- Operating System: Windows 7 32 bit
- Location: England
- Contact:
Re: Mysql databse error
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
So I deleted the database and created it once again via cumulusmx and the column is there
-
- Posts: 260
- Joined: Thu 10 Dec 2009 6:15 pm
- Weather Station: Davis VP2 Wireless
- Operating System: Windows 7 32 bit
- Location: England
- Contact:
Re: Mysql databse error
Is there anyway to regenerate the previous monthly database values?
-
- Posts: 3215
- Joined: Sat 13 Aug 2011 9:33 am
- Weather Station: Ecowitt HP2551
- Operating System: Windows 10 64bit
- Location: Burnham-on-Sea
- Contact:
Re: Mysql databse error
But make sure you use that latest one released in the same build 3076.
-
- Posts: 260
- Joined: Thu 10 Dec 2009 6:15 pm
- Weather Station: Davis VP2 Wireless
- Operating System: Windows 7 32 bit
- Location: England
- Contact:
Re: Mysql databse error
I got there before you for once. One file has an error in it but don't know which. Anyway database seems populated now.