Thermostat Enhancement Plugin

Code: Select all

Jun 12, 2012 12:06:02 PM
  Enabling plugin "Thermostat Enhancement Add-On 1.01"
  Starting plugin "Thermostat Enhancement Add-On 1.01" (pid 2345)
  Plugin "Thermostat Enhancement Add-On" connected
  Plugin "Thermostat Enhancement Add-On 1.01" started
  Thermostat Enhancement Add-On Debug Version Check Server reports 0.90 is available.
  Thermostat Enhancement Add-On   Debug Mode is activated.  (Only use if testing...)

Jun 12, 2012 12:07:12 PM
  SQL Logger Error                exception trying to insert row into table device_history_201576345 ("HVAC [thermostat enhancement plug-in]") -- unable to modify table
  SQL Logger Error                no such table: device_history_201576345
  SQL Logger Error                INSERT INTO device_history_201576345 (belowminimiumtemp, currentcoolingsetpoint, currentheatsetpoint, currenttemperature, lastupdated, maximumtempexceeded, acdailyruntime, aclastoff, aclaston, aclastruntime, acmonthlyruntime, acweeklyruntime, acyearlyruntime, fandailyruntime, fanlastoff, fanlaston, fanlastruntime, fanmonthlyruntime, fanweeklyruntime, fanyearlyruntime, heatingdailyruntime, heatinglastoff, heatinglaston, heatinglastruntime, heatingmonthlyruntime, heatingweeklyruntime, heatingyearlyruntime) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);


I need to understand this more clearly, and I believe the only way that is going to happen is to examine your Indigo database.

Please zip your database, and send me a copy of it to Benjamin AT schollnick dot net.
I need to see the details about your configuration to solve this...

[jay (support)]

Matt & Jay,

Any idea on why this wouldn't be working on CraigM's system? He's getting SQL Logger Errors...
And I admit it's been a while since I tore apart the Thermostat Enhancement Plugin, but any SQL Logging should be from Indigo, not the plugin?

This error is definitely from the SQL Logger plugin, not from your plugin. It looks like the device table for the device created by your plugin didn't get created - not sure why exactly. It's supposed to create the table any time a new device is created so I'm not sure what went wrong.

[matt (support)]

I was just about to post a reply and see that Jay already did. He is correct that the SQL Logger plugin error is independent of the other issue(s) experienced, and I'm also not sure how that SQL table failed to be created exactly. Restarting the SQL Plugin should recreate any device tables that are missing though. If it doesn't then maybe there is a permission problem with the SQL database (either SQLite file or PostgreSQL database, depending on what is being used).

If that doesn't get rid of the SQL Logger error, then copy/paste from the Event Log showing what is logged when the SQL Logger plugin is restarted. But please do so in a new thread since that is a different problem.

...Restarting the SQL Plugin should recreate any device tables that are missing though. If it doesn't then maybe there is a permission problem with the SQL database (either SQLite file or PostgreSQL database, depending on what is being used).

If that doesn't get rid of the SQL Logger error, then copy/paste from the Event Log showing what is logged when the SQL Logger plugin is restarted.

Code: Select all

Reloading plugin "SQL Logger 1.0.0"
  Stopping plugin "SQL Logger 1.0.0" (pid 2339)
  SQL Logger                      closing SQL connection
  Plugin "SQL Logger" disconnected
  Starting plugin "SQL Logger 1.0.0" (pid 2471)
  Plugin "SQL Logger" connected
  Plugin "SQL Logger 1.0.0" started
  SQL Logger                      connected to /Library/Application Support/Perceptive Automation/Indigo 5/Logs/indigo_history.sqlite
  SQL Logger                      updating all device tables
  SQL Logger                      creating table device_history_201576345 for "HVAC [thermostat enhancement plug-in]"
  SQL Logger                      updating all variable tables
  SQL Logger                      update complete

[jay (support)]

That would be the SQL Logger working correctly - it created the thermostat plugin device's table so that error shouldn't be showing up any more.

I just tried this plugin and received the following error.

