Page 28 of 28
Re: Highcharts Graphs
Posted: Mon 10 May 2021 9:39 am
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
Re: Highcharts Graphs
Posted: Mon 10 May 2021 9:42 am
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
Re: Highcharts Graphs
Posted: Tue 09 Aug 2022 8:30 pm
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.
Re: Highcharts Graphs
Posted: Tue 09 Aug 2022 9:24 pm
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?
Re: Highcharts Graphs
Posted: Tue 09 Aug 2022 9:32 pm
by Mapantz
3840 x 2160
Re: Highcharts Graphs
Posted: Wed 10 Aug 2022 10:41 am
by mcrossley
Hmm, dunno then, both your site and mine are displaying the correct data for me - Edge 104.0.1293.47
Re: Highcharts Graphs
Posted: Wed 10 Aug 2022 11:06 am
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.
Re: Highcharts Graphs
Posted: Mon 01 May 2023 10:10 pm
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.
Re: Highcharts Graphs
Posted: Tue 02 May 2023 10:57 pm
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.