Search found 6 matches
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...