Page 1 of 1

Strange entry at not used devices

Posted: Monday 05 November 2018 17:17
by Vomera
Hi Everyone,

I just cleared the Unused devices at domoticz. But there is one entry I cannot delete. Is it possible to delete this ?
It changes the format of the table

Image

Link to the image https://i.imgur.com/u4mgvRH.png

Re: Strange entry at not used devices

Posted: Monday 05 November 2018 19:41
by SweetPants
Image is not readable

Re: Strange entry at not used devices

Posted: Monday 05 November 2018 20:01
by Vomera
I added a link in the first post, thanks to mention it :)

Re: Strange entry at not used devices

Posted: Monday 05 November 2018 20:09
by waaren
Vomera wrote: Monday 05 November 2018 17:17 I just cleared the Unused devices at domoticz. But there is one entry I cannot delete. Is it possible to delete this ?
from the CLI from within the directory with domoticz.db
make a copy of your domoticz.db
sudo sqlite3 domoticz.db
select * from deviceStatus;
identify ID of the garbage entry. If unique then
delete from deviceStatus where id=<garbage_id>;

Re: Strange entry at not used devices

Posted: Monday 05 November 2018 20:20
by Vomera
Check! going to test this tomorrow!

Re: Strange entry at not used devices

Posted: Tuesday 06 November 2018 9:16
by Vomera
wow nice! I did you steps and removed id 361 and the garbage is now gone. The table looks fine again an no strange symbols!