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
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!