Debug logs for 3.0.2

[bwawsc]

I started HS with 3.0.2 at 10:43. It's now 11:13 and I've seen no debug log messages that indicate an attempt to write data to the database. I would have expected 6 attempts by now.

I did get this when I tried to display a Forecast:

<BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR> 1/4/2003 10:59:28 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 0
1/4/2003 10:59:28 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 1
1/4/2003 10:59:28 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 2
1/4/2003 10:59:28 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 3
1/4/2003 10:59:28 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 4
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 5, Sensor Count=14, Temp=4, Field=6
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R1)) AS Rave, Min(Csng(R1)) AS Rmin, Max(Csng(R1)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND R1&lt;&gt;'0' AND (not isNull(R1))
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R2)) AS Rave, Min(Csng(R2)) AS Rmin, Max(Csng(R2)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND R2&lt;&gt;'0' AND (not isNull(R2))
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R3)) AS Rave, Min(Csng(R3)) AS Rmin, Max(Csng(R3)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND R3&lt;&gt;'0' AND (not isNull(R3))
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=0
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R4)) AS Rave, Min(Csng(R4)) AS Rmin, Max(Csng(R4)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND R4&lt;&gt;'0' AND (not isNull(R4))
1/4/2003 10:59:29 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R22]
1/4/2003 10:59:32 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R22] = "0" WHERE ((([Temperature].[R22]) Is Null)) OR ((([Temperature].[R22])=""))
1/4/2003 10:59:32 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
1/4/2003 10:59:32 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R22)) AS Rave, Min(Csng(R22)) AS Rmin, Max(Csng(R22)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R22))
1/4/2003 10:59:32 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R23]
1/4/2003 10:59:34 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R23] = "0" WHERE ((([Temperature].[R23]) Is Null)) OR ((([Temperature].[R23])=""))
1/4/2003 10:59:35 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=1
1/4/2003 10:59:35 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R23)) AS Rave, Min(Csng(R23)) AS Rmin, Max(Csng(R23)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R23))
1/4/2003 10:59:35 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R26]
1/4/2003 10:59:37 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R26] = "0" WHERE ((([Temperature].[R26]) Is Null)) OR ((([Temperature].[R26])=""))
1/4/2003 10:59:37 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=2
1/4/2003 10:59:37 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R26)) AS Rave, Min(Csng(R26)) AS Rmin, Max(Csng(R26)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R26))
1/4/2003 10:59:37 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R27]
1/4/2003 10:59:40 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R27] = "0" WHERE ((([Temperature].[R27]) Is Null)) OR ((([Temperature].[R27])=""))
1/4/2003 10:59:40 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=2
1/4/2003 10:59:40 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R27)) AS Rave, Min(Csng(R27)) AS Rmin, Max(Csng(R27)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R27))
1/4/2003 10:59:40 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R28]
1/4/2003 10:59:43 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R28] = "0" WHERE ((([Temperature].[R28]) Is Null)) OR ((([Temperature].[R28])=""))
1/4/2003 10:59:44 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=3
1/4/2003 10:59:44 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R28)) AS Rave, Min(Csng(R28)) AS Rmin, Max(Csng(R28)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R28))
1/4/2003 10:59:44 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R24]
1/4/2003 10:59:46 AM~!~mcsTemperature Plugin Debug~!~FixTable SQL UPDATE Temperature SET [Temperature].[R24] = "0" WHERE ((([Temperature].[R24]) Is Null)) OR ((([Temperature].[R24])=""))
1/4/2003 10:59:46 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=4
1/4/2003 10:59:46 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 6 SELECT Avg(CSng(R24)) AS Rave, Min(Csng(R24)) AS Rmin, Max(Csng(R24)) AS Rmax FROM tblTemperatureForecast WHERE SampleDate &gt;=#2002-01-04 10:00# AND SampleDate &lt; #2003-01-04 10:00# AND (not isNull(R24))
1/4/2003 10:59:46 AM~!~mcsTemperature Plugin Debug~!~FixTable field [Temperature].[R]
1/4/2003 10:59:46 AM~!~Temperature Plugin~!~ FixTable: No value given for one or more required parameters.
1/4/2003 10:59:46 AM~!~mcsTemperature Plugin Debug~!~FormatTemperatureScreen Progress 7, Device Type=
1/4/2003 10:59:46 AM~!~Temperature Plugin~!~ FormatTemperatureScreen: Subscript out of range
<HR></BLOCKQUOTE>

--Bill

[bdickhaus]

Same thing here. I have debug turned on, but only get messages when I access the web pages. I went back to logging temp and forecasts using events for now. I did try changing the database name to an invalid name and I got an error message, so either UPDATE on the setup window, or the plugin, tried to open the database. But when I changed it back, nothing.

Bill

[Michael McSharry]

Please give V3.0.3 a try. It is at V3.0.3 mcsTemperature

The lack of any periodic messages in V3.0.2 indicates that the timer is not producing interrupt events to the plug-in. I do not know why, but I tried a different approach to get it started in V3.0.3.

[bdickhaus]

Temperature logging is now working in 3.0.3.

Thanks Michael!

Bill