| 16 Sep 2021 |
 bkil | 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 | My 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 | By the way, the page said maintenance mode: updating apcontact table., but that probably doesn't matter that much. | 18:45:30 |
 adb | mmm... 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 email | 19:45:36 |
 . | 💬 <fabrixxm> [xmpp] adb: the big difference is that you can change it... | 19:50:47 |
| . | 💬 <fabrixxm> [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 | 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 | 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 | After fixing up that query, it wont forward with a foreign constraint violation when upgrading fcontact. I gave up for now. | 21:29:39 |
| adb | In reply to @fikabot:matrix.org
💬 <fabrixxm> [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 | I 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 |
| adb | ah well, it is fine then | 23:17:09 |
| adb | having 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 important | 23:18:30 |
| adb | 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 | 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. 🤣 | 23:24:15 |
| 17 Sep 2021 |
| adb | 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 |
| adb | when Facebook wanted to kill email 🤔 | 01:47:47 |
| . | 💬 <tobiasd> [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 |
| adb | 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:29 |
| adb | * 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 |
| . | 💬 <lnxw37d4[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 |
|  Steve changed their profile picture. | 09:21:44 |
| Steve changed their profile picture. | 09:29:02 |
 RSS Bot [@bkil:grin.hu] | friendica:
Friendica Hackathon 2021 | 10:43:00 |
| . | 💬 <tobiasd> [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 |
| . | 💬 <tobiasd> [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 joined the room. | 11:03:17 |
|  dr-e joined the room. | 11:52:25 |
 bkilm | 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 |
| bkilm | Or this? https://f-droid.org/en/packages/org.mariotaku.twidere/ https://f-droid.org/en/packages/com.twidere.twiderex/ | 21:17:23 |
