I just added some new weather devices to mcsTemp (from virtual devices), now no longer getting any new entries updated/displayed. I remapped 1 virtual device (changed X12 to W1), and added several new. I turned on general logging, and see the following (note the syntax error at the end):
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Chart SQL2=
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Chart SQL3=
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Data Elements=360, Data Names=11
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~X Axis Data Completed
5/23/2005 1:28:42 PM~!~mcsTemperature Debug~!~Y Axis Data Completed
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 5, Sensor Count=12
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(House) AS Rave, Min(House) AS Rmin, Max(House) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND House<>0 AND (not isNull(House))
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(Guest) AS Rave, Min(Guest) AS Rmin, Max(Guest) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND Guest<>0 AND (not isNull(Guest))
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(Family) AS Rave, Min(Family) AS Rmin, Max(Family) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND Family<>0 AND (not isNull(Family))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(ThermHt) AS Rave, Min(ThermHt) AS Rmin, Max(ThermHt) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND ThermHt<>0 AND (not isNull(ThermHt))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(ThermCool) AS Rave, Min(ThermCool) AS Rmin, Max(ThermCool) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND ThermCool<>0 AND (not isNull(ThermCool))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(outsidetemp) AS Rave, Min(outsidetemp) AS Rmin, Max(outsidetemp) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND outsidetemp<>0 AND (not isNull(outsidetemp))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(windspeed) AS Rave, Min(windspeed) AS Rmin, Max(windspeed) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(windspeed))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(windgust) AS Rave, Min(windgust) AS Rmin, Max(windgust) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(windgust))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(raintoday) AS Rave, Min(raintoday) AS Rmin, Max(raintoday) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(raintoday))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=4
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(humidity) AS Rave, Min(humidity) AS Rmin, Max(humidity) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(humidity))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=2
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(barometer) AS Rave, Min(barometer) AS Rmin, Max(barometer) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(barometer))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=3
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(index) AS Rave, Min(index) AS Rmin, Max(index) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(index))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=7
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL=SELECT Format([SampleDate],"yyyy/mm/dd hh:mm") AS StartDate, Avg(House) AS Q1, Avg(Guest) AS Q2, Avg(Family) AS Q3, Avg(ThermHt) AS Q4, Avg(outsidetemp) AS Q6, Avg(windspeed) AS Q7, Avg(windgust) AS Q8, Avg(raintoday) AS Q9, Avg(humidity) AS Q10, Avg(barometer) AS Q11, Avg(index) AS Q12 FROM Temperature WHERE SampleDate >= #2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# GROUP BY Format([SampleDate],"yyyy/mm/dd hh:mm")
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL2=
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL3=
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~Data Elements=360, Data Names=11
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~X Axis Data Completed
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~Y Axis Data Completed
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Database Timer=1
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Log Temperature Sensor Count=12, INSERT INTO Temperature(SampleDate,House,Guest,Family,ThermHt,ThermCool, outsidetemp,windspeed,windgust,raintoday,humidity,barometer, index) SELECT #2005-05-23 1:29:28 PM# AS QT,7400 AS Q0,7500 AS Q1,7200 AS Q2,4000 AS Q3,6600 AS Q4,8710 AS Q5,100 AS Q6,300 AS Q7,0 AS Q8,3700 AS Q9,2982 AS Q10,8610 AS Q11
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Change Field because Syntax error in INSERT INTO statement., error number=-2147217900, Fields=House,4,Guest,4,Family,4,ThermHt,4,ThermCool,4,outsid etemp,4,windspeed,3,windgust,3,raintoday,1,humidity,4,barome ter,4,index,4
5/23/2005 1:29:40 PM~!~mcsTemperature Sensor Info~!~, HS:#1, Index:0, DB:House,0,1
Even the untouched original temperatures are not updating. I am not sure where the problem is. Am I correct in assuming the virtual devices can contain text after the numerical value? (example my original house temperature contains xx degrees F, in mcsTemperature is shows as xx - like it ignores the text afterwards).
Any ideas appreciated!
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Chart SQL2=
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Chart SQL3=
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~Data Elements=360, Data Names=11
5/23/2005 1:28:41 PM~!~mcsTemperature Debug~!~X Axis Data Completed
5/23/2005 1:28:42 PM~!~mcsTemperature Debug~!~Y Axis Data Completed
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 5, Sensor Count=12
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(House) AS Rave, Min(House) AS Rmin, Max(House) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND House<>0 AND (not isNull(House))
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(Guest) AS Rave, Min(Guest) AS Rmin, Max(Guest) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND Guest<>0 AND (not isNull(Guest))
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:10 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(Family) AS Rave, Min(Family) AS Rmin, Max(Family) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND Family<>0 AND (not isNull(Family))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(ThermHt) AS Rave, Min(ThermHt) AS Rmin, Max(ThermHt) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND ThermHt<>0 AND (not isNull(ThermHt))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(ThermCool) AS Rave, Min(ThermCool) AS Rmin, Max(ThermCool) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND ThermCool<>0 AND (not isNull(ThermCool))
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:11 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(outsidetemp) AS Rave, Min(outsidetemp) AS Rmin, Max(outsidetemp) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND outsidetemp<>0 AND (not isNull(outsidetemp))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(windspeed) AS Rave, Min(windspeed) AS Rmin, Max(windspeed) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(windspeed))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(windgust) AS Rave, Min(windgust) AS Rmin, Max(windgust) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(windgust))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(raintoday) AS Rave, Min(raintoday) AS Rmin, Max(raintoday) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(raintoday))
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=4
5/23/2005 1:29:12 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(humidity) AS Rave, Min(humidity) AS Rmin, Max(humidity) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(humidity))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=2
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(barometer) AS Rave, Min(barometer) AS Rmin, Max(barometer) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(barometer))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=3
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(index) AS Rave, Min(index) AS Rmin, Max(index) AS Rmax FROM Temperature WHERE SampleDate >=#2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# AND (not isNull(index))
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~FormatTemperatureScreen Progress 7, Device Type=7
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL=SELECT Format([SampleDate],"yyyy/mm/dd hh:mm") AS StartDate, Avg(House) AS Q1, Avg(Guest) AS Q2, Avg(Family) AS Q3, Avg(ThermHt) AS Q4, Avg(outsidetemp) AS Q6, Avg(windspeed) AS Q7, Avg(windgust) AS Q8, Avg(raintoday) AS Q9, Avg(humidity) AS Q10, Avg(barometer) AS Q11, Avg(index) AS Q12 FROM Temperature WHERE SampleDate >= #2005-05-23 8:00# AND SampleDate < #2005-05-23 14:00# GROUP BY Format([SampleDate],"yyyy/mm/dd hh:mm")
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL2=
5/23/2005 1:29:13 PM~!~mcsTemperature Debug~!~Chart SQL3=
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~Data Elements=360, Data Names=11
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~X Axis Data Completed
5/23/2005 1:29:14 PM~!~mcsTemperature Debug~!~Y Axis Data Completed
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Database Timer=1
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Log Temperature Sensor Count=12, INSERT INTO Temperature(SampleDate,House,Guest,Family,ThermHt,ThermCool, outsidetemp,windspeed,windgust,raintoday,humidity,barometer, index) SELECT #2005-05-23 1:29:28 PM# AS QT,7400 AS Q0,7500 AS Q1,7200 AS Q2,4000 AS Q3,6600 AS Q4,8710 AS Q5,100 AS Q6,300 AS Q7,0 AS Q8,3700 AS Q9,2982 AS Q10,8610 AS Q11
5/23/2005 1:29:28 PM~!~mcsTemperature Debug~!~Change Field because Syntax error in INSERT INTO statement., error number=-2147217900, Fields=House,4,Guest,4,Family,4,ThermHt,4,ThermCool,4,outsid etemp,4,windspeed,3,windgust,3,raintoday,1,humidity,4,barome ter,4,index,4
5/23/2005 1:29:40 PM~!~mcsTemperature Sensor Info~!~, HS:#1, Index:0, DB:House,0,1
Even the untouched original temperatures are not updating. I am not sure where the problem is. Am I correct in assuming the virtual devices can contain text after the numerical value? (example my original house temperature contains xx degrees F, in mcsTemperature is shows as xx - like it ignores the text afterwards).
Any ideas appreciated!
Comment