Installed mcsTemp last night to trial. No 1-wire devices to install yet, so I set it up to log existing devices. The logging worked correctly overnight until I added another device to monitor; my RCS Thermostat current temp, which is device "[1". That's when logging of virtual devices stopped and the errors began:
8/30/2007 11:51:22 AM mcsTemperature Debug EvaluateDeviceAction DeviceActionCollection.Count=0, MonitoredEventCount=0
8/30/2007 11:52:22 AM mcsTemperature Debug setIO _60 from 0 to 19, brightness=0
8/30/2007 11:52:22 AM mcsTemperature Debug setDevice _60 from 3 to 3
8/30/2007 11:52:22 AM mcsTemperature Debug Log Temperature Sensor Count=3, INSERT INTO Temperature(SampleDate,AtticTemp,Baro,DS Stat) SELECT #2007-08-30 11:52:22 AM# AS QT,9600 AS Q0,2984 AS Q1,7900 AS Q2
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Log Temperature SQL Error Syntax error in INSERT INTO statement. on line 840 Syntax error in INSERT INTO statement. </font>
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Change Field because , error number=0, Fields=AtticTemp,4,Baro,4,DS Stat,4 </font>
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Log Temperature Retry SQL Error Syntax error in INSERT INTO statement. on line 900 Syntax error in INSERT INTO statement. </font>
8/30/2007 11:52:22 AM mcsTemperature Debug EvaluateDeviceAction DeviceActionCollection.Count=0, MonitoredEventCount=0
Any ideas what I did wrong?
8/30/2007 11:51:22 AM mcsTemperature Debug EvaluateDeviceAction DeviceActionCollection.Count=0, MonitoredEventCount=0
8/30/2007 11:52:22 AM mcsTemperature Debug setIO _60 from 0 to 19, brightness=0
8/30/2007 11:52:22 AM mcsTemperature Debug setDevice _60 from 3 to 3
8/30/2007 11:52:22 AM mcsTemperature Debug Log Temperature Sensor Count=3, INSERT INTO Temperature(SampleDate,AtticTemp,Baro,DS Stat) SELECT #2007-08-30 11:52:22 AM# AS QT,9600 AS Q0,2984 AS Q1,7900 AS Q2
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Log Temperature SQL Error Syntax error in INSERT INTO statement. on line 840 Syntax error in INSERT INTO statement. </font>
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Change Field because , error number=0, Fields=AtticTemp,4,Baro,4,DS Stat,4 </font>
8/30/2007 11:52:22 AM <font color="#FF0000">mcsTemperature Debug Log Temperature Retry SQL Error Syntax error in INSERT INTO statement. on line 900 Syntax error in INSERT INTO statement. </font>
8/30/2007 11:52:22 AM mcsTemperature Debug EvaluateDeviceAction DeviceActionCollection.Count=0, MonitoredEventCount=0
Any ideas what I did wrong?
Comment