search

ZachBenz / RingForIndigo

Ring plugin for Indigo Home Automation Server from Indigo Domotics
GNU Lesser General Public License v3.0
0 stars 1 forks source link

EventID as integer type incompatible with SQL Logger Plugin #9

Open ZachBenz opened 4 years ago

ZachBenz commented 4 years ago

1.0.4 As reported on Indigo forum:

SQL Logger Error exception trying to insert row into table device_history_744129089 ("Doorbell - Front copy") -- unable to modify table
SQL Logger Error ERROR: value "6775891258314630184" is out of range for type integer at character 474

Looks like we're treating eventID as an integer, which doesn't work when also using SQL Logger Plugin.

ZachBenz commented 4 years ago

It's already a string (only battery_level is an integer). Weird...

ZachBenz commented 4 years ago

Have not experienced this issue on my development or production systems (which both have SQL Logger plugin enabled)