Rachio Plugin (Locked)

Posted on
Thu Apr 27, 2017 2:00 pm
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Rachio Plugin (Locked)

Warning as of February 27th, 2018 - Rachio has apparently started throttling API requests which may cause the plugin to fail. The issues have been addressed in v1.1.3 of the plugin available in the Plugin Store. We highly recommend that everyone upgrade to v1.1.3 or later to avoid issues. Also, check out the docs for the plugin to learn about some new Events you can use to be notified when there are communication and control issues.

We've also created a sub-forum for the Rachio plugin and we've locked this topic. If you have any questions, start a new topic instead. This will help others more easily find answers to questions they may have.

--------------------------------------------------------

This plugin integrates the Rachio sprinkler controllers into Indigo as a standard Indigo Sprinkler. The plugin is hosted on our Github account - check out the repository for details on how to install and use the plugin and you can also download the latest release from there.

I've tested this plugin against the 16-zone controller so I'm pretty confident that it will handle any number of zones up to 16. However, I haven't yet installed it permanently at my home, so it hasn't really been fully tested under normal working conditions. I intend to do that install this weekend (4/29/2017) so it should get a better workout after that. If anyone already has one give it a try and let me know if you have any issues.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Thu Apr 27, 2017 2:25 pm
vtmikel offline
Posts: 628
Joined: Aug 31, 2012
Location: Boston, MA

Re: Rachio Plugin

Thank you! I coincidentally had just purchased one.

Posted on
Thu Apr 27, 2017 2:41 pm
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Rachio Plugin

Definitely let me know how it goes when you start using it. You might want to put it into standby mode at first so Indigo is the only thing doing the irrigation, then introduce Rachio schedules later (that's the approach I'm going to take I think). I like all the intelligence built-in to it, but I'm also a little worried about my landscape dying... ;)

[UPDATE] - I've decided to just let Indigo do all the control rather than try to mix the two approaches.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Thu Apr 27, 2017 8:55 pm
Indy_Larry offline
Posts: 133
Joined: Dec 03, 2013
Location: Indianapolis

Re: Rachio Plugin

Thank you Jay. I got one of these as a gift a few weeks ago. I've installed the plugin but won't know how well it works until after this weekends soaking by mother nature :lol:

Larry

Insteon, Z Wave, Hue, Sonos

Posted on
Fri Apr 28, 2017 4:33 am
Professor Falken offline
User avatar
Posts: 289
Joined: Mar 29, 2015

Re: Rachio Plugin

Oh cool... definitely looking forward to trying this out.

Posted on
Fri Apr 28, 2017 8:12 pm
chobo offline
Posts: 126
Joined: Dec 08, 2013
Location: USA

Re: Rachio Plugin

Jay,

This looks like a great plugin. Thanks for taking the time to put it together for the community!

Unfortunately, I'm getting the following error after inputting the API token into the plugin's configuration. Thinking the extra "/" might be the culprit:
...device//forecast?units=US

Code: Select all
Rachio Sprinklers Debug         Connection to Rachio API server failed with exception:
Traceback (most recent call last):
  File "plugin.py", line 112, in _make_api_call
    r.raise_for_status()
  File "/Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/PlugIns/requests/models.py", line 848, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
HTTPError: 404 Client Error: Not Found for url: https://api.rach.io/1/public/device//forecast?units=US

Thx so much!

Posted on
Sat Apr 29, 2017 1:51 pm
chobo offline
Posts: 126
Joined: Dec 08, 2013
Location: USA

Re: Rachio Plugin

Here's the latest: modified the plugin to remove the extra "/" and now faced with this:

Code: Select all
Rachio Sprinklers Error         Connection to Rachio API server failed with exception: HTTPError. Check the log file for full details.
   Rachio Sprinklers Debug         Connection to Rachio API server failed with exception:
Traceback (most recent call last):
  File "plugin.py", line 112, in _make_api_call
    r.raise_for_status()
  File "/Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/PlugIns/requests/models.py", line 848, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
HTTPError: 403 Client Error: Forbidden for url: https://api.rach.io/1/public/device/forecast?units=US


Anyone else experiencing the same original error or this one?

Posted on
Sat Apr 29, 2017 3:50 pm
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Re: Rachio Plugin

I had something like that - I deleted and recreated the sprinkler device within Indigo and it resolved the problem...

_______
Norm

Posted on
Sat Apr 29, 2017 4:18 pm
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Rachio Plugin

It looks like somehow the rachio api device UUID is missing from the device state (look at the "id" state in the states list). Are you sure you have your device configured correctly? The double // gives the best clue since there's supposed to be a UUID in between them.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Sat Apr 29, 2017 10:09 pm
chobo offline
Posts: 126
Joined: Dec 08, 2013
Location: USA

Re: Rachio Plugin

norcoscia wrote:
I had something like that - I deleted and recreated the sprinkler device within Indigo and it resolved the problem...


norcoscia, This was it. Thanks for the tip!

Jay, All seems to be working now – thanks again for the great contribution.

