Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Top 10 Records Page

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

Moderators: daj, TNETWeather

User avatar
Mapantz
Posts: 464
Joined: Sat Dec 17, 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64 - A beast.
Location: Wareham, Dorset - UK
Contact:

Re: Top 10 Records Page

Postby Mapantz » Sun Jan 01, 2017 12:55 pm

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 Jan 01, 2017 11:28 pm, edited 2 times in total.
Image
Image

User avatar
Mapantz
Posts: 464
Joined: Sat Dec 17, 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64 - A beast.
Location: Wareham, Dorset - UK
Contact:

Re: Top 10 Records Page

Postby Mapantz » Sun Jan 01, 2017 1:25 pm

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
Image

dazza1223
Posts: 172
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Top 10 Records Page

Postby dazza1223 » Sun Jan 01, 2017 2:33 pm

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: 172
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Top 10 Records Page

Postby dazza1223 » Tue Jan 03, 2017 10:54 am

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

dazza1223
Posts: 172
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Top 10 Records Page

Postby dazza1223 » Fri Jan 27, 2017 9:50 pm

hi i saw it ur post to stop ppl reading db_ro_details.php what permissions do i have to set to hide it

jlmr731
Posts: 112
Joined: Sat Aug 27, 2016 12:11 am
Weather Station: Davis vantage pro 2
Operating System: Debian
Location: Youngstown, Ohio
Contact:

Re: Top 10 Records Page

Postby jlmr731 » Sat Jan 28, 2017 12:46 am

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"

dazza1223
Posts: 172
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Top 10 Records Page

Postby dazza1223 » Sat Jan 28, 2017 4:53 pm

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.

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

Re: Top 10 Records Page

Postby cazz » Sun Oct 01, 2017 8:21 pm

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: 5014
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Mon Oct 02, 2017 9:28 am

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
Toxic17
Posts: 563
Joined: Mon May 19, 2014 10:45 pm
Weather Station: Davis Vantage Pro2 Plus
Operating System: Debian 9.1 Stretch
Location: Bangor, NI
Contact:

Re: Top 10 Records Page

Postby Toxic17 » Mon Oct 02, 2017 2:52 pm

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
https://www.conligwx.org/pws/
https://www.conligwx.org/pws1/

https://twitter.com/conligwx
Davis Vantage Pro2+ - CumulusMX v3.0.0 (build 3043) + Saratoga/PWS
Image

User avatar
mcrossley
Posts: 5014
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Mon Oct 02, 2017 4:15 pm

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: 5014
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Mon Oct 02, 2017 4:56 pm

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
Toxic17
Posts: 563
Joined: Mon May 19, 2014 10:45 pm
Weather Station: Davis Vantage Pro2 Plus
Operating System: Debian 9.1 Stretch
Location: Bangor, NI
Contact:

Re: Top 10 Records Page

Postby Toxic17 » Mon Oct 02, 2017 5:09 pm

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
https://www.conligwx.org/pws/
https://www.conligwx.org/pws1/

https://twitter.com/conligwx
Davis Vantage Pro2+ - CumulusMX v3.0.0 (build 3043) + Saratoga/PWS
Image

sfws
Posts: 349
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: off-line Fine Offset plus others
Operating System: off-line Vista and W10 PCs
Location: UK

Re: Top 10 Records Page

Postby sfws » Mon Oct 02, 2017 8:01 pm

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: 5014
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Mon Oct 02, 2017 8:57 pm

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


Return to “Web site - General”

Who is online

Users browsing this forum: Bing [Bot], water01 and 4 guests