Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024
(Note that 4.1.0 (build 4024) - 05 June 2024 remains available, but usage of this version is not recommended - particularly for Davis stations - and the included utility in this distribution for migrating to v4 is known to contain errors affecting conversion of dayfile.txt)
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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 V4 release 4.0.1 (build 4023) - 16 May 2024
(Note that 4.1.0 (build 4024) - 05 June 2024 remains available, but usage of this version is not recommended - particularly for Davis stations - and the included utility in this distribution for migrating to v4 is known to contain errors affecting conversion of dayfile.txt)
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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
Top 10 Records Page
Moderator: daj
-
- Posts: 1834
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Top 10 Records Page
Edit:
I decided to spend some time getting a fresh template up and running for dazza, today - I'm absolutely exhausted! Hopefully he likes it?!
http://www.davisworthing.co.uk/
I decided to spend some time getting a fresh template up and running for dazza, today - I'm absolutely exhausted! Hopefully he likes it?!
http://www.davisworthing.co.uk/
Last edited by Mapantz on Sun 01 Jan 2017 11:28 pm, edited 2 times in total.
-
- Posts: 1834
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Top 10 Records Page
I've spoken to dazza via PM, and he has apologised for what he did. I have offered some help to get him on his way, but I have limited time myself, so he may make a thread asking for a little bit of help.
Could I request that the posts concerning this, be deleted? I should've known better than to take the topic off in a different direction, I apologise for that.
Could I request that the posts concerning this, be deleted? I should've known better than to take the topic off in a different direction, I apologise for that.
- dazza1223
- Posts: 878
- 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: Top 10 Records Page
hi yh im sorry two like i said i dint do it in a way to be nasty i did as i fined it hard to learn stuf but i wont go in to it! and a big thanks to Mapantz for showing me the template and geting me started thank u
- dazza1223
- Posts: 878
- 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: Top 10 Records Page
this gose out to Mapantz who just kindly setup up my template for me and i luv the and i can now buil on that thank u so much for all ur hard work and advise and heping me out so much thank u
- dazza1223
- Posts: 878
- 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: Top 10 Records Page
hi i saw it ur post to stop ppl reading db_ro_details.php what permissions do i have to set to hide it
-
- Posts: 225
- Joined: Sat 27 Aug 2016 12:11 am
- Weather Station: Davis vantage pro 2
- Operating System: Debian
- Location: Wickliffe, Ohio
- Contact:
Re: Top 10 Records Page
you can put it out side your web server root directory
say if your web root is /var/www/html then put it in /var/www then in the top10 php in the include "db_ro_details.php' you would make it something like this include "/var/www/db_ro_details.php"
say if your web root is /var/www/html then put it in /var/www then in the top10 php in the include "db_ro_details.php' you would make it something like this include "/var/www/db_ro_details.php"
Jeff
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
- dazza1223
- Posts: 878
- 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: Top 10 Records Page
do u mined if i send u the files so u can check thank
Code: Select all
[attachment=0]Desktop.rar[/attachment]
You do not have the required permissions to view the files attached to this post.
-
- Posts: 13
- Joined: Sun 24 Sep 2017 12:18 pm
- Weather Station: ws-0101
- Operating System: Windows 10
Re: Top 10 Records Page
Hi
Nice script.
I use Comulus MX to save to a MySQL database and almost got it to work.
Did have to change the table but I get this error
Not sure what more I have forgot?
Nice script.
I use Comulus MX to save to a MySQL database and almost got it to work.
Did have to change the table but I get this error
Code: Select all
ERROR - Bad Select Statement (3) -Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cumulus.Dayfile.LogDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Not sure what more I have forgot?
- mcrossley
- Posts: 12966
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
It looks like it is a combination of a new default setting in MySQL 5.7.5 (sql_mode=only_full_group_by) and my sloppy select statements. I'll need to take a look at what needs to be done to fix this...
- ConligWX
- Posts: 1681
- Joined: Mon 19 May 2014 10:45 pm
- Weather Station: Davis vPro2+ w/DFARS + AirLink
- Operating System: Ubuntu 24.04 LTS
- Location: Bangor, NI
- Contact:
Re: Top 10 Records Page
disregard..................., left out datafile entry...mcrossley wrote:It looks like it is a combination of a new default setting in MySQL 5.7.5 (sql_mode=only_full_group_by) and my sloppy select statements. I'll need to take a look at what needs to be done to fix this...
Regards Simon
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir • CumulusMX v4.0.0
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir • CumulusMX v4.0.0
- mcrossley
- Posts: 12966
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
I have applied a quick and dirty fix - the script should now disable "sql_mode=only_full_group_by" if it is set for the duration of the query sessions.
Ver 1.4
Ver 1.4
- mcrossley
- Posts: 12966
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
OK, it wasn't too hard to make the queries SQL/99 compliant.
Version 1.5 should fix this problem - reports either way please as my DB isn't at the right version to show the problem.
Version 1.5 should fix this problem - reports either way please as my DB isn't at the right version to show the problem.
- ConligWX
- Posts: 1681
- Joined: Mon 19 May 2014 10:45 pm
- Weather Station: Davis vPro2+ w/DFARS + AirLink
- Operating System: Ubuntu 24.04 LTS
- Location: Bangor, NI
- Contact:
Re: Top 10 Records Page
working here on MariaDB 5.5.57/PHP 7.1.10mcrossley wrote:OK, it wasn't too hard to make the queries SQL/99 compliant.
Version 1.5 should fix this problem - reports either way please as my DB isn't at the right version to show the problem.
Thank you Mark
Regards Simon
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir • CumulusMX v4.0.0
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir • CumulusMX v4.0.0
-
- Posts: 1183
- Joined: Fri 27 Jul 2012 11:29 am
- Weather Station: Chas O, Maplin N96FY, N25FR
- Operating System: rPi 3B+ with Buster (full)
Re: Top 10 Records Page
Mark, you appear to have changed your calendar, your source says version 1.5 was released on 12 Oct 2017!
I know the world lost 10 days in a September a while ago...
I know the world lost 10 days in a September a while ago...
- mcrossley
- Posts: 12966
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
Doh! We'll have to remain in the time warp until tomorrow now.
Thanks.
Thanks.