!BNMPbgPACTjCnwCtJb:grin.hu

Friendica, the social network

132 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 hosting24 Servers

Load older messages


SenderMessageTime
21 Jan 2022
@mergan:matrix.orgmerganI've been trying to contact other instances, but none of the posts seem to go through, and get stuck on the deferred worker queue12:55:21
@mergan:matrix.orgmergan👺12:55:36
@bkil:grin.hubkilDid you check the logs?13:04:50
@mergan:matrix.orgmerganJust enabled them13:18:20
22 Jan 2022
@fikabot:matrix.org. 💬 <m​ifritscher> [libera] hi 18:52:59
@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) 18:53:49
@fikabot:matrix.org. 💬 <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:grin.hubkilHello18:58:03
@heluecht:stratum0.orgheluecht
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
@fikabot:matrix.org. 💬 <m​ifritscher> [libera] ok, it was a rather bumpy ride, but now I'm on 2021-09 it seems^^ 07:26:42
@bkil:grin.hubkil🎉08:17:26
@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)? 10:14:12
@hank:myportal.socialHank
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:myportal.socialheluecht
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
@fikabot:matrix.org. 💬 <i​j> [xmpp] heleucht, I get many duplicate entries in post-media table… any idea how to fix them? 17:11:57
@bkil:grin.hubkilHank: 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:myportal.socialHankOh I have no intention of going off stable. I just wasn't sure what release tempo was17:40:22
@fikabot:matrix.org. 💬 <i​j> [xmpp] select uri-id, count(uri-id) from post-media group by uri-id having count(uri-id)>1; 17:56:11
@fikabot:matrix.org. 💬 <i​j> [xmpp] 309025 rows in set (1.126 sec) 17:56:11
@fikabot:matrix.org. 💬 <i​j> [xmpp] … out of a total of 2216096 17:56:11
@fikabot:matrix.org. 💬 <i​j> [xmpp] Heluecht bzw. heluecht2 ↑ 17:56:12
@heluecht:myportal.socialheluecht
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:myportal.socialheluecht
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
@fikabot:matrix.org. 💬 <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:myportal.socialheluechtSee 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
@fikabot:matrix.org. 💬 <m​ifritscher> [libera] @heleucht, ah, thanks - bin/console dbstructure drop (-e), right? 19:17:24
@fikabot:matrix.org. 💬 <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
@fikabot:matrix.org. 💬 <m​ifritscher> [libera] second= two^^ 19:18:59
@softmetz:fsfe.orgsoftmetz joined the room.22:22:29
24 Jan 2022
@justthetruth_68:matrix.orgjustthetruth_68 left the room.00:42:17

There are no newer messages yet.


Back to Room List