Posted on
Sun Apr 30, 2017 5:41 am
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Re: Rachio Plugin

Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all
Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")
   SQL Logger Error                duplicate column name: id
   SQL Logger Error                CREATE TABLE device_history_1790308249 ( id #AUTO_INCR_KEY, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "activeschedule" TEXT, "activezone" INTEGER, "activezone_ui" TEXT, "address" TEXT, "current_calculatedprecip" REAL, "current_cloudcover" REAL, "current_cloudcover_ui" TEXT, "current_currenttemperature" REAL, "current_currenttemperature_ui" TEXT, "current_dewpoint" REAL, "current_dewpoint_ui" TEXT, "current_humidity" REAL, "current_humidity_ui" TEXT, "current_iconurl" TEXT, "current_precipintensity" REAL, "current_precipprobability" REAL, "current_precipprobability_ui" TEXT, "current_weathersummary" TEXT, "current_weathertype" TEXT, "current_weathertype_clear_day" BOOL, "current_weathertype_clear_night" BOOL, "current_weathertype_cloudy" BOOL, "current_weathertype_fog" BOOL, "current_weathertype_partly_cloudy_day" BOOL, "current_weathertype_partly_cloudy_night" BOOL, "current_weathertype_rain" BOOL, "current_weathertype_sleet" BOOL, "current_weathertype_snow" BOOL, "current_weathertype_sun" BOOL, "current_weathertype_wind" BOOL, "current_windspeed" INTEGER, "elevation" REAL, "id" TEXT, "instandbymode" BOOL, "latitude" REAL, "longitude" REAL, "model" TEXT, "name" TEXT, "paused" BOOL, "schedulemodetype" TEXT, "serialnumber" TEXT, "status" TEXT, "t0forecast_calculatedprecip" REAL, "t0forecast_cloudcover" REAL, "t0forecast_cloudcover_ui" TEXT, "t0forecast_dewpoint" REAL, "t0forecast_dewpoint_ui" TEXT, "t0forecast_humidity" REAL, "t0forecast_humidity_ui" TEXT, "t0forecast_iconurl" TEXT, "t0forecast_precipintensity" REAL, "t0forecast_precipprobability" REAL, "t0forecast_precipprobability_ui" TEXT, "t0forecast_temperaturemax" REAL, "t0forecast_temperaturemax_ui" TEXT, "t0forecast_temperaturemin" REAL, "t0forecast_temperaturemin_ui" TEXT, "t0forecast_weathersummary" TEXT, "t0forecast_weathertype" TEXT, "t0forecast_weathertype_clear_day" BOOL, "t0forecast_weathertype_clear_night" BOOL, "t0forecast_weathertype_cloudy" BOOL, "t0forecast_weathertype_fog" BOOL, "t0forecast_weathertype_partly_cloudy_day" BOOL, "t0forecast_weathertype_partly_cloudy_night" BOOL, "t0forecast_weathertype_rain" BOOL, "t0forecast_weathertype_sleet" BOOL, "t0forecast_weathertype_snow" BOOL, "t0forecast_weathertype_sun" BOOL, "t0forecast_weathertype_wind" BOOL, "t0forecast_windspeed" REAL, "t10forecast_calculatedprecip" REAL, "t10forecast_cloudcover" REAL, "t10forecast_cloudcover_ui" TEXT, "t10forecast_dewpoint" REAL, "t10forecast_dewpoint_ui" TEXT, "t10forecast_humidity" REAL, "t10forecast_humidity_ui" TEXT, "t10forecast_iconurl" TEXT, "t10forecast_precipintensity" REAL, "t10forecast_precipprobability" REAL, "t10forecast_precipprobability_ui" TEXT, "t10forecast_temperaturemax" REAL, "t10forecast_temperaturemax_ui" TEXT, "t10forecast_temperaturemin" REAL, "t10forecast_temperaturemin_ui" TEXT, "t10forecast_weathersummary" TEXT, "t10forecast_weathertype" TEXT, "t10forecast_weathertype_clear_day" BOOL, "t10forecast_weathertype_clear_night" BOOL, "t10forecast_weathertype_cloudy" BOOL, "t10forecast_weathertype_fog" BOOL, "t10forecast_weathertype_partly_cloudy_day" BOOL, "t10forecast_weathertype_partly_cloudy_night" BOOL, "t10forecast_weathertype_rain" BOOL, "t10forecast_weathertype_sleet" BOOL, "t10forecast_weathertype_snow" BOOL, "t10forecast_weathertype_sun" BOOL, "t10forecast_weathertype_wind" BOOL, "t10forecast_windspeed" REAL, "t11forecast_calculatedprecip" REAL, "t11forecast_cloudcover" REAL, "t11forecast_cloudcover_ui" TEXT, "t11forecast_dewpoint" REAL, "t11forecast_dewpoint_ui" TEXT, "t11forecast_humidity" REAL, "t11forecast_humidity_ui" TEXT, "t11forecast_iconurl" TEXT, "t11forecast_precipintensity" REAL, "t11forecast_precipprobability" REAL, "t11forecast_precipprobability_ui" TEXT, "t11forecast_temperaturemax" REAL, "t11forecast_temperaturemax_ui" TEXT, "t11forecast_temperaturemin" REAL, "t11forecast_temperaturemin_ui" TEXT, "t11forecast_weathersummary" TEXT, "t11forecast_weathertype" TEXT, "t11forecast_weathertype_clear_day" BOOL, "t11forecast_weathertype_clear_night" BOOL, "t11forecast_weathertype_cloudy" BOOL, "t11forecast_weathertype_fog" BOOL, "t11forecast_weathertype_partly_cloudy_day" BOOL, "t11forecast_weathertype_partly_cloudy_night" BOOL, "t11forecast_weathertype_rain" BOOL, "t11forecast_weathertype_sleet" BOOL, "t11forecast_weathertype_snow" BOOL, "t11forecast_weathertype_sun" BOOL, "t11forecast_weathertype_wind" BOOL, "t11forecast_windspeed" REAL, "t12forecast_calculatedprecip" REAL, "t12forecast_cloudcover" REAL, "t12forecast_cloudcover_ui" TEXT, "t12forecast_dewpoint" REAL, "t12forecast_dewpoint_ui" TEXT, "t12forecast_humidity" REAL, "t12forecast_humidity_ui" TEXT, "t12forecast_iconurl" TEXT, "t12forecast_precipintensity" REAL, "t12forecast_precipprobability" REAL, "t12forecast_precipprobability_ui" TEXT, "t12forecast_temperaturemax" REAL, "t12forecast_temperaturemax_ui" TEXT, "t12forecast_temperaturemin" REAL, "t12forecast_temperaturemin_ui" TEXT, "t12forecast_weathersummary" TEXT, "t12forecast_weathertype" TEXT, "t12forecast_weathertype_clear_day" BOOL, "t12forecast_weathertype_clear_night" BOOL, "t12forecast_weathertype_cloudy" BOOL, "t12forecast_weathertype_fog" BOOL, "t12forecast_weathertype_partly_cloudy_day" BOOL, "t12forecast_weathertype_partly_cloudy_night" BOOL, "t12forecast_weathertype_rain" BOOL, "t12forecast_weathertype_sleet" BOOL, "t12forecast_weathertype_snow" BOOL, "t12forecast_weathertype_sun" BOOL, "t12forecast_weathertype_wind" BOOL, "t12forecast_windspeed" REAL, "t13forecast_calculatedprecip" REAL, "t13forecast_cloudcover" REAL, "t13forecast_cloudcover_ui" TEXT, "t13forecast_dewpoint" REAL, "t13forecast_dewpoint_ui" TEXT, "t13forecast_humidity" REAL, "t13forecast_humidity_ui" TEXT, "t13forecast_iconurl" TEXT, "t13forecast_precipintensity" REAL, "t13forecast_precipprobability" REAL, "t13forecast_precipprobability_ui" TEXT, "t13forecast_temperaturemax" REAL, "t13forecast_temperaturemax_ui" TEXT, "t13forecast_temperaturemin" REAL, "t13forecast_temperaturemin_ui" TEXT, "t13forecast_weathersummary" TEXT, "t13forecast_weathertype" TEXT, "t13forecast_weathertype_clear_day" BOOL, "t13forecast_weathertype_clear_night" BOOL, "t13forecast_weathertype_cloudy" BOOL, "t13forecast_weathertype_fog" BOOL, "t13forecast_weathertype_partly_cloudy_day" BOOL, "t13forecast_weathertype_partly_cloudy_night" BOOL, "t13forecast_weathertype_rain" BOOL, "t13forecast_weathertype_sleet" BOOL, "t13forecast_weathertype_snow" BOOL, "t13forecast_weathertype_sun" BOOL, "t13forecast_weathertype_wind" BOOL, "t13forecast_windspeed" REAL, "t1forecast_calculatedprecip" REAL, "t1forecast_cloudcover" REAL, "t1forecast_cloudcover_ui" TEXT, "t1forecast_dewpoint" REAL, "t1forecast_dewpoint_ui" TEXT, "t1forecast_humidity" REAL, "t1forecast_humidity_ui" TEXT, "t1forecast_iconurl" TEXT, "t1forecast_precipintensity" REAL, "t1forecast_precipprobability" REAL, "t1forecast_precipprobability_ui" TEXT, "t1forecast_temperaturemax" REAL, "t1forecast_temperaturemax_ui" TEXT, "t1forecast_temperaturemin" REAL, "t1forecast_temperaturemin_ui" TEXT, "t1forecast_weathersummary" TEXT, "t1forecast_weathertype" TEXT, "t1forecast_weathertype_clear_day" BOOL, "t1forecast_weathertype_clear_night" BOOL, "t1forecast_weathertype_cloudy" BOOL, "t1forecast_weathertype_fog" BOOL, "t1forecast_weathertype_partly_cloudy_day" BOOL, "t1forecast_weathertype_partly_cloudy_night" BOOL, "t1forecast_weathertype_rain" BOOL, "t1forecast_weathertype_sleet" BOOL, "t1forecast_weathertype_snow" BOOL, "t1forecast_weathertype_sun" BOOL, "t1forecast_weathertype_wind" BOOL, "t1forecast_windspeed" REAL, "t2forecast_calculatedprecip" REAL, "t2forecast_cloudcover" REAL, "t2forecast_cloudcover_ui" TEXT, "t2forecast_dewpoint" REAL, "t2forecast_dewpoint_ui" TEXT, "t2forecast_humidity" REAL, "t2forecast_humidity_ui" TEXT, "t2forecast_iconurl" TEXT, "t2forecast_precipintensity" REAL, "t2forecast_precipprobability" REAL, "t2forecast_precipprobability_ui" TEXT, "t2forecast_temperaturemax" REAL, "t2forecast_temperaturemax_ui" TEXT, "t2forecast_temperaturemin" REAL, "t2forecast_temperaturemin_ui" TEXT, "t2forecast_weathersummary" TEXT, "t2forecast_weathertype" TEXT, "t2forecast_weathertype_clear_day" BOOL, "t2forecast_weathertype_clear_night" BOOL, "t2forecast_weathertype_cloudy" BOOL, "t2forecast_weathertype_fog" BOOL, "t2forecast_weathertype_partly_cloudy_day" BOOL, "t2forecast_weathertype_partly_cloudy_night" BOOL, "t2forecast_weathertype_rain" BOOL, "t2forecast_weathertype_sleet" BOOL, "t2forecast_weathertype_snow" BOOL, "t2forecast_weathertype_sun" BOOL, "t2forecast_weathertype_wind" BOOL, "t2forecast_windspeed" REAL, "t3forecast_calculatedprecip" REAL, "t3forecast_cloudcover" REAL, "t3forecast_cloudcover_ui" TEXT, "t3forecast_dewpoint" REAL, "t3forecast_dewpoint_ui" TEXT, "t3forecast_humidity" REAL, "t3forecast_humidity_ui" TEXT, "t3forecast_iconurl" TEXT, "t3forecast_precipintensity" REAL, "t3forecast_precipprobability" REAL, "t3forecast_precipprobability_ui" TEXT, "t3forecast_temperaturemax" REAL, "t3forecast_temperaturemax_ui" TEXT, "t3forecast_temperaturemin" REAL, "t3forecast_temperaturemin_ui" TEXT, "t3forecast_weathersummary" TEXT, "t3forecast_weathertype" TEXT, "t3forecast_weathertype_clear_day" BOOL, "t3forecast_weathertype_clear_night" BOOL, "t3forecast_weathertype_cloudy" BOOL, "t3forecast_weathertype_fog" BOOL, "t3forecast_weathertype_partly_cloudy_day" BOOL, "t3forecast_weathertype_partly_cloudy_night" BOOL, "t3forecast_weathertype_rain" BOOL, "t3forecast_weathertype_sleet" BOOL, "t3forecast_weathertype_snow" BOOL, "t3forecast_weathertype_sun" BOOL, "t3forecast_weathertype_wind" BOOL, "t3forecast_windspeed" REAL, "t4forecast_calculatedprecip" REAL, "t4forecast_cloudcover" REAL, "t4forecast_cloudcover_ui" TEXT, "t4forecast_dewpoint" REAL, "t4forecast_dewpoint_ui" TEXT, "t4forecast_humidity" REAL, "t4forecast_humidity_ui" TEXT, "t4forecast_iconurl" TEXT, "t4forecast_precipintensity" REAL, "t4forecast_precipprobability" REAL, "t4forecast_precipprobability_ui" TEXT, "t4forecast_temperaturemax" REAL, "t4forecast_temperaturemax_ui" TEXT, "t4forecast_temperaturemin" REAL, "t4forecast_temperaturemin_ui" TEXT, "t4forecast_weathersummary" TEXT, "t4forecast_weathertype" TEXT, "t4forecast_weathertype_clear_day" BOOL, "t4forecast_weathertype_clear_night" BOOL, "t4forecast_weathertype_cloudy" BOOL, "t4forecast_weathertype_fog" BOOL, "t4forecast_weathertype_partly_cloudy_day" BOOL, "t4forecast_weathertype_partly_cloudy_night" BOOL, "t4forecast_weathertype_rain" BOOL, "t4forecast_weathertype_sleet" BOOL, "t4forecast_weathertype_snow" BOOL, "t4forecast_weathertype_sun" BOOL, "t4forecast_weathertype_wind" BOOL, "t4forecast_windspeed" REAL, "t5forecast_calculatedprecip" REAL, "t5forecast_cloudcover" REAL, "t5forecast_cloudcover_ui" TEXT, "t5forecast_dewpoint" REAL, "t5forecast_dewpoint_ui" TEXT, "t5forecast_humidity" REAL, "t5forecast_humidity_ui" TEXT, "t5forecast_iconurl" TEXT, "t5forecast_precipintensity" REAL, "t5forecast_precipprobability" REAL, "t5forecast_precipprobability_ui" TEXT, "t5forecast_temperaturemax" REAL, "t5forecast_temperaturemax_ui" TEXT, "t5forecast_temperaturemin" REAL, "t5forecast_temperaturemin_ui" TEXT, "t5forecast_weathersummary" TEXT, "t5forecast_weathertype" TEXT, "t5forecast_weathertype_clear_day" BOOL, "t5forecast_weathertype_clear_night" BOOL, "t5forecast_weathertype_cloudy" BOOL, "t5forecast_weathertype_fog" BOOL, "t5forecast_weathertype_partly_cloudy_day" BOOL, "t5forecast_weathertype_partly_cloudy_night" BOOL, "t5forecast_weathertype_rain" BOOL, "t5forecast_weathertype_sleet" BOOL, "t5forecast_weathertype_snow" BOOL, "t5forecast_weathertype_sun" BOOL, "t5forecast_weathertype_wind" BOOL, "t5forecast_windspeed" REAL, "t6forecast_calculatedprecip" REAL, "t6forecast_cloudcover" REAL, "t6forecast_cloudcover_ui" TEXT, "t6forecast_dewpoint" REAL, "t6forecast_dewpoint_ui" TEXT, "t6forecast_humidity" REAL, "t6forecast_humidity_ui" TEXT, "t6forecast_iconurl" TEXT, "t6forecast_precipintensity" REAL, "t6forecast_precipprobability" REAL, "t6forecast_precipprobability_ui" TEXT, "t6forecast_temperaturemax" REAL, "t6forecast_temperaturemax_ui" TEXT, "t6forecast_temperaturemin" REAL, "t6forecast_temperaturemin_ui" TEXT, "t6forecast_weathersummary" TEXT, "t6forecast_weathertype" TEXT, "t6forecast_weathertype_clear_day" BOOL, "t6forecast_weathertype_clear_night" BOOL, "t6forecast_weathertype_cloudy" BOOL, "t6forecast_weathertype_fog" BOOL, "t6forecast_weathertype_partly_cloudy_day" BOOL, "t6forecast_weathertype_partly_cloudy_night" BOOL, "t6forecast_weathertype_rain" BOOL, "t6forecast_weathertype_sleet" BOOL, "t6forecast_weathertype_snow" BOOL, "t6forecast_weathertype_sun" BOOL, "t6forecast_weathertype_wind" BOOL, "t6forecast_windspeed" REAL, "t7forecast_calculatedprecip" REAL, "t7forecast_cloudcover" REAL, "t7forecast_cloudcover_ui" TEXT, "t7forecast_dewpoint" REAL, "t7forecast_dewpoint_ui" TEXT, "t7forecast_humidity" REAL, "t7forecast_humidity_ui" TEXT, "t7forecast_iconurl" TEXT, "t7forecast_precipintensity" REAL, "t7forecast_precipprobability" REAL, "t7forecast_precipprobability_ui" TEXT, "t7forecast_temperaturemax" REAL, "t7forecast_temperaturemax_ui" TEXT, "t7forecast_temperaturemin" REAL, "t7forecast_temperaturemin_ui" TEXT, "t7forecast_weathersummary" TEXT, "t7forecast_weathertype" TEXT, "t7forecast_weathertype_clear_day" BOOL, "t7forecast_weathertype_clear_night" BOOL, "t7forecast_weathertype_cloudy" BOOL, "t7forecast_weathertype_fog" BOOL, "t7forecast_weathertype_partly_cloudy_day" BOOL, "t7forecast_weathertype_partly_cloudy_night" BOOL, "t7forecast_weathertype_rain" BOOL, "t7forecast_weathertype_sleet" BOOL, "t7forecast_weathertype_snow" BOOL, "t7forecast_weathertype_sun" BOOL, "t7forecast_weathertype_wind" BOOL, "t7forecast_windspeed" REAL, "t8forecast_calculatedprecip" REAL, "t8forecast_cloudcover" REAL, "t8forecast_cloudcover_ui" TEXT, "t8forecast_dewpoint" REAL, "t8forecast_dewpoint_ui" TEXT, "t8forecast_humidity" REAL, "t8forecast_humidity_ui" TEXT, "t8forecast_iconurl" TEXT, "t8forecast_precipintensity" REAL, "t8forecast_precipprobability" REAL, "t8forecast_precipprobability_ui" TEXT, "t8forecast_temperaturemax" REAL, "t8forecast_temperaturemax_ui" TEXT, "t8forecast_temperaturemin" REAL, "t8forecast_temperaturemin_ui" TEXT, "t8forecast_weathersummary" TEXT, "t8forecast_weathertype" TEXT, "t8forecast_weathertype_clear_day" BOOL, "t8forecast_weathertype_clear_night" BOOL, "t8forecast_weathertype_cloudy" BOOL, "t8forecast_weathertype_fog" BOOL, "t8forecast_weathertype_partly_cloudy_day" BOOL, "t8forecast_weathertype_partly_cloudy_night" BOOL, "t8forecast_weathertype_rain" BOOL, "t8forecast_weathertype_sleet" BOOL, "t8forecast_weathertype_snow" BOOL, "t8forecast_weathertype_sun" BOOL, "t8forecast_weathertype_wind" BOOL, "t8forecast_windspeed" REAL, "t9forecast_calculatedprecip" REAL, "t9forecast_cloudcover" REAL, "t9forecast_cloudcover_ui" TEXT, "t9forecast_dewpoint" REAL, "t9forecast_dewpoint_ui" TEXT, "t9forecast_humidity" REAL, "t9forecast_humidity_ui" TEXT, "t9forecast_iconurl" TEXT, "t9forecast_precipintensity" REAL, "t9forecast_precipprobability" REAL, "t9forecast_precipprobability_ui" TEXT, "t9forecast_temperaturemax" REAL, "t9forecast_temperaturemax_ui" TEXT, "t9forecast_temperaturemin" REAL, "t9forecast_temperaturemin_ui" TEXT, "t9forecast_weathersummary" TEXT, "t9forecast_weathertype" TEXT, "t9forecast_weathertype_clear_day" BOOL, "t9forecast_weathertype_clear_night" BOOL, "t9forecast_weathertype_cloudy" BOOL, "t9forecast_weathertype_fog" BOOL, "t9forecast_weathertype_partly_cloudy_day" BOOL, "t9forecast_weathertype_partly_cloudy_night" BOOL, "t9forecast_weathertype_rain" BOOL, "t9forecast_weathertype_sleet" BOOL, "t9forecast_weathertype_snow" BOOL, "t9forecast_weathertype_sun" BOOL, "t9forecast_weathertype_wind" BOOL, "t9forecast_windspeed" REAL, "timezone" TEXT, "utcoffset" INTEGER, "zone1" BOOL, "zone2" BOOL, "zone3" BOOL, "zone4" BOOL, "zone5" BOOL, "zone6" BOOL, "zone7" BOOL, "zone8" BOOL);
   SQL Logger Error                exception trying to insert row into table device_history_1790308249 ("Rachio Sprinkler") -- unable to modify table
   SQL Logger Error                no such table: device_history_1790308249
   SQL Logger Error                INSERT INTO device_history_1790308249 ("activeschedule", "activezone", "activezone_ui", "address", "current_calculatedprecip", "current_cloudcover", "current_cloudcover_ui", "current_currenttemperature", "current_currenttemperature_ui", "current_dewpoint", "current_dewpoint_ui", "current_humidity", "current_humidity_ui", "current_iconurl", "current_precipintensity", "current_precipprobability", "current_precipprobability_ui", "current_weathersummary", "current_weathertype", "current_weathertype_clear_day", "current_weathertype_clear_night", "current_weathertype_cloudy", "current_weathertype_fog", "current_weathertype_partly_cloudy_day", "current_weathertype_partly_cloudy_night", "current_weathertype_rain", "current_weathertype_sleet", "current_weathertype_snow", "current_weathertype_sun", "current_weathertype_wind", "current_windspeed", "elevation", "id", "instandbymode", "latitude", "longitude", "model", "name", "paused", "schedulemodetype", "serialnumber", "status", "t0forecast_calculatedprecip", "t0forecast_cloudcover", "t0forecast_cloudcover_ui", "t0forecast_dewpoint", "t0forecast_dewpoint_ui", "t0forecast_humidity", "t0forecast_humidity_ui", "t0forecast_iconurl", "t0forecast_precipintensity", "t0forecast_precipprobability", "t0forecast_precipprobability_ui", "t0forecast_temperaturemax", "t0forecast_temperaturemax_ui", "t0forecast_temperaturemin", "t0forecast_temperaturemin_ui", "t0forecast_weathersummary", "t0forecast_weathertype", "t0forecast_weathertype_clear_day", "t0forecast_weathertype_clear_night", "t0forecast_weathertype_cloudy", "t0forecast_weathertype_fog", "t0forecast_weathertype_partly_cloudy_day", "t0forecast_weathertype_partly_cloudy_night", "t0forecast_weathertype_rain", "t0forecast_weathertype_sleet", "t0forecast_weathertype_snow", "t0forecast_weathertype_sun", "t0forecast_weathertype_wind", "t0forecast_windspeed", "t10forecast_calculatedprecip", "t10forecast_cloudcover", "t10forecast_cloudcover_ui", "t10forecast_dewpoint", "t10forecast_dewpoint_ui", "t10forecast_humidity", "t10forecast_humidity_ui", "t10forecast_iconurl", "t10forecast_precipintensity", "t10forecast_precipprobability", "t10forecast_precipprobability_ui", "t10forecast_temperaturemax", "t10forecast_temperaturemax_ui", "t10forecast_temperaturemin", "t10forecast_temperaturemin_ui", "t10forecast_weathersummary", "t10forecast_weathertype", "t10forecast_weathertype_clear_day", "t10forecast_weathertype_clear_night", "t10forecast_weathertype_cloudy", "t10forecast_weathertype_fog", "t10forecast_weathertype_partly_cloudy_day", "t10forecast_weathertype_partly_cloudy_night", "t10forecast_weathertype_rain", "t10forecast_weathertype_sleet", "t10forecast_weathertype_snow", "t10forecast_weathertype_sun", "t10forecast_weathertype_wind", "t10forecast_windspeed", "t11forecast_calculatedprecip", "t11forecast_cloudcover", "t11forecast_cloudcover_ui", "t11forecast_dewpoint", "t11forecast_dewpoint_ui", "t11forecast_humidity", "t11forecast_humidity_ui", "t11forecast_iconurl", "t11forecast_precipintensity", "t11forecast_precipprobability", "t11forecast_precipprobability_ui", "t11forecast_temperaturemax", "t11forecast_temperaturemax_ui", "t11forecast_temperaturemin", "t11forecast_temperaturemin_ui", "t11forecast_weathersummary", "t11forecast_weathertype", "t11forecast_weathertype_clear_day", "t11forecast_weathertype_clear_night", "t11forecast_weathertype_cloudy", "t11forecast_weathertype_fog", "t11forecast_weathertype_partly_cloudy_day", "t11forecast_weathertype_partly_cloudy_night", "t11forecast_weathertype_rain", "t11forecast_weathertype_sleet", "t11forecast_weathertype_snow", "t11forecast_weathertype_sun", "t11forecast_weathertype_wind", "t11forecast_windspeed", "t12forecast_calculatedprecip", "t12forecast_cloudcover", "t12forecast_cloudcover_ui", "t12forecast_dewpoint", "t12forecast_dewpoint_ui", "t12forecast_humidity", "t12forecast_humidity_ui", "t12forecast_iconurl", "t12forecast_precipintensity", "t12forecast_precipprobability", "t12forecast_precipprobability_ui", "t12forecast_temperaturemax", "t12forecast_temperaturemax_ui", "t12forecast_temperaturemin", "t12forecast_temperaturemin_ui", "t12forecast_weathersummary", "t12forecast_weathertype", "t12forecast_weathertype_clear_day", "t12forecast_weathertype_clear_night", "t12forecast_weathertype_cloudy", "t12forecast_weathertype_fog", "t12forecast_weathertype_partly_cloudy_day", "t12forecast_weathertype_partly_cloudy_night", "t12forecast_weathertype_rain", "t12forecast_weathertype_sleet", "t12forecast_weathertype_snow", "t12forecast_weathertype_sun", "t12forecast_weathertype_wind", "t12forecast_windspeed", "t13forecast_calculatedprecip", "t13forecast_cloudcover", "t13forecast_cloudcover_ui", "t13forecast_dewpoint", "t13forecast_dewpoint_ui", "t13forecast_humidity", "t13forecast_humidity_ui", "t13forecast_iconurl", "t13forecast_precipintensity", "t13forecast_precipprobability", "t13forecast_precipprobability_ui", "t13forecast_temperaturemax", "t13forecast_temperaturemax_ui", "t13forecast_temperaturemin", "t13forecast_temperaturemin_ui", "t13forecast_weathersummary", "t13forecast_weathertype", "t13forecast_weathertype_clear_day", "t13forecast_weathertype_clear_night", "t13forecast_weathertype_cloudy", "t13forecast_weathertype_fog", "t13forecast_weathertype_partly_cloudy_day", "t13forecast_weathertype_partly_cloudy_night", "t13forecast_weathertype_rain", "t13forecast_weathertype_sleet", "t13forecast_weathertype_snow", "t13forecast_weathertype_sun", "t13forecast_weathertype_wind", "t13forecast_windspeed", "t1forecast_calculatedprecip", "t1forecast_cloudcover", "t1forecast_cloudcover_ui", "t1forecast_dewpoint", "t1forecast_dewpoint_ui", "t1forecast_humidity", "t1forecast_humidity_ui", "t1forecast_iconurl", "t1forecast_precipintensity", "t1forecast_precipprobability", "t1forecast_precipprobability_ui", "t1forecast_temperaturemax", "t1forecast_temperaturemax_ui", "t1forecast_temperaturemin", "t1forecast_temperaturemin_ui", "t1forecast_weathersummary", "t1forecast_weathertype", "t1forecast_weathertype_clear_day", "t1forecast_weathertype_clear_night", "t1forecast_weathertype_cloudy", "t1forecast_weathertype_fog", "t1forecast_weathertype_partly_cloudy_day", "t1forecast_weathertype_partly_cloudy_night", "t1forecast_weathertype_rain", "t1forecast_weathertype_sleet", "t1forecast_weathertype_snow", "t1forecast_weathertype_sun", "t1forecast_weathertype_wind", "t1forecast_windspeed", "t2forecast_calculatedprecip", "t2forecast_cloudcover", "t2forecast_cloudcover_ui", "t2forecast_dewpoint", "t2forecast_dewpoint_ui", "t2forecast_humidity", "t2forecast_humidity_ui", "t2forecast_iconurl", "t2forecast_precipintensity", "t2forecast_precipprobability", "t2forecast_precipprobability_ui", "t2forecast_temperaturemax", "t2forecast_temperaturemax_ui", "t2forecast_temperaturemin", "t2forecast_temperaturemin_ui", "t2forecast_weathersummary", "t2forecast_weathertype", "t2forecast_weathertype_clear_day", "t2forecast_weathertype_clear_night", "t2forecast_weathertype_cloudy", "t2forecast_weathertype_fog", "t2forecast_weathertype_partly_cloudy_day", "t2forecast_weathertype_partly_cloudy_night", "t2forecast_weathertype_rain", "t2forecast_weathertype_sleet", "t2forecast_weathertype_snow", "t2forecast_weathertype_sun", "t2forecast_weathertype_wind", "t2forecast_windspeed", "t3forecast_calculatedprecip", "t3forecast_cloudcover", "t3forecast_cloudcover_ui", "t3forecast_dewpoint", "t3forecast_dewpoint_ui", "t3forecast_humidity", "t3forecast_humidity_ui", "t3forecast_iconurl", "t3forecast_precipintensity", "t3forecast_precipprobability", "t3forecast_precipprobability_ui", "t3forecast_temperaturemax", "t3forecast_temperaturemax_ui", "t3forecast_temperaturemin", "t3forecast_temperaturemin_ui", "t3forecast_weathersummary", "t3forecast_weathertype", "t3forecast_weathertype_clear_day", "t3forecast_weathertype_clear_night", "t3forecast_weathertype_cloudy", "t3forecast_weathertype_fog", "t3forecast_weathertype_partly_cloudy_day", "t3forecast_weathertype_partly_cloudy_night", "t3forecast_weathertype_rain", "t3forecast_weathertype_sleet", "t3forecast_weathertype_snow", "t3forecast_weathertype_sun", "t3forecast_weathertype_wind", "t3forecast_windspeed", "t4forecast_calculatedprecip", "t4forecast_cloudcover", "t4forecast_cloudcover_ui", "t4forecast_dewpoint", "t4forecast_dewpoint_ui", "t4forecast_humidity", "t4forecast_humidity_ui", "t4forecast_iconurl", "t4forecast_precipintensity", "t4forecast_precipprobability", "t4forecast_precipprobability_ui", "t4forecast_temperaturemax", "t4forecast_temperaturemax_ui", "t4forecast_temperaturemin", "t4forecast_temperaturemin_ui", "t4forecast_weathersummary", "t4forecast_weathertype", "t4forecast_weathertype_clear_day", "t4forecast_weathertype_clear_night", "t4forecast_weathertype_cloudy", "t4forecast_weathertype_fog", "t4forecast_weathertype_partly_cloudy_day", "t4forecast_weathertype_partly_cloudy_night", "t4forecast_weathertype_rain", "t4forecast_weathertype_sleet", "t4forecast_weathertype_snow", "t4forecast_weathertype_sun", "t4forecast_weathertype_wind", "t4forecast_windspeed", "t5forecast_calculatedprecip", "t5forecast_cloudcover", "t5forecast_cloudcover_ui", "t5forecast_dewpoint", "t5forecast_dewpoint_ui", "t5forecast_humidity", "t5forecast_humidity_ui", "t5forecast_iconurl", "t5forecast_precipintensity", "t5forecast_precipprobability", "t5forecast_precipprobability_ui", "t5forecast_temperaturemax", "t5forecast_temperaturemax_ui", "t5forecast_temperaturemin", "t5forecast_temperaturemin_ui", "t5forecast_weathersummary", "t5forecast_weathertype", "t5forecast_weathertype_clear_day", "t5forecast_weathertype_clear_night", "t5forecast_weathertype_cloudy", "t5forecast_weathertype_fog", "t5forecast_weathertype_partly_cloudy_day", "t5forecast_weathertype_partly_cloudy_night", "t5forecast_weathertype_rain", "t5forecast_weathertype_sleet", "t5forecast_weathertype_snow", "t5forecast_weathertype_sun", "t5forecast_weathertype_wind", "t5forecast_windspeed", "t6forecast_calculatedprecip", "t6forecast_cloudcover", "t6forecast_cloudcover_ui", "t6forecast_dewpoint", "t6forecast_dewpoint_ui", "t6forecast_humidity", "t6forecast_humidity_ui", "t6forecast_iconurl", "t6forecast_precipintensity", "t6forecast_precipprobability", "t6forecast_precipprobability_ui", "t6forecast_temperaturemax", "t6forecast_temperaturemax_ui", "t6forecast_temperaturemin", "t6forecast_temperaturemin_ui", "t6forecast_weathersummary", "t6forecast_weathertype", "t6forecast_weathertype_clear_day", "t6forecast_weathertype_clear_night", "t6forecast_weathertype_cloudy", "t6forecast_weathertype_fog", "t6forecast_weathertype_partly_cloudy_day", "t6forecast_weathertype_partly_cloudy_night", "t6forecast_weathertype_rain", "t6forecast_weathertype_sleet", "t6forecast_weathertype_snow", "t6forecast_weathertype_sun", "t6forecast_weathertype_wind", "t6forecast_windspeed", "t7forecast_calculatedprecip", "t7forecast_cloudcover", "t7forecast_cloudcover_ui", "t7forecast_dewpoint", "t7forecast_dewpoint_ui", "t7forecast_humidity", "t7forecast_humidity_ui", "t7forecast_iconurl", "t7forecast_precipintensity", "t7forecast_precipprobability", "t7forecast_precipprobability_ui", "t7forecast_temperaturemax", "t7forecast_temperaturemax_ui", "t7forecast_temperaturemin", "t7forecast_temperaturemin_ui", "t7forecast_weathersummary", "t7forecast_weathertype", "t7forecast_weathertype_clear_day", "t7forecast_weathertype_clear_night", "t7forecast_weathertype_cloudy", "t7forecast_weathertype_fog", "t7forecast_weathertype_partly_cloudy_day", "t7forecast_weathertype_partly_cloudy_night", "t7forecast_weathertype_rain", "t7forecast_weathertype_sleet", "t7forecast_weathertype_snow", "t7forecast_weathertype_sun", "t7forecast_weathertype_wind", "t7forecast_windspeed", "t8forecast_calculatedprecip", "t8forecast_cloudcover", "t8forecast_cloudcover_ui", "t8forecast_dewpoint", "t8forecast_dewpoint_ui", "t8forecast_humidity", "t8forecast_humidity_ui", "t8forecast_iconurl", "t8forecast_precipintensity", "t8forecast_precipprobability", "t8forecast_precipprobability_ui", "t8forecast_temperaturemax", "t8forecast_temperaturemax_ui", "t8forecast_temperaturemin", "t8forecast_temperaturemin_ui", "t8forecast_weathersummary", "t8forecast_weathertype", "t8forecast_weathertype_clear_day", "t8forecast_weathertype_clear_night", "t8forecast_weathertype_cloudy", "t8forecast_weathertype_fog", "t8forecast_weathertype_partly_cloudy_day", "t8forecast_weathertype_partly_cloudy_night", "t8forecast_weathertype_rain", "t8forecast_weathertype_sleet", "t8forecast_weathertype_snow", "t8forecast_weathertype_sun", "t8forecast_weathertype_wind", "t8forecast_windspeed", "t9forecast_calculatedprecip", "t9forecast_cloudcover", "t9forecast_cloudcover_ui", "t9forecast_dewpoint", "t9forecast_dewpoint_ui", "t9forecast_humidity", "t9forecast_humidity_ui", "t9forecast_iconurl", "t9forecast_precipintensity", "t9forecast_precipprobability", "t9forecast_precipprobability_ui", "t9forecast_temperaturemax", "t9forecast_temperaturemax_ui", "t9forecast_temperaturemin", "t9forecast_temperaturemin_ui", "t9forecast_weathersummary", "t9forecast_weathertype", "t9forecast_weathertype_clear_day", "t9forecast_weathertype_clear_night", "t9forecast_weathertype_cloudy", "t9forecast_weathertype_fog", "t9forecast_weathertype_partly_cloudy_day", "t9forecast_weathertype_partly_cloudy_night", "t9forecast_weathertype_rain", "t9forecast_weathertype_sleet", "t9forecast_weathertype_snow", "t9forecast_weathertype_sun", "t9forecast_weathertype_wind", "t9forecast_windspeed", "timezone", "utcoffset", "zone1", "zone2", "zone3", "zone4", "zone5", "zone6", "zone7", "zone8") 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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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, %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);
