Cumulus Support

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 ?



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

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!

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