Grayed-out UI item in Utility Sensors Topic is solved

[philchillbill]

Just noticed something I've never seen before, a dark/grayish UI entry for one of my sensors:



Any idea what causes it?

[waaren]

Just noticed something I've never seen before, a dark/grayish UI entry for one of my sensors:

Is this on the default theme?

[philchillbill]

Just noticed something I've never seen before, a dark/grayish UI entry for one of my sensors:

Is this on the default theme?

Yes

[MikeyMan]

Hi all,

Just noticed today; one of the sensors being greyed out:

Naamloos3.png (32 KiB) Viewed 2751 times

It is working; didn't see it before. What could this be?

Br,
Michael

[MikeyMan]

Anyone got any clue what causes this?

[JohnOosterlaken]

I have the same "issue" also with the water meter.

[JohnOosterlaken]

if fixed it by recreating the item via the GUI and not using a url.
it seems that this way the hardware type is not unknown anymore.

[MikeyMan]

if fixed it by recreating the item via the GUI and not using a url.
it seems that this way the hardware type is not unknown anymore.

Doesnt that screw up the history?

[free_nsc]

Go into Hardware -> select relevant item and check off Enabled tick box ☑ then click update

[MikeyMan]

Its not under hadeware i'm afraid.

[waaren]

Its not under hadeware i'm afraid.

In domoticz terms a device object is connected to a hardware object.
If the hardware object is disabled (look at the hardware tab of your GU) and the hardware is one of the Python plugins, the device object tiles connected to that hardware object are greyed out in the switches-, weather, utility or temperature tab.

[MikeyMan]

Hmm... Strange... I recall it's always been the same, just not greyed out:

2021-01-25 10_52_48-Window.png (68.24 KiB) Viewed 2621 times

I dont think i ever had any hardware attached... And it is working as it should...

Very weird...

[waaren]

I dont think i ever had any hardware attached... And it is working as it should...

It should not be possible to create a device without a 'parent' hardware without entering it directly in the database using an external program.
Also: devices are removed from the system when the 'parent' hardware is deleted in domoticz.

I can only guess what's happened but assume that some time in the past the hardware that this device was connected to was removed with an external program or something else in the database happened causing the connection between your device and the 'parent' to got lost.

I don't see any direct issue for the state of the system other then the greyed out tile but to be sure I would reconnect it to one of your hardware objects.

To identify all devices without a 'parent' hardware and to show all hardware objects can you please do

Code: Select all

dzDir=/home/pi/domoticz # change to your domoticz dir
sudo sqlite3 --header $dzDir/domoticz.db "SELECT Name, Id , HardwareID FROM DeviceStatus WHERE HardwareID NOT IN (SELECT ID FROM Hardware)"
sudo sqlite3 --header $dzDir/domoticz.db "SELECT Id, Enabled, Type, Name FROM Hardware"

[MikeyMan]

Followed this guide:

https://ehoco.nl/watermeter-uitlezen-in ... on-script/

Dont see any hardware created here if i'm correct. So maybe the guide is not good

[waaren]

Followed https://ehoco.nl/watermeter-uitlezen-in ... on-script/
Dont see any hardware created here if i'm correct. So maybe the guide is not good

The guide is not complete.

in the line http: //192.168.2.152:8080/json.htm?type=createvirtualsensor&idx=29&sensorname=Water&sensortype=113 ,
29 is the hardware ID. You should change that number to the ID of one of your hardware objects and preferable your "Dummy (Does nothing, use for virtual switches)" hardware as it shown on the hardware tab.

[MikeyMan]

Followed https://ehoco.nl/watermeter-uitlezen-in ... on-script/
Dont see any hardware created here if i'm correct. So maybe the guide is not good

The guide is not complete.

in the line http: //192.168.2.152:8080/json.htm?type=createvirtualsensor&idx=29&sensorname=Water&sensortype=113 ,
29 is the hardware ID. You should change that number to the ID of one of your hardware objects and preferable your "Dummy (Does nothing, use for virtual switches)" hardware as it shown on the hardware tab.

Can i run that now still? Or will that mess up the history?

[waaren]

Can i run that now still? Or will that mess up the history?

No don't do that. Can you execute the sqlite3 commands I posted earlier? With that information I can advise you how to solve it.

[MikeyMan]

Can i run that now still? Or will that mess up the history?

No don't do that. Can you execute the sqlite3 commands I posted earlier? With that information I can advise you how to solve it.

Sure!

Code: Select all

sudo sqlite3 --header $dzDir/domoticz.db "SELECT Name, Id , HardwareID FROM DeviceStatus WHERE HardwareID NOT IN (SELECT ID FROM Hardware)"
Name|ID|HardwareID
Water|43|29

Code: Select all

pi@raspberrypi:~ $ sudo sqlite3 --header $dzDir/domoticz.db "SELECT Id, Enabled, Type, Name FROM Hardware"
ID|Enabled|Type|Name
1|1|67|Domoticz Internal
2|1|4|Slimme Meter
3|1|75|Evohome
5|1|64|Zonnepanelen
6|1|15|Somfy Alarm
9|1|78|Weer
10|1|15|Graaddagen
11|1|15|Tempsensoren
13|1|94|Shelly
14|1|15|Backup
19|1|21|Zwave

[waaren]

Code: Select all

sudo sqlite3 --header $dzDir/domoticz.db "SELECT Name, Id , HardwareID FROM DeviceStatus WHERE HardwareID NOT IN (SELECT ID FROM Hardware)"
Name|ID|HardwareID
Water|43|29


sudo sqlite3 --header $dzDir/domoticz.db "SELECT Id, Enabled, Type, Name FROM Hardware"
ID|Enabled|Type|Name
1|1|67|Domoticz Internal

OK. You can do

Code: Select all

sudo service domoticz stop
dzDir=/home/pi/domoticz # change to your domoticz dir
sudo cp $dzDir/domoticz.db domoticz.db_keep # just to be sure

sudo sqlite3 $dzDir/domoticz.db "UPDATE DeviceStatus SET HardwareID = 1 WHERE ID = 43"
sudo service domoticz start

Check if OK.

[MikeyMan]

That fixed it!

2021-01-25 15_35_01-Window.png (67.36 KiB) Viewed 2593 times

Is that a reserved hardware ID? The internal one?

Thanks