Looks like on develop the rss feed contacts are gone. I noticed that just now. So, I think something in the last 24 hours has damaged the rss protocol.
I didn't try the URL directly. I don't have any RSS posts in my stream anymore. When I go to the contacts page and search for any known RSS contact I get no search result. And in the protocol widget the 'RSS/Atom' entry is gone - just like there is no RSS contact.
@Steffen K9 🐰 I don't know much about the internals of Friendica. Maybe @Michael Vogel can tell you more which SQL statement you have to run. Here I definitely have the widget and items from feeds and contacts. 😀
kaichen@libranet.de man, I was upset about 80, most of which are custom Google News Alerts and Kill-the-newsletter email to RSS. I did save some of the later in my LastPass so I guess that's something. Good luck to you. Hopefully the bug is just not showing them in the UI and not that it deleted them from the DB
I'm guessing unless you backed up your account regularly the answer is "not really" though your admin may have a database archieve somewhere, but not sure what the best thing to do is. I added a few RSS Feeds last night, they were added, but didn't populate with any content. This morning the content is there though
Question is are the contacts lost (deleted from database) or are they only not used/displayed. The second case would bring them back when the code is eventually fixed. The first case... Well... I would need to export them somehow from a database backup. 😔
@Steffen K9 🐰 I have checked all unkn here (you should, too) and found out that one is an RSS/ATOM feed (https://planet.gnu.org/atom.xml isn't detected as feed), an actual website (no federating instance), a parked domain and some unreachable websites.
@Steffen K9 🐰 Yes, same here. uid=0 and rel=2 for all of them. So we can exclude that they are deleted, just not shown for some reason. A few here have uid=1 because I created them for my account. Can you check SELECT * FROM `contact` WHERE `network`='feed' AND `uid` != 0? Also is the column deleted=0 or something else? I guess you should NOT touch that value and change it to 0. @Michael Vogel@Hypolite Petovan How can we fix this?
There are only a couple of newly added feed contacts that have a UID != 0. All other feed contacts have UID = 0. None is deleted, archived or blocked.
It really looks like the connection between the feed contacts and the users who followed them is lost. I could be wrong but I remember that @Michael Vogel had changed something about how we handle feed contacts in the past. It was something about to avoid duplicate contacts when e.g. 20 users added the same feed as contact. But my memory can be wrong. 😀
These are all feed contacts with UID != 0. All other feed contacts are stored with UID = 0.
MariaDB [friendica]> SELECT uid, url, created, rel, deleted, blocked, archive FROM `contact` WHERE `network`='feed' AND `uid` != 0;
+------+--------------------------------------------------------+---------------------+-----+---------+---------+---------+
| uid | url | created
... show more
There are only a couple of newly added feed contacts that have a UID != 0. All other feed contacts have UID = 0. None is deleted, archived or blocked.
It really looks like the connection between the feed contacts and the users who followed them is lost. I could be wrong but I remember that @Michael Vogel had changed something about how we handle feed contacts in the past. It was something about to avoid duplicate contacts when e.g. 20 users added the same feed as contact. But my memory can be wrong. 😀
These are all feed contacts with UID != 0. All other feed contacts are stored with UID = 0.
@Steffen K9 🐰@Ji Fu What I wanted to find out is that you have at least contacts with network=feed. So that error source is ruled out, having no RSS feed registered at all. The only one that is strange is the mass-unasignment where I have no idea about.
Ist der Quellkontakt noch da. Bei mir sind die weg, so dass die Bots nichts mehr ausliefern können. Ich bin noch nicht dazu gekommen, das Backup so weit zu untersuchen, ob ich die Kontakte reparieren oder re-importieren kann. Es scheint so zu sein, dass die noch existieren, aber die Verbindung zur User ID verloren haben.
Leider werden die fehlenden Posts seit dem nicht automatisch erneut import/exportiert. Ob das was geholfen hat, werden wir demnach wohl erst beim nächsten Beitrag in dem Blog sehen.
OK - was heißt das jetzt für die anderen x Bots? Bei meinen 5 macht es mir nichts aus, die Feeds neu einzugeben. Aber was ist mit den anderen Usern, die hier möglicherweise gar nicht mitlesen?
@Steffen K9 🐰 Habe soeben meine anderen Bots manuell nachgepflegt. Jetzt wird das Fediverse wieder mit den wichtigsten Meldungen via #RSS versorgt - wir sind also wieder auf dem Weg zur #Weltherrschaft.
Based on the screen shots and little English in your comment @Paula Gentle on Friendica I suspect this observation is a different issue based on a User account that can be easily viewed by anyone on the 'verse being updated via the contents of a Feed, rather than a "contact" of a user being an RSS feed that is more-or-less only viewable by the Friendica user that subscribed to the feed.
As an #american I don't know any other languague than #English since our #publicSschool system believes that doing so would show weakness to the world economy.
What I can do for users with lost RSS contacts: I can export them from a DB backup and create a CSV file with the URLs. This can be imported by the user via the import function in the user settings page. This is a lot of work. 😬 So, when you force me to do that I will do my best. ☺️
Steffen K9 🐰
•Steffen K9 🐰
•Eric Rothoff
•Steffen K9 🐰
•HEAD is now at 06698cc5f Test?
Ji Fu
•Roland Häder
•/contact?nets=feed? With latestdevelopcode, I have my RSS contacts there.Steffen K9 🐰
•Steffen K9 🐰
•Roland Häder
•Kai Lücke
•I have lost more than 300 contacts. 😱
Ji Fu
•Ji Fu
•Steffen K9 🐰
•The second case would bring them back when the code is eventually fixed. The first case... Well... I would need to export them somehow from a database backup. 😔
Roland Häder
•Which gives me:
Roland Häder
•unknhere (you should, too) and found out that one is an RSS/ATOM feed (https://planet.gnu.org/atom.xml isn't detected asfeed), an actual website (no federating instance), a parked domain and some unreachable websites.Steffen K9 🐰
•Steffen K9 🐰
•So, yeah. Feed contacts are still there. But these feed contacts have UID=0.. I'm still puzzled how the relationship to the actual users is made.
Roland Häder
•uid=0andrel=2for all of them. So we can exclude that they are deleted, just not shown for some reason. A few here haveuid=1because I created them for my account. Can you checkSELECT * FROM `contact` WHERE `network`='feed' AND `uid` != 0? Also is the columndeleted=0or something else? I guess you should NOT touch that value and change it to0. @Michael Vogel@Hypolite Petovan How can we fix this?Steffen K9 🐰
•It really looks like the connection between the feed contacts and the users who followed them is lost. I could be wrong but I remember that @Michael Vogel had changed something about how we handle feed contacts in the past. It was something about to avoid duplicate contacts when e.g. 20 users added the same feed as contact. But my memory can be wrong. 😀
These are all feed contacts with UID != 0. All other feed contacts are stored with UID = 0.
... show more
It really looks like the connection between the feed contacts and the users who followed them is lost. I could be wrong but I remember that @Michael Vogel had changed something about how we handle feed contacts in the past. It was something about to avoid duplicate contacts when e.g. 20 users added the same feed as contact. But my memory can be wrong. 😀
These are all feed contacts with UID != 0. All other feed contacts are stored with UID = 0.
Sorry in advance for destroying the theme with that code block. 😉
Steffen K9 🐰
•https://github.com/friendica/friendica/blob/develop/doc/database/db_user-contact.md
Ji Fu
•Steffen K9 🐰
•I ran this query on both DBs:
select uid, protocol from `user-contact` where protocol = 'feed';Current DB:
Only 18 rows! All are lately added - after users noticed that the feed contacts are gone.
Backup DB:
949 rows!
Steffen K9 🐰
•... WHERE `network`='feed' AND `uid` != 0;Current: 16
Backupr: 1301
Ji Fu
•Steffen K9 🐰
•Roland Häder
•network=feed. So that error source is ruled out, having no RSS feed registered at all. The only one that is strange is the mass-unasignment where I have no idea about.Ji Fu
•Ji Fu
•Paula Gentle on Friendica
•#RSS in #Friendica hangs for a week.
Steffen K9 🐰
•Ich bin noch nicht dazu gekommen, das Backup so weit zu untersuchen, ob ich die Kontakte reparieren oder re-importieren kann. Es scheint so zu sein, dass die noch existieren, aber die Verbindung zur User ID verloren haben.
Paula Gentle on Friendica
•Bei dem einen Bot ('Nordstadt-Blogger') aus dem Beispiel war der Kontakt tatsächlich verschwunden.
Ich habe ihn wie hier beschrieben erneut hinzugefügt:
https://wiki.friendi.ca/de/docs/bot
Leider werden die fehlenden Posts seit dem nicht automatisch erneut import/exportiert. Ob das was geholfen hat, werden wir demnach wohl erst beim nächsten Beitrag in dem Blog sehen.
Paula Gentle on Friendica
•Doch, werden doch auch nachträglich importiert:
https://libranet.de/display/0b6b25a8-c82841bb-915f2b3bdd63ab04
OK - was heißt das jetzt für die anderen x Bots? Bei meinen 5 macht es mir nichts aus, die Feeds neu einzugeben. Aber was ist mit den anderen Usern, die hier möglicherweise gar nicht mitlesen?
Paula Gentle on Friendica
•Habe soeben meine anderen Bots manuell nachgepflegt.
Jetzt wird das Fediverse wieder mit den wichtigsten Meldungen via #RSS versorgt - wir sind also wieder auf dem Weg zur #Weltherrschaft.
Ji Fu
•As an #american I don't know any other languague than #English since our #publicSschool system believes that doing so would show weakness to the world economy.
Steffen K9 🐰
•This is a lot of work. 😬 So, when you force me to do that I will do my best. ☺️
Ji Fu
•