IMPORTANT! The server may go down soon - possibly permanently. Please read the latest post in Announcements and News

FTP is broken. I advise all users using my server for their web site to make alternative arrangements.

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: 493
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: 493
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

User avatar
dazza1223
Posts: 393
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
have fun and keep learning

dazza :D

User avatar
dazza1223
Posts: 393
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
have fun and keep learning

dazza :D

User avatar
dazza1223
Posts: 393
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
have fun and keep learning

dazza :D

jlmr731
Posts: 118
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"

User avatar
dazza1223
Posts: 393
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.
have fun and keep learning

dazza :D

cazz
Posts: 5
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: 5194
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch 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: 692
Joined: Mon May 19, 2014 10:45 pm
Weather Station: Davis VPro2 Plus
Operating System: Debian 9.5 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://twitter.com/conligwx
Davis Vantage Pro2+ - CumulusMX v3.0.0 (build 3043) + Saratoga/PWS
Image

User avatar
mcrossley
Posts: 5194
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch 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: 5194
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch 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: 692
Joined: Mon May 19, 2014 10:45 pm
Weather Station: Davis VPro2 Plus
Operating System: Debian 9.5 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://twitter.com/conligwx
Davis Vantage Pro2+ - CumulusMX v3.0.0 (build 3043) + Saratoga/PWS
Image

sfws
Posts: 445
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: Customised mix of Fine Offset
Operating System: Tempermental Win. 10 PC
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: 5194
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch 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: No registered users and 3 guests