!BNMPbgPACTjCnwCtJb:grin.hu

Friendica, the social network

102 Members
communications app for web & mobiles https://friendi.ca https://github.com/friendica/friendica/tags - directory: https://dir.friendica.social Bridged to #friendica on Libera.chat IRC and forum.friendi.ca on XMPP. IRC log by guagua https://gnusociarg.nsupdate.info/2021/%23friendica/. Federate over ActivityPub (Mastodon, Pleroma, etc), Diaspora. Post to Tumblr, Wordpress. Dozens of addons like RSS and email. Install on VPS or shared PHP&MySQL hosting17 Servers

Load older messages


SenderMessageTime
16 Sep 2021
@bkil:grin.hubkil It throws PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uri-id' in 'group statement' in Database.php:530, coming from DBStructure.php(883). Is such an upgrade not supported? 18:12:28
@bkil:grin.hubkilMy install is not perfectly standard (invoking the update via my own frontendcron hack). If you say such an upgrade should work, I'll just reinstall. In this case, could you share some tips how to reinstall without my test followers blocking my instance? I guess I would only be able to restore some of the tables and that would be insufficient.18:15:17
@bkil:grin.hubkil By the way, the page said maintenance mode: updating apcontact table., but that probably doesn't matter that much. 18:45:30
@adbenitez:matrix.orgadbmmm... it is sad to see Friendica using the same dark patterns like Facebook, sending you an email when you received a comment but you waste the opportunity to send the comment right away and avoid people to go open Friendica after receiving this useless email19:45:36
@fikabot:matrix.org. 💬 <f​abrixxm> [xmpp] adb: the big difference is that you can change it... 19:50:47
@fikabot:matrix.org. 💬 <f​abrixxm> [xmpp] I won't call it "dark pattern", but "missing feature". Devs don't gain anything with you opening your instance. 19:52:06
@bkil:grin.hubkil I first upgraded to 21.07. But then got the same issue after going even between db structure 1424 -> 1426. Error 1054 occurred during database update: Unknown column 'uri-id' in 'group statement' - Execution of database structure update 1426 failed with error: Errors encountered performing database changes: ALTER TABLE temp-apcontactADDuri-idint unsigned COMMENT 'Id of the item-uri table entry that contains the apcontact url', ADD UNIQUE INDEXuri-id (uri-id), ADD FOREIGN KEY (uri-id) REFERENCES item-uri (id) ON UPDATE RESTRICT ON DELETE CASCADE; 20:22:50
@bkil:grin.hubkil And indeed, after attempting to run each SQL statement individually, I arrived at the same issue. Somehow when it tries to fill the temporary table, it groups by the newly created field uri-id. 20:45:25
@bkil:grin.hubkil After fixing up that query, it wont forward with a foreign constraint violation when upgrading fcontact. I gave up for now. 21:29:39
@adbenitez:matrix.orgadb
In reply to @fikabot:matrix.org
💬 <f​abrixxm> [xmpp] I won't call it "dark pattern", but "missing feature". Devs don't gain anything with you opening your instance.
more reasons to avoid unnecessary load 😏 a nice feature indeed, I think mastodon does it
22:16:41
@bkil:grin.hubkilI suggested it in an issue last year and the creators weren't against it. It's all just a matter of human resources and priorities. We didn't envision many users utilizing this feature (most people just turn off email notifications everywhere), but if you have precise research that shows that this could lure in some fresh meat, we could reconsider.22:42:21
@adbenitez:matrix.orgadbah well, it is fine then23:17:09
@adbenitez:matrix.orgadbhaving that option will be a selling point over Facebook that I could use to recommend Friendica over Facebook here in Cuba where email is cheaper, but that is not that important23:18:30
@adbenitez:matrix.orgadb also there is Facebook Lite apks etc. while Friendica page will be too bloated/expensive probably so they will not stop using Facebook anyway (ignoring the "all my friends use Facebook" point) 23:19:55
@bkil:grin.hubkilAlso consider that some years ago (10?) even Facebook sent out notification emails that contained the comment text, but things change. Friendica even had Facebook integration and also supported parsing and ingesting such Facebook notification mails to keep in touch and bridge between the two systems. Maybe that was one reason why they stopped providing the text. 🤣23:24:15
17 Sep 2021
@adbenitez:matrix.orgadb
In reply to @bkil:grin.hu
Also consider that some years ago (10?) even Facebook sent out notification emails that contained the comment text, but things change. Friendica even had Facebook integration and also supported parsing and ingesting such Facebook notification mails to keep in touch and bridge between the two systems. Maybe that was one reason why they stopped providing the text. 🤣
I know, there were good times when you could even reply/write to Facebook users by email
01:46:53
@adbenitez:matrix.orgadbwhen Facebook wanted to kill email 🤔01:47:47
@fikabot:matrix.org. 💬 <t​obiasd> [xmpp] $somebody had worked at the feature to answer to notification mails directly, years back. $somebody left from one day to the other without any further notice and $nobody so far picked up the wish to have the possibility to reply to comments via mail... 05:39:54
@adbenitez:matrix.orgadbthat would be awesome tobiasd, but to reply to comments you first have to receive them in the email, which is not the case currently :(06:21:29
@adbenitez:matrix.orgadb* that would be awesome tobiasd, but to reply to comments you first have to receive them in the email, which is not the case currently :(06:21:39
@fikabot:matrix.org. 💬 <l​nxw37d4[m]> [libera] We should ask ourselves why. Why post contents are no longer included in the e-mail notification. There may be a good reason. 10:34:35
18 Sep 2021
@Dzsingisz:matrix.orgSteve changed their profile picture.09:21:44
@Dzsingisz:matrix.orgSteve changed their profile picture.09:29:02
@_neb_rssbot_=40bkil=3agrin.hu:matrix.orgRSS Bot [@bkil:grin.hu] friendica:
Friendica Hackathon 2021
10:43:00
@fikabot:matrix.org. 💬 <t​obiasd> [xmpp] You mean the regular email notifications for new comments? I do get those still with the content of the comments... Do you get them as plain text or as HTML mail? 12:57:33
@fikabot:matrix.org. 💬 <t​obiasd> [xmpp] I have opted to get them as plain text in the settings. And I let them encrypt with gpg, but I hope this is not the reason. Though might be a difference in the notification chain. 12:59:44
19 Sep 2021
@traccer:matrix.orgtraccer joined the room.11:03:17
@dr-e:matrix.orgdr-e joined the room.11:52:25
@bkil:matrix.orgbkilm adb: Do you think something like this could still work? https://www.haukepauke.de/2014/05/use-friendica-pidgin-ubuntu-debian-linux/ 21:15:36
@bkil:matrix.orgbkilmOr this? https://f-droid.org/en/packages/org.mariotaku.twidere/ https://f-droid.org/en/packages/com.twidere.twiderex/21:17:23

There are no newer messages yet.


Back to Room List