Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.5 (build 3282) - 23 February 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

Highcharts Graphs

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
User avatar
billy
Posts: 255
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: WLL / Davis VP2+
Operating System: RPi bullseye
Location: Gooseberry Hill, Western Australia

Re: Highcharts Graphs

Post by billy »

One step at a time! SQL was completely foreign to me until I started using Cumulus - and I'm still really only a novice.
The it guy wrote: Sun 09 May 2021 10:53 am Warning: #1048 Column 'insolation' cannot be null
So, I'm guessing this problem is because there are days in your monthly table that do not have any data. Check to see if that is the case. If so, add this to the end of the script that establishes your rainsuninsolByMonthHour table to ensure it has at least one row for every day:

Code: Select all

INSERT IGNORE INTO rainsuninsolByMonthHour(LogDateTime)
VALUES
("yyyy-mm-dd hh:mm:00");
(replace the date/time letters with the appropriate digits). Mine looks like this:
("2019-02-02 12:59:00");


if you have more than one day completely missing, separate each one by a comma and terminate the last one with a semicolon as in:

Code: Select all

INSERT IGNORE INTO rainsuninsolByMonthHour(LogDateTime)
VALUES
("yyyy-mm-dd hh:mm:00"),
("yyyy-mm-dd hh:mm:00"),
("yyyy-mm-dd hh:mm:00");
There's probably an easier and more elegant way of doing this but I don't know what it is :?

Let me know how you get on. If you can eliminate this error then we are one step closer to a satisfactory outcome :)
The it guy
Posts: 29
Joined: Fri 22 Feb 2019 12:46 am
Weather Station: Davis
Operating System: Windows 10

Re: Highcharts Graphs

Post by The it guy »

Ok I will do that at the weekend as working a lote I can play and thank you Billy you're very patient man i appreciate it
Mapantz
Posts: 1772
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Highcharts Graphs

Post by Mapantz »

This one is for Mark;

I have spotted a bug in the wind direction on the recent graphs page..

On your graph;

If you move the cursor to the last point of wind before it turns calm, 20:21 it says gust speed is 12mph in the tooltip..
If you now select 6 hour zoom and go to 20:21 again, it says gust speed is 1mph

The same thing happens to me.
Image
User avatar
mcrossley
Posts: 12641
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Highcharts Graphs

Post by mcrossley »

Both the 12h and 6h plots show 1 mph for me.
I'm thinking it is screen resolution thing, what screen res are you using to view the graph?
Mapantz
Posts: 1772
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Highcharts Graphs

Post by Mapantz »

3840 x 2160
Image
User avatar
mcrossley
Posts: 12641
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Highcharts Graphs

Post by mcrossley »

Hmm, dunno then, both your site and mine are displaying the correct data for me - Edge 104.0.1293.47
Mapantz
Posts: 1772
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Highcharts Graphs

Post by Mapantz »

I'm using Edge too.

Well, that's crap!

I'll post on the highcharts forum and see what they say..

I've also played about with different resolutions, the same thing occurs.
Image
Mapantz
Posts: 1772
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Highcharts Graphs

Post by Mapantz »

Good ol' Highcharts update has buggered up a bunch of graphs!

I had a look at the changelog, but cannot see what would be the cause of the problems. I cannot be bothered to post over there either, so I'll just have to use a CDN of the previous version.
Image
Mapantz
Posts: 1772
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Highcharts Graphs

Post by Mapantz »

So, the highstock.js cdn was on v10.3.3, whilst all of the other highcharts files were on 11.0.0. That's why the charts were failing.

It was fixed by this morning. However, the cdn has now gone back to v10.3.3, causing the charts to break again.
Image
Post Reply