kw123 wrote:@johnpolasek , have added back the closestRPItext, but realized it is now text and not Text..
hope that's not a problem.
Karl
Unfortunately that is THE problem; I've scrubbed all MY actions and triggers, but I'm still getting
Dec 30, 2018, 8:17:15 AM
Error device "Johns XY" state key closestRPIText not defined
Error device "Johns XY" state key closestRPIText not defined
Error device "Jeffs Keys2" state key closestRPIText not defined
Error device "Jeffs Keys2" state key closestRPIText not defined
but now I'm also getting occasional
SQL Logger Error exception trying to insert row into table variable_history_1858841481 ("iBeacon_With_Status_Change")
SQL Logger Error ERROR: column "closestrpitext" of relation "device_history_1762882528" does not exist at character 569
SQL Logger Error INSERT INTO variable_history_1858841481 (value) VALUES (%s);
which means that it's somewhere else... Is it possible that it's in the PostGres SQL table for the the existing beacons? And if it is, will I have to delete them and rebuild all the triggers I have in place?