Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.9.0 (build 3095) - 09 October 2020 (please see announcement regarding releases since 3.5.0)
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 the NOAA report and Snow Index drop-down menus to 2030)

Use this Wiki link to Download the Software (Cumulus MX / Cumulus 1 and other related items).

Mysql databse error

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
The PIT
Posts: 117
Joined: Thu 10 Dec 2009 6:15 pm
Weather Station: Davis VP2 Wireless
Operating System: Windows 7 32 bit
Location: England
Contact:

Mysql databse error

Post 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?
Based in Sunny Old Sheffield South Yorkshire England

www.sheffieldweather.co.uk

water01
Posts: 1983
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: WH1081
Operating System: Windows 10 64bit
Location: Burnham-on-Sea
Contact:

Re: Mysql databse error

Post 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.
David
Image

The PIT
Posts: 117
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

Post 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
Based in Sunny Old Sheffield South Yorkshire England

www.sheffieldweather.co.uk

The PIT
Posts: 117
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

Post by The PIT »

Is there anyway to regenerate the previous monthly database values?
Based in Sunny Old Sheffield South Yorkshire England

www.sheffieldweather.co.uk

User avatar
dazza1223
Posts: 544
Joined: Sun 25 Jan 2015 8:41 pm
Weather Station: Davis Vantage Vue
Operating System: Windows 10
Location: Worthing
Contact:

Re: Mysql databse error

Post by dazza1223 »

Have fun and keep learning

dazza :D

Image

water01
Posts: 1983
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: WH1081
Operating System: Windows 10 64bit
Location: Burnham-on-Sea
Contact:

Re: Mysql databse error

Post 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.
David
Image

The PIT
Posts: 117
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

Post 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.
Based in Sunny Old Sheffield South Yorkshire England

www.sheffieldweather.co.uk

Post Reply