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

SQL

Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.

Moderator: mcrossley

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

SQL

Post by dazza1223 »

hey all i was just reading about 1 rows were affected in cumulus log and i saw some ppl post on it but has any one fond a fix for it ? :D



2018-08-21 23:00:00.350 Sunset : 20:10:09
2018-08-21 23:00:00.351 Tomorrow sunrise: 05:59:33
2018-08-21 23:00:00.351 Tomorrow sunset : 20:08:08
2018-08-21 23:00:00.359 Writing log entry for 21/08/2018 23:00:00
2018-08-21 23:00:00.360 Written log entry for 21/08/2018 23:00:00
2018-08-21 23:00:00.363 Writing today.ini, LastUpdateTime = 21/08/2018 23:00:00 raindaystart = 96.2 rain counter = 96.2
2018-08-21 23:00:00.365 INSERT IGNORE INTO Monthly (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym) Values('18-08-21 23:00',17.2,92,15.9,1.0,3.0,263,0.0,0.0,1018.22,96.2,25.3,66,0.0,17.2,17.2,0.0,0,0.00,0.00,18.9,0,0.0,240,0.0,0.0,'W','WSW')
2018-08-21 23:00:00.410 MySQL: 1 rows were affected.
2018-08-21 23:00:00.595 Awekas Response: OK: OK
2018-08-21 23:00:00.881 WeatherCloud Response: OK: 200
2018-08-21 23:10:00.394 Writing log entry for 21/08/2018 23:10:00
2018-08-21 23:10:00.395 Written log entry for 21/08/2018 23:10:00
2018-08-21 23:10:00.399 Writing today.ini, LastUpdateTime = 21/08/2018 23:10:00 raindaystart = 96.2 rain counter = 96.2
2018-08-21 23:10:00.400 INSERT IGNORE INTO Monthly (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym) Values('18-08-21 23:10',17.1,92,15.8,0.0,2.0,264,0.0,0.0,1018.25,96.2,25.5,65,0.0,17.1,17.1,0.0,0,0.00,0.00,19.0,0,0.0,274,0.0,0.0,'W','W')
2018-08-21 23:10:00.415 MySQL: 1 rows were affected.
2018-08-21 23:10:00.799 WeatherCloud Response: OK: 200
2018-08-21 23:15:00.565 Awekas Response: OK: OK
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

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

Post by sfws »

dazza1223 wrote: INSERT IGNORE INTO Monthly (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym) Values('18-08-21 23:00',17.2,92,15.9,1.0,3.0,263,0.0,0.0,1018.22,96.2,25.3,66,0.0,17.2,17.2,0.0,0,0.00,0.00,18.9,0,0.0,240,0.0,0.0,'W','WSW')
2018-08-21 23:00:00.410 MySQL: 1 rows were affected.
INSERT IGNORE ... is an instruction for MySQL to insert (Clue the word is INSERT) a row (with columns and values matched as specified by ordering);
(this is the IGNORE bit) only if specified primary key value does not already exist.
MySQL: 1 rows were affected is a reply from MySQL to confirm it has inserted the row requested.

So I'm unsure what it is Daniel that you think needs fixing. This is logging a success every 10 minutes!
Last edited by sfws on Wed 22 Aug 2018 3:06 pm, edited 1 time in total.
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: SQL

Post by dazza1223 »

o sorry so it nothing to worry about then on that end ?
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
Locked