"Feed with this URL exists"

[fire-burner]

Checklist

Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)

• [x ] I have read the CONTRIBUTING.md and followed the provided tips
• [x ] I accept that the issue will be closed without comment if I do not check here
• [x ] I accept that the issue will be closed without comment if I do not fill out all items in the issue template.

Explain the Problem

I had recently set up the News app. One of the feeds suddenly had disappeared (I can't eliminate, that I have accidentally deleted it). However, since I am not able to re add the Feed (https://forum.openwrt.org/c/announcements/14.rss) and this error is shown: "Feed with this URL exists"
This is very similar to #1412
It has been more than 2 weeks now and the Cron job for News has run multiple times.
I also tried the mentioned occ news:updater:before-update and had restarted the instance.

Steps to Reproduce

I couldn't reproduce it by adding and deleting a test feed, because I was able to re add the feed.
Maybe the respective feed is an invisible ghost? But I can't see it neither in the web app, nor the Android app.

System Information

• News app version: 24.0.0
• Nextcloud version: 27.1.1
• Cron type: system cron
• PHP version: 8.2.7
• Database and version: mariadb 10.11.3
• Browser and version: Firefox 115.3.0 ESR
• OS and version: Debian 12 (stable/bookworm)

Contents of nextcloud/data/nextcloud.log

The log does not show anything for the minute when I tried to re add that feed (debugging was enabled beforehand)

Contents of Browser Error Console

Read http://ggnome.com/wiki/Using_The_Browser_Error_Console if you are unsure what to put here

$ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own. [globals.js:59:27](webpack:///nextcloud/core/src/globals.js)
XHRPOST
https://mydomain/apps/news/feeds
[HTTP/1.1 409 Conflict 1456ms]

$ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own. [globals.js:59:27](webpack:///nextcloud/core/src/globals.js)
TypeError: can't convert undefined to object
    publishAll Publisher.js:34
    createFeed NavigationController.js:216
    Angular 13
        c
        $digest
        $apply
        g
        g
        onload
        get
        g
        e
        c
        $digest
        $apply
        compile
    jQuery 2
        dispatch
        handle
 Possibly unhandled rejection: {} [angular.min.js:129](https://mydomain/apps/news/js/build/angular.min.js)
    Angular 15
        i
        get
        u
        $digest
        $apply
        g
        g
        onload
        (Async: EventHandlerNonNull)
    get
        g
        e
        c
        $digest
        $apply
        compile
    jQuery 2
        dispatch
        handle

[Grotax]

In the web and also the android app there is an option to only show unread items, if a feed has no items it won't be shown.

Check the settings in the web app and if the feed appears then.

[fire-burner]

"Show all articles" is already checked in the web app.
And I can see other feeds, where there are no unread items.

[SMillerDev]

Did you try without adblock?

[fire-burner]

Yes, I tried with all extensions disabled.

[jip149]

I had the same problem. In the db, I saw that deleted_at field for the missing feed was null. I manually set it to 0 and it reappeared in the UI.

I have no idea what set the deleted_at field to null.

[fire-burner]

Would you be able to provide some steps on how to modify the db?
I am a noob when it comes to databases. Hence I was not yet able to access the db directly to see if I can modify/remove this entry.