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

SQL

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
dazza1223
Posts: 365
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: Davis Vantage Vue
Operating System: raspberry pi 3
Location: worthing
Contact:

SQL

Postby dazza1223 » Tue Aug 21, 2018 10:16 pm

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

sfws
Posts: 430
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: Customised mix of Fine Offset
Operating System: Tempermental Win. 10 PC
Location: UK

Re: SQL

Postby sfws » Wed Aug 22, 2018 6:36 am

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 Aug 22, 2018 3:06 pm, edited 1 time in total.

dazza1223
Posts: 365
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: Davis Vantage Vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: SQL

Postby dazza1223 » Wed Aug 22, 2018 9:23 am

o sorry so it nothing to worry about then on that end ?


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 8 guests