How to remove a helper without entity_id?

I have previously created 2 helpers to calculate consumed power but later on the device is removed but I did not remove the 2 helpers before removing the device. Now the 2 hepers does not have a entity_id and I can’t find anywhere to remove them. Can anyone advise how I can remove these 2 helpers?

Thanks.

Can you select them for deletion here: Settings → Devices & Services → Entities (tab at top of page)?

1 Like

they don’t exist under “Devices & Services” when I try to search them:

What does the pop-up card look like when you click on the missing helper?

1 Like

It shows the option as if it’s a functional helper:

and after clicking “Submit”

What about if you go to Settings → Devices & Services → Integrations is there a Riemann Sum / Integration card that shows there?

If so click the card.

1 Like

No it’s not there. I remember it was there when the 2 helpers were working.

I have created another “test” helper using the Riemann sum integral sensor, however the Riemann Sum / Integration card is still not under “Settings → Devices & Services → Integrations”

Hmm. Ok. I don’t use the UI to set up Riemann Sum helpers I use YAML, buy it looks to me like you found an issue. Could you please open a new issue here:

1 Like

How did you create the helper?

1 Like

Ha good question. I was assuming via the UI.

via UI under Helpers → Create Helper

yes, it was indeed via UI : (

Yeah ok. If it was YAML you could have edited/deleted the YAML.

There is a method for fixing this by editing the files in /config/.storage but unless you know what you are doing it has the potential to make things a lot worse. These files are not supposed to be user editable.

Best to open a new issue.

1 Like

are there multiple files to be edited?

I can raise the issue but happy to be adventurous as well to get rid of them and I can make backup of the files before I do that. In fact I did try to remove 2 entries in core_entity_registry but that doesn’t change anything… and then I installed Spook but it didn’t detect the issue as well so I’m asking for help here.

I have removed the 2 entries in core.config_entries as well and they are now gone.

2 Likes

This is really a problem.

I have the same problem with several helpers (groups of lights), they don’t receive an ID when created with UI, they don’t appear as entities and they can’t be used or deleted.

The problem was resolved by reloading the page.

I have the same problem. The helpers are named “unnamed statistics”. Reloading the page, rebooting etc. didn’t solve the problem. I have even created a new helper and made sure the unique id was entered. It again ended up in “unnamed statistics”, not having a unique id. If someone can tell the SQL queries to fix it, I’m ready to take the risk.