#Nextcloud
I had a recurring issue where my nextcloud news would stop updating because of duplicate hashes. My solution was to run the following sql query:
connect nextcloud;
delete FROM `oc_news_items` WHERE guid_hash IN ( SELECT guid_hash FROM `oc_news_items` GROUP BY feed_id, guid_hash HAVING count(*) > 1 );
The first time I ran it, it deleted a surprising number of posts, but I didn't have the same problem after that and my nextcloud news seems to be working well.
I had a recurring issue where my nextcloud news would stop updating because of duplicate hashes. My solution was to run the following sql query:
connect nextcloud;
delete FROM `oc_news_items` WHERE guid_hash IN ( SELECT guid_hash FROM `oc_news_items` GROUP BY feed_id, guid_hash HAVING count(*) > 1 );
The first time I ran it, it deleted a surprising number of posts, but I didn't have the same problem after that and my nextcloud news seems to be working well.
- replies
- 0
- announces
- 0
- likes
- 1