首先,非常感谢您的帮助 @Overgrow。
所有的头像、表情符号(甚至网站图片,如页眉等)都“存在”,但不可见。对于非头像内容,它们显示为损坏状态;对于头像,则显示为灰色占位符。有些人能够重新上传新的头像,这些新的头像可以正常显示。
我最初尝试运行命令时得到以下结果:
FATAL: 数据库系统处于恢复模式
所以……情况就是这样
(我经常遇到“断开连接”的问题,所以我怀疑 这与数据库有关?)
但在坚持尝试后,最终得到了以下结果:
User.find_by_username(‘Overgrow’).user_avatar
=> #<UserAvatar:0x000055702722d200
id: 4,
user_id: 3,
custom_upload_id: 20504,
gravatar_upload_id: 12240,
last_gravatar_download_attempt: Thu, 21 May 2020 10:16:55 UTC +00:00,
created_at: Sat, 30 May 2019 16:33:16 UTC +00:00,
updated_at: Thu, 21 May 2020 10:16:55 UTC +00:00>
(今天尝试重新上传一个新的头像,但不起作用)。
User.find_by_username(‘Overgrow’).uploaded_avatar
=> #<Upload:0x00005555cd911b58
id: 20504,
user_id: 3,
original_filename: "16_2.png.jpg",
filesize: 56220,
width: 360,
height: 360,
url: "/uploads/default/original/3X/6/3/63347a46c0ca945f53613722a73c233484d642c8.jpeg",
created_at: Thu, 15 Aug 2019 20:02:47 UTC +00:00,
updated_at: Thu, 15 Aug 2019 20:02:47 UTC +00:00,
sha1: "63347a46c0ca945f53613722a73c233484d642c8",
origin: nil,
retain_hours: nil,
extension: "jpeg",
thumbnail_width: 360,
thumbnail_height: 360,
etag: nil,
secure: false,
access_control_post_id: nil,
original_sha1: nil>
OptimizedImage.where(upload_id: 20504).where(version: 2)
=> [#<OptimizedImage:0x000056366a01c1a0
id: 95962,
sha1: "5a32b5cc3e6f5c58d88a3c92a23076980a8ce840",
extension: ".jpeg",
width: 200,
height: 200,
upload_id: 20504,
url: "/uploads/default/optimized/3X/6/3/63347a46c0ca945f53613722a73c233484d642c8_2_200x200.jpeg",
filesize: 28916,
etag: nil,
version: 2>,
#<OptimizedImage:0x000056366a0741e8
id: 95942,
sha1: "ee353c9e23511b471e1a59c1f71a2ded3e366b1e",
extension: ".jpeg",
width: 20,
height: 20,
upload_id: 20504,
url: "/uploads/default/optimized/3X/6/3/63347a46c0ca945f53613722a73c233484d642c8_2_20x20.jpeg",
filesize: 1270,
etag: nil,
version: 2>,
#<OptimizedImage:0x000056366a074120
id: 95943,
sha1: "944fa9fc542a79a5c50394c75022bf84ace297e5",
extension: ".jpeg",
width: 30,
height: 30,
upload_id: 20504,
url: "/uploads/default/optimized/3X/6/3/63347a46c0ca945f53613722a73c233484d642c8_2_30x30.jpeg",
filesize: 1952,
etag: nil,
version: 2>,
#<OptimizedImage:0x000056366a074058
id: 95944,
sha1: "983490e58bed58c971ffa44e440b02ce3ea72bba",
extension: ".jpeg",
width: 40,
height: 40,
upload_id: 20504,
url: "/uploads/default/optimized/3X/6/3/63347a46c0ca945f53613722a73c233484d642c8_2_40x40.jpeg",
filesize: 2695,
etag: nil,
version: 2>,
#<OptimizedImage:0x000056366a07bf60
所以,从表面上看,图片确实存在,但无法显示。只能看到默认的灰色头像占位符。