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"]

[matt (support)]

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.

[matt (support)]

Indigo 7.5 is now available and includes this bug fix.