Fixed: ambiguous column names in tootctl search deploy
https://github.com/mastodon/mastodon/pull/18993/files
确实是有隐患,但我又不希望它更新
https://github.com/mastodon/mastodon/issues/18975
这是什么情况?🤔
2022-08-15 09:52:28.485 UTC [31] ERROR: column reference "id" is ambiguous at character 8
2022-08-15 09:52:28.485 UTC [31] STATEMENT: SELECT id, coalesce(reblog_of_id, id) as status_id FROM "statuses" LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id" WHERE "statuses"."deleted_at" IS NULL AND ("accounts"."actor_type" NOT IN ($1, $2) AND "statuses"."local" = $3 OR "statuses"."uri" IS NULL) ORDER BY "statuses"."id" ASC LIMIT $4
研究了一下除了一个有一个clean_remote_files的worker可以强制清理所有外站缓存,应该是没有设置其他方式。我想可以加个worker,定期把早前缓存的外站文件转成直链形式 (isLink=TRUE
?),然后会调用image proxy?
Chinese 🇨🇳 / Dictatorial Admin / Mastodon Code Contributor / 摸鱼技术布道师
Steam: https://steamcommunity.com/id/MashiroBest
Epic: https://store.epicgames.com/en-US/u/d211c824cbd94aaeba898db6bb823ff7
原批交流群:966322309