Top 50 Largest Uploads 脚本出错

错误
1

有时我使用 explorer 脚本来查找大型上传。

当我尝试运行查询时：

SELECT posts.id AS post_id,
    uploads.original_filename,
    ROUND(uploads.filesize / 1000000.0, 2) AS size_in_mb,
    uploads.extension,
    uploads.created_at,
    uploads.url
FROM post_uploads
JOIN uploads ON uploads.id = post_uploads.upload_id
JOIN posts ON posts.id = post_uploads.post_id
ORDER BY uploads.filesize DESC
LIMIT 50

我收到一条消息：

PG::UndefinedTable: ERROR:  relation "post_uploads" does not exist
LINE 13: FROM post_uploads
              ^

对于将来找到此主题的人来说，它与 Search attachments by storage name 相关。

2 个赞
2

是的。post_uploads 表已被弃用。我认为现在需要使用 uploads 和 upload_references 表？

感谢您的报告。:+1:

我认为这是更新后的版本，如果您需要的话 @Ivan_Rapekas：

SELECT posts.id AS post_id,
    uploads.original_filename,
    ROUND(uploads.filesize / 1000000.0, 2) AS size_in_mb,
    uploads.extension,
    uploads.created_at,
    uploads.url
FROM upload_references
JOIN uploads ON uploads.id = upload_references.upload_id
JOIN posts ON posts.id = upload_references.target_id AND upload_references.target_type = 'Post'
ORDER BY uploads.filesize DESC
LIMIT 50
3 个赞
4

这应该可以通过以下方式修复：:+1:

2 个赞
5

此主题已在 3 天后自动关闭。不再允许回复。