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 4018) - 28 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

Top 10 Records Page

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Mapantz
Posts: 1775
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

Post by Mapantz »

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/
Last edited by Mapantz on Sun 01 Jan 2017 11:28 pm, edited 2 times in total.
Image
Mapantz
Posts: 1775
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

Post by Mapantz »

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.
Image
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: Top 10 Records Page

Post by dazza1223 »

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
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
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: Top 10 Records Page

Post by dazza1223 »

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 :D :D :D
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
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: Top 10 Records Page

Post by dazza1223 »

hi i saw it ur post to stop ppl reading db_ro_details.php what permissions do i have to set to hide it
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

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

Post by jlmr731 »

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"
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: Top 10 Records Page

Post by dazza1223 »

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.
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
cazz
Posts: 13
Joined: Sun 24 Sep 2017 12:18 pm
Weather Station: ws-0101
Operating System: Windows 10

Re: Top 10 Records Page

Post by cazz »

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

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?
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

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...
User avatar
ConligWX
Posts: 1570
Joined: Mon 19 May 2014 10:45 pm
Weather Station: Davis vPro2+ w/DFARS + AirLink
Operating System: Ubuntu 22.04 LTS
Location: Bangor, NI
Contact:

Re: Top 10 Records Page

Post by ConligWX »

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...
disregard..................., left out datafile entry...
Regards Simon

https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir •

Image
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

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
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

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.
User avatar
ConligWX
Posts: 1570
Joined: Mon 19 May 2014 10:45 pm
Weather Station: Davis vPro2+ w/DFARS + AirLink
Operating System: Ubuntu 22.04 LTS
Location: Bangor, NI
Contact:

Re: Top 10 Records Page

Post by ConligWX »

mcrossley 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.
working here on MariaDB 5.5.57/PHP 7.1.10

Thank you Mark :clap:
Regards Simon

https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus with Daytime FARS • WeatherLink Live • Davis AirLink • PurpleAir •

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

Post by sfws »

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...
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

Doh! We'll have to remain in the time warp until tomorrow now.
Thanks.
Post Reply