I have just moved hosts for my website and as part of the process decided I would try and get CumulusMX to do all the MYSQL stuff as well.
However, it appears to be failing when trying to update the MYSQL table. I originally had a problem connecting which seems to be resolved after discussion with the host, but now in MXDIAG I get this message:
2019-01-12 00:00:00.344 Dayfile.txt opened for writing
2019-01-12 00:00:00.345 Writing entry to dayfile.txt
2019-01-12 00:00:00.358 INSERT IGNORE INTO Dayfile (LogDate,HighWindGust,HWindGBear,THWindG,MinTemp,TMinTemp,MaxTemp,TMaxTemp,MinPress,TMinPress,MaxPress,TMaxPress,MaxRainRate,TMaxRR,TotRainFall,AvgTemp,TotWindRun,HighAvgWSpeed,THAvgWSpeed,LowHum,TLowHum,HighHum,THighHum,TotalEvap,HoursSun,HighHeatInd,THighHeatInd,HighAppTemp,THighAppTemp,LowAppTemp,TLowAppTemp,HighHourRain,THighHourRain,LowWindChill,TLowWindChill,HighDewPoint,THighDewPoint,LowDewPoint,TLowDewPoint,DomWindDir,HeatDegDays,CoolDegDays,HighSolarRad,THighSolarRad,HighUV,THighUV,HWindGBearSym,DomWindDirSym) Values('19-01-11',17.0,262,'23:36',2.7,'08:02',8.3,'23:43',1024.92,'23:46',1031.83,'10:55',0.0,'00:00',0.0,5.9,31.0,6.0,'21:08',84,'00:04',96,'08:47',0.25,0.0,8.3,'23:43',6.9,'23:23',1.0,'08:02',0.0,'00:00',2.7,'08:02',6.6,'23:50',1.8,'08:02',258,12.4,0.0,128,'11:54',0.0,'00:00','W','WSW')
2019-01-12 00:00:01.014 Error encountered during MySQL operation.
2019-01-12 00:00:01.014 Unknown column 'LowHum' in 'field list'
2019-01-12 00:00:01.025 Raincounter = 1.2 Raindaystart = 1.2
I don't have a LowHum column (in addition to some others as well) in the MySQL dayfile table, so is it erroring because of this and why does it not just ignore it if it isn't there?
Thanks.