Attachments
2017-04-30_04-39-55.jpeg
2017-04-30_04-39-55.jpeg (26.01 KiB) Viewed 10020 times

_______
Norm

Posted on
Sun Apr 30, 2017 10:35 am
roquej offline
User avatar
Posts: 608
Joined: Jan 04, 2015
Location: South Florida, USA

Re: Rachio Plugin

Jay,

Thank you for the plugin! Small request, if possible. Could issuing a Rain Delay be possible via the plugin?

Currently, I have a script to issue a manual Rain Delay, when the weather conditions requires it (e.g, is actually raining, or rain is in the forecast for today and tomorrow). This is needed, as in South Florida, the weather changes from min-to-min and I have a Davis weather station that more realistically let's me determine what's going on than the Rachio built-in rain delay calculation.

Doing everything with the plugin will make things neater :-)

JP

Posted on
Sun Apr 30, 2017 11:22 am
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Rachio Plugin

norcoscia wrote:
Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all
Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")


That's an error with the SQL Logger plugin - it can't create the table for the new sprinkler device (maybe a permission issue?). Try restarting that plugin to see if the problem resolves itself.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Sun Apr 30, 2017 11:28 am
jay (support) offline
Site Admin
User avatar
Posts: 18199
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Rachio Plugin

roquej wrote:
Could issuing a Rain Delay be possible via the plugin?


