Conversation

Notices

1. zunda ? nはおまけ :green_dango: (zundan@mastodon.zunda.ninja@mastodon.zunda.ninja)'s status on Friday, 18-Jan-2019 07:32:18 JST zunda ? nはおまけ :green_dango:

   どうしてアバターを取れてないアカウントがあるんだろう

   > SELECT COUNT(1) FROM accounts WHERE domain='mstdn.jp' AND avatar_updated_at IS NOT NULL;
   count
   -------
   618
   (1 row)

   > SELECT COUNT(1) FROM accounts WHERE domain='mstdn.jp' AND avatar_updated_at IS NULL;
   count
   -------
   3701
   (1 row)

   • zunda ? nはおまけ :green_dango: (zundan@mastodon.zunda.ninja@mastodon.zunda.ninja)'s status on Friday, 18-Jan-2019 07:34:33 JST zunda ? nはおまけ :green_dango:

     in reply to

     もう一度見に行ってみる

     $ tootctl accounts refresh --domain mstdn.jp
     Scheduled refreshment of 4319 accounts

   • zunda ? nはおまけ :green_dango: (zundan@mastodon.zunda.ninja@mastodon.zunda.ninja)'s status on Friday, 18-Jan-2019 08:56:34 JST zunda ? nはおまけ :green_dango:

     in reply to

     > SELECT COUNT(1) FROM accounts WHERE domain='mstdn.jp' AND avatar_updated_at IS NOT NULL;
     count
     -------
     618
     (1 row)

     変わらないねえ