Search found 6 matches

by palkor
Sunday 25 October 2020 19:30
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

Re: lastUpdate returns wrong value

Yes, I changed device name at the time when you suggested that domoticz might be looking at another database. I changed it via web page and this change was reflected in the db. In my previous post the same new name (GarageGate) is seen in the db and the domoticzData.lua file. It looks like I need to ...
by palkor
Sunday 25 October 2020 14:27
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

Re: lastUpdate returns wrong value

Here's what I got after setting log level to debug: -- Persistent Data local multiRefObjects = { } -- multiRefObjects local obj1 = { -- objects from 1 to 6, I've removed them [7] = { ["batteryLevel"] = 255; ["timedOut"] = true; ["changed"] = false; ["switchTypeValue"] = 2; ["deviceType"] = "Light ...
by palkor
Saturday 24 October 2020 21:29
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

Re: lastUpdate returns wrong value

sudo sqlite3 domoticz.db 'SELECT name as Tablename ,SUM("pgsize")/4096 Size FROM "dbstat" WHERE name IN (SELECT name FROM "sqlite_master" WHERE type == "table" ) GROUP BY name HAVING Size > 10 ORDER BY size DESC;' LightingLog|22 pi@raspberrypi:~/domoticz $ sudo sqlite3 domoticz.db "SELECT Key ...
by palkor
Saturday 24 October 2020 19:58
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

Re: lastUpdate returns wrong value

Only one process. pi@raspberrypi:~/domoticz $ sudo ps -ef | grep domo root 455 1 12 Oct14 ? 1-06:56:19 /home/pi/domoticz/domoticz -daemon -www 8080 -sslwww 443 pi 20746 14286 2 19:28 pts/1 00:00:00 grep --color=auto domo pi@raspberrypi:~/domoticz $ I've tried to find another DB. Seems to be only the ...
by palkor
Saturday 24 October 2020 18:29
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

Re: lastUpdate returns wrong value

Thanks for instant reply, waaren! Testing with ID instead of name returned the same result. database as well as API contain valid values: sqlite3 domoticz.db "select name, id, lastUpdate from devicestatus where name is 'Brama' " Brama|11|2020-10-24 18:06:54 curl -s 'http://<domoticz-ip>:8080/json ...
by palkor
Saturday 24 October 2020 15:36
Forum: dzVents
Topic: lastUpdate returns wrong value
Replies: 11
Views: 620

lastUpdate returns wrong value

Hi, I'm trying to monitor if a device is dead. I've read forum and it seemed to be ease. I planned to use lastUpdate attribute to find out when the device reported its presence. However when I read lastUpdate in my script, it returns wrong value. My script: return { on = { timer = { 'every minute ...