Enabling plugin "SQL Logger 1.0.0"
Starting plugin "SQL Logger 1.0.0" (pid 4647)
Plugin "SQL Logger" connected
Plugin "SQL Logger 1.0.0" started
SQL Logger connected to /Library/Application Support/Perceptive Automation/Indigo 5/Logs/indigo_history.sqlite
SQL Logger updating all device tables
SQL Logger updating all variable tables
SQL Logger update complete
Thermostat Enhancement Add-On Debug Thermostat Adapter change detected
Thermostat Enhancement Add-On Debug states - States : (dict)
hvacFanMode : 0 (integer)
hvacFanMode.ui : auto on (string)
hvacFanModeIsAlwaysOn : false (bool)
hvacFanModeIsAuto : true (bool)
hvacOperationMode : 3 (integer)
hvacOperationMode.ui : auto on (string)
hvacOperationModeIsAuto : true (bool)
hvacOperationModeIsCool : false (bool)
hvacOperationModeIsHeat : false (bool)
hvacOperationModeIsOff : false (bool)
hvacOperationModeIsProgramAuto : false (bool)
hvacOperationModeIsProgramCool : false (bool)
hvacOperationModeIsProgramHeat : false (bool)
setpointCool : 78 (real)
setpointHeat : 65 (real)
temperatureInput1 : 78 (real)
temperatureInputsAll : 78 (string)
Thermostat Enhancement Add-On Error Error in plugin execution ServerReplacedElem:

Traceback (most recent call last):
File "plugin.py", line 220, in deviceUpdated
File "plugin.py", line 87, in value_change
<type 'exceptions.KeyError'>: key hvacCoolerIsOn not found in dict

I am on Indigo 5.1.2
Venstar T1700
RF Adapter 2441V Rev 1.1

Any help is appreciated.

<type 'exceptions.KeyError'>: key hvacCoolerIsOn not found in dict[/color]
I am on Indigo 5.1.2
Venstar T1700
RF Adapter 2441V Rev 1.1

Okay, I'll have to add some better error checking there, so it can fail gracefully.

That error has something to do with your Venstar T1700 thermostat.

For some reason the Thermostat adapter doesn't have in it's states hvacCoolerIsOn as a value.... Do you have AC?

Matt & Jay, is there a reason that a Venstar w/Insteon adapter wouldn't have hvacCoolerIsOn? I'm running Indigo v5.11 and these are the states that I am seeing with my Venstar w/Insteon Adapter...

Code: Select all

     states : States : (dict)
     hvacCoolerIsOn : off (on/off bool)
     hvacFanIsOn : off (on/off bool)
     hvacFanMode : 0 (integer)
     hvacFanMode.ui : auto on (string)
     hvacFanModeIsAlwaysOn : false (bool)
     hvacFanModeIsAuto : true (bool)
     hvacHeaterIsOn : off (on/off bool)
     hvacOperationMode : 3 (integer)
     hvacOperationMode.ui : auto on (string)
     hvacOperationModeIsAuto : true (bool)
     hvacOperationModeIsCool : false (bool)
     hvacOperationModeIsHeat : false (bool)
     hvacOperationModeIsOff : false (bool)
     hvacOperationModeIsProgramAuto : false (bool)
     hvacOperationModeIsProgramCool : false (bool)
     hvacOperationModeIsProgramHeat : false (bool)
     setpointCool : 68 (real)
     setpointHeat : 70 (real)
     temperatureInput1 : 72 (real)
     temperatureInputsAll : 72 (string)


[matt (support)]

I believe if the user is either using an older pre-rev2 adapter, or if the user has a newer adapter but hasn't Define and Sync'd it since upgradging Indigo or the adapter, then that value won't exist. Ditto with heaterIsOn and fanIsOn.

Yes, I have AC and the thermostat works fine.

<type 'exceptions.KeyError'>: key hvacCoolerIsOn not found in dict[/color]

JpAction,

From what Matt & Jay have said your problem, maybe one of two things:

1) You have a Rev 1 Insteon Adapter for your Venstar. It would not create those states, since the adapter does send feedback to Indigo. (Indigo has to poll with the v1 adapters).

2) You had a Rev 1 adapter, but have upgraded, and for some reason Indigo didn't update the device record correctly.

