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 4017) - 17 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

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: 260
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: 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

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: 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

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: 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

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: 860
Joined: Sun 25 Jan 2015 8:41 pm
Weather Station: Davis Vantage Pro 2 plus
Operating System: Raspberry pi 4 (4gb)
Location: Worthing
Contact:

Re: Mysql databse error

Post by dazza1223 »

Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
water01
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

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: 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

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