SQL Logger errors on update

Posted on
Wed Jul 08, 2020 6:55 pm
rhanson offline
Posts: 162
Joined: Apr 30, 2013

SQL Logger errors on update

Anyone seeing this?

Code: Select all
SQL Logger Error                exception trying to insert row into table device_history_997902485 ("Tesla") -- unable to modify table
SQL Logger Error                ERROR:  value "1594234955050" is out of range for type integer at character 4335

SQL Logger Error                INSERT INTO device_history_ (sql statement)

Looks like there's a data type mismatch in the data returned by Tesla API vs device definition.
I'm using Postgres, not SQLite.

The value in the error corresponds to this state:
indigo.devices[997902485].states["gui_settings_timestamp"]

Posted on
Thu Jul 09, 2020 2:56 pm
matt (support) offline
Site Admin
User avatar
Posts: 20083
Joined: Jan 27, 2003
Location: Texas

Re: SQL Logger errors on update

This looks like a bug in the SQL Logger plugin. It was always setting integer columns to the type int, which is only 32 bit for PostgreSQL. Give this beta version of the SQL Logger plugin a try to see if it works better. Double-click the .zip file twice: once to unzip it, and again to install the plugin.

Image

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 0 guests