If you have a Rev 1 adapter for the Venstar, then this plugin simply won't work. It is not designed to work with the v1 adapters, since they require Indigo to poll the Thermostat...

Assuming you have a Rev 2 adapter... Could you please open your Thermostat device record, and Choose Define and Sync, and Press Sync. That will force Indigo to update the device information.

I just release v1.05 of the Thermostat Enhancement Plugin, and it will log the error, but not crash.... It also includes the ability to restrict the Setpoints on the Thermostat within set boundaries...

http://www.schollnick.net/wordpress/hom ... at-add-on/

I believe if the user is either using an older pre-rev2 adapter, or if the user has a newer adapter but hasn't Define and Sync'd it since upgradging Indigo or the adapter, then that value won't exist. Ditto with heaterIsOn and fanIsOn.

Is that a dependable way to test for a Rev 1 adapter? I can certainly add the logic at startup to check for those states...

- Ben

[jay (support)]

If those are missing then the scenario is as Matt describes - you don't know if it's a Rev 1 adaptor or an upgraded Rev 2 adaptor.

And FYI it's not about polling - the Rev 1 adaptors simply didn't provide that information. So Indigo doesn't know whether the HVAC or Fan are actually on. The Rev 2 adaptors send out broadcasts when those change so Indigo can track those.

I am working on the next version of the Enhanced Thermostat plugin, and the biggest feature that is being added is, probably the most requested....

Unlimited Thermostats!

Yes, before you could only have one Insteon Thermostat in the house... And Well, face it, I have a ranch house with a single Thermostat....
Now, after this is finished... You will be able to have multiple Thermostat's being tracked, by it's own Enhanced Thermostat Monitor.

But, here's the issue. I can't test this personally with my configuration. I only have a single Thermostat.. So, if you want this feature made available, please contact me at Benjamin AT schollnick DOT net, and in the subject line put "ET BETA". If you could describe your Indigo setup briefly, I would appreciate it.

- Benjamin

Is anyone using this plugin and getting data??

Just installed v 1.05
Created a device, cycled the AC a few times, but there is no data in the device window or control page states. Also the log doesn't show any run time activity.

Is there another step needed for the plugin to collect and display data?

RELOAD

Code: Select all

Sep 1, 2012 12:27:34 PM
  Reloading plugin "Thermostat Enhancement Add-On 1.05"
  Stopping plugin "Thermostat Enhancement Add-On 1.05" (pid 19040)
  Plugin "Thermostat Enhancement Add-On" disconnected
  Starting plugin "Thermostat Enhancement Add-On 1.05" (pid 19733)
  Plugin "Thermostat Enhancement Add-On" connected
  Plugin "Thermostat Enhancement Add-On 1.05" started
  Thermostat Enhancement Add-On Debug Version Check Server reports 0.90 is available.
  Thermostat Enhancement Add-On   Debug Mode is activated.  (Only use if testing...)

Indigo 5.1.5
Venstar T1800
Insteon adapter 2441v, rev2.4r, 95 (i2cs engine)
OS 10.5.8

Is anyone using this plugin and getting data??

Just installed v 1.05
Created a device, cycled the AC a few times, but there is no data in the device window or control page states. Also the log doesn't show any run time activity.

Is there another step needed for the plugin to collect and display data?

RELOAD

Code: Select all

Sep 1, 2012 12:27:34 PM
  Reloading plugin "Thermostat Enhancement Add-On 1.05"
  Stopping plugin "Thermostat Enhancement Add-On 1.05" (pid 19040)
  Plugin "Thermostat Enhancement Add-On" disconnected
  Starting plugin "Thermostat Enhancement Add-On 1.05" (pid 19733)
  Plugin "Thermostat Enhancement Add-On" connected
  Plugin "Thermostat Enhancement Add-On 1.05" started
  Thermostat Enhancement Add-On Debug Version Check Server reports 0.90 is available.
  Thermostat Enhancement Add-On   Debug Mode is activated.  (Only use if testing...)

Indigo 5.1.5
Venstar T1800
Insteon adapter 2441v, rev2.4r, 95 (i2cs engine)
OS 10.5.8

Have you created a Thermostat Monitoring Device in your devices?

- Benjamin