davinci wrote:I still have the problem. If I switch on off a Fibaro switch the database shows it is on, but Indigo shows it is off (which is true).
So there IS an issue.
$db = new SQLite3('indigo.sqlite');
$db->busyTimeout(5000);
$status = ($db->querySingle('SELECT value FROM variable_history_124430741 ORDER BY ts DESC LIMIT 1'));
$db = new SQLite3('indigo.sqlite');
$db->busyTimeout(5000);
$status = ($db->querySingle('SELECT value, ts FROM variable_history_124430741 ORDER BY ts DESC LIMIT 2'));
($db->querySingle('SELECT onoffstate FROM device_history_1094248805 ORDER BY ts DESC LIMIT 1'));
Users browsing this forum: No registered users and 3 guests