That is possible (the API supports it). I don't have time to work on it now, but I'd be more than happy to accept a pull request on Github if someone else wants to add it. You can also add it as an enhancement request on Github and the next time someone is in there they may pick up that change as well.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Sun Apr 30, 2017 11:57 am
FlyingDiver offline
User avatar
Posts: 7189
Joined: Jun 07, 2014
Location: Southwest Florida, USA

Re: Rachio Plugin

jay (support) wrote:
norcoscia wrote:
Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all
Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")


That's an error with the SQL Logger plugin - it can't create the table for the new sprinkler device (maybe a permission issue?). Try restarting that plugin to see if the problem resolves itself.


The actual problem is that the Rachio plugin has a device field named "id":

Code: Select all
            <Field type="menu" id="id">
                <Label>Device:</Label>
                <List class="self" method="availableControllers"/>
            </Field>


Which causes the SQL logger plugin to barf because it's not protecting the column names. This previously came up in this thread:

viewtopic.php?f=216&t=17347&hilit=sql#p128763

The quick fix is to rename the field in the Rachio plugin. The long term fix is to change the SQL Logger plugin so that it guards all SQL column names based on device fields.

joe (aka FlyingDiver)
my plugins: http://forums.indigodomo.com/viewforum.php?f=177

Who is online

Users browsing this forum: No registered users and 3 guests

cron