SQL Logger Error

Posted on
Fri Apr 26, 2019 10:24 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: SQL Logger Error

Indigo's SQL Logger plugin doesn't have that granular control over what it logs, so skipping that device isn't possible.

It looks like that plugin is trying to update the device state doorbellonoffstate to be of type boolean, but your postgresql server has it as an integer. Can you try modifying the table manually yourself? The problem might be that there are integers in the table so the database is refusing to make the change. If you don't mind losing the data you could dump the postgresql database and let Indigo re-create it. If the plugin creates it though with an integer type then again tries to change it to a boolean then the error might just happen again. In that case the plugin needs to be tweaked to be consistent on how it treats that device state.

Image

Posted on
Fri Apr 26, 2019 2:48 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Logger Error

You can also just delete THAT devices instead of deleting the whole dB. Then recreate the device - it will create a new table for that device.


Sent from my iPhone using Tapatalk

Posted on
Fri Apr 26, 2019 3:33 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL Logger Error

In indigo delete device. Then recreate it



Sent from my iPhone using Tapatalk

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest