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
Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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
Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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
Moderator: mcrossley
-
- 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
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);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.
(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.