| 21 Jan 2022 |
 mergan | I've been trying to contact other instances, but none of the posts seem to go through, and get stuck on the deferred worker queue | 12:55:21 |
| mergan | 👺 | 12:55:36 |
 bkil | Did you check the logs? | 13:04:50 |
| mergan | Just enabled them | 13:18:20 |
| 22 Jan 2022 |
 . | 💬 <m​ifritscher> [libera] hi | 18:52:59 |
| . | 💬 <m​ifritscher> [libera] despite the info on https://github.com/friendica/friendica/releases, you can not upgrade directly from 2020-03 to 2021-09. this way e.g. the vid column in the table item is missing (which was added in 2020.07) | 18:53:49 |
| . | 💬 <m​ifritscher> [libera] updateing to 2020.07 seems to work (dbstructure added the column (among others), postupdate seems to do things | 18:57:49 |
| bkil | Hello | 18:58:03 |
 heluecht | In reply to @fikabot:matrix.org
💬 <m​ifritscher> [libera] despite the info on https://github.com/friendica/friendica/releases, you can not upgrade directly from 2020-03 to 2021-09. this way e.g. the vid column in the table item is missing (which was added in 2020.07) In that area of time it is recommended to not skip versions. Later it will be less problematic. | 22:45:50 |
| 23 Jan 2022 |
| . | 💬 <m​ifritscher> [libera] ok, it was a rather bumpy ride, but now I'm on 2021-09 it seems^^ | 07:26:42 |
| bkil | 🎉 | 08:17:26 |
| . | 💬 <m​ifritscher> [libera] ah, the 2021-09 version doesn't have the item table in the database.sql, onle the item-uri. It seems that the post* tables are the new variant. Can I delete the old item* tables (but the item-uri)? | 10:14:12 |
 Hank | In reply to @heluecht:stratum0.org
In that area of time it is recommended to not skip versions. Later it will be less problematic. That's good to know. Being my server is less than a month old I haven't encountered that yet and I try to stay up to date on patches as well. Will be sure to be extra vigilant on it for sure make sure I don't accidentally jump two versions. | 13:38:27 |
 heluecht | In reply to @fikabot:matrix.org
💬 <m​ifritscher> [libera] ah, the 2021-09 version doesn't have the item table in the database.sql, onle the item-uri. It seems that the post* tables are the new variant. Can I delete the old item* tables (but the item-uri)? We are having a console command for it. | 13:49:12 |
| . | 💬 <i​j> [xmpp] heleucht, I get many duplicate entries in post-media table… any idea how to fix them? | 17:11:57 |
| bkil | Hank: I recommend you stay on (final) releases all the time (and only upgrade after a few weeks when it seems to be running for everyone else. Staying on git master can be a really bumpy ride. | 17:33:13 |
| Hank | Oh I have no intention of going off stable. I just wasn't sure what release tempo was | 17:40:22 |
| . | 💬 <i​j> [xmpp] select uri-id, count(uri-id) from post-media group by uri-id having count(uri-id)>1; | 17:56:11 |
| . | 💬 <i​j> [xmpp] 309025 rows in set (1.126 sec) | 17:56:11 |
| . | 💬 <i​j> [xmpp] … out of a total of 2216096 | 17:56:11 |
| . | 💬 <i​j> [xmpp] Heluecht bzw. heluecht2 ↑ | 17:56:12 |
| heluecht | In reply to @fikabot:matrix.org
💬 <i​j> [xmpp] heleucht, I get many duplicate entries in post-media table… any idea how to fix them? There shouldn't be any. The "post" tables are really robust. | 18:00:36 |
| heluecht | In reply to @hank:myportal.social
Oh I have no intention of going off stable. I just wasn't sure what release tempo was No risk no fun. | 18:01:07 |
| . | 💬 <i​j> [xmpp]
💬 > <@fikabot:matrix.org> 💬 [xmpp] heleucht, I get many duplicate entries in post-media table… any idea how to fix them?
There shouldn't be any. The "post" tables are really robust.
So, deleting entries from post-media should be ok? See posting in friendica-admins as well…
| 18:18:50 |
| heluecht | See my answer. Please don't perform any manual stuff with the database. Especially all the "post" tables are crafted in a way that they should be really stable and failsafe. | 18:32:28 |
| . | 💬 <m​ifritscher> [libera] @heleucht, ah, thanks - bin/console dbstructure drop (-e), right? | 19:17:24 |
| . | 💬 <m​ifritscher> [libera] needed to do it second times, the first time could not delete 2 tables because of foreign keys violations | 19:18:50 |
| . | 💬 <m​ifritscher> [libera] second= two^^ | 19:18:59 |
|  softmetz joined the room. | 22:22:29 |
| 24 Jan 2022 |
|  justthetruth_68 left the room. | 00:42:17 |
