Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Images in posts are not always fetched #119

Closed
JayVii opened this issue Jan 2, 2025 · 2 comments
Closed

Images in posts are not always fetched #119

JayVii opened this issue Jan 2, 2025 · 2 comments
Labels
bug Something isn't working

Comments

@JayVii
Copy link
Contributor

JayVii commented Jan 2, 2025

Since the newest version (2.4.3), I encountered numerous cases where images in posts are not displayed within ktistec. See for example this post, which in my instance looks like this:

Screenshot showing an "empty" post in ktistec

The HTML does not show any content either (div with classes extra & text):

Screenshot of the HTML object in ktistec

The logs do not show anything helpful right now, I just switched a few toggles to debug, maybe something helpful falls out of this soon.

This does not seem a user- or server-specific issues. Other posts by the same user do contain images.

I notice this behaviour in particular with posts that only contain an image, nothing else. Neither other text, not an ALT attribute to the image. This could be coincidence, because obviously a completely empty post stands out a lot more within my timeline than one with text where it is not completely obvious that an image is missing.

@JayVii
Copy link
Contributor Author

JayVii commented Jan 2, 2025

Update, I set some DEBUG flags and used the "fetch once" feature in an attempt to refresh the same post from above and reloaded the page afterwards. Here's the log:

2025-01-02T11:46:30.634349Z  DEBUG - database: Query [     1.976ms] -- INSERT OR REPLACE INTO objects ("id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) -- args: [883949, nil, 2025-01-01 09:30:52.432000000 UTC, 2025-01-02 11:46:30.632363566 UTC, nil, "ActivityPub::Object::Note", "https://mastodon.social/users/jwz/statuses/113752398211101653", true, 2025-01-01 09:30:49.0 UTC, "https://mastodon.social/users/jwz", nil, nil, "https://mastodon.social/users/jwz/statuses/113752398211101653", ["https://www.w3.org/ns/activitystreams#Public"], ["https://mastodon.social/users/jwz/followers"], nil, nil, "", nil, "en", nil, ["ActivityPub::Object::Attachment(@url=\"https://files.mastodon.social/media_attachments/files/113/752/398/023/486/347/original/bf028e192ebfede3.jpeg\", @media_type=\"image/jpeg\", @caption=nil)"], ["https://mastodon.social/@jwz/113752398211101653"]]
2025-01-02T11:46:30.634856Z  DEBUG - database: Query [     0.498ms] -- SELECT "type","id","created_at","updated_at","type","subject_iri","name","href" FROM "tags" WHERE "subject_iri" = ? AND "type" IN ("Tag::Hashtag") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:30.635263Z  DEBUG - database: Query [     0.398ms] -- SELECT "type","id","created_at","updated_at","type","subject_iri","name","href" FROM "tags" WHERE "subject_iri" = ? AND "type" IN ("Tag::Mention") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:30.635537Z  DEBUG - database: Query [     0.263ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "in_reply_to_iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Object::Note") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:30.635615Z  DEBUG - database: Query [     0.011ms] -- SELECT "id","created_at","updated_at","origin_id","name","summary","content" FROM "translations" WHERE "origin_id" = ? -- args: [883949]
2025-01-02T11:46:30.636348Z  DEBUG - database: Query [     0.258ms] -- WITH RECURSIVE replies_to(iri) AS ( VALUES(?) UNION SELECT o.iri FROM objects AS o, replies_to AS t JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = t.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ) SELECT count(o.iri) - 1 FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:30.636397Z  DEBUG - database: Query [     0.027ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "iri" = ? AND "deleted_at" IS NULL -- args: [nil]
2025-01-02 11:46:32 UTC 200 GET /remote/objects/883949 2.6ms
2025-01-02T11:46:32.486901Z  DEBUG - database: Query [     0.044ms] -- SELECT "id","created_at","updated_at","session_key","body_json","account_id" FROM "sessions" WHERE "session_key" = ? -- args: ["ulD-PLt-BvKA5QpulVaxwQ"]
2025-01-02T11:46:32.486919Z  DEBUG - database: Query [     0.012ms] -- SELECT "id","created_at","updated_at","username","encrypted_password","language","timezone","iri" FROM "accounts" WHERE "id" = ? -- args: [1]
2025-01-02T11:46:32.486980Z  DEBUG - database: Query [     0.043ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "to_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/remote/objects/883949"]
2025-01-02T11:46:32.487145Z  DEBUG - database: Query [     0.143ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "from_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/remote/objects/883949"]
2025-01-02T11:46:32.487571Z  DEBUG - database: Query [     0.047ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "id" = ? AND "deleted_at" IS NULL -- args: [883949]
2025-01-02T11:46:32.488028Z  DEBUG - database: Query [     0.146ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://mastodon.social/users/jwz"]
2025-01-02T11:46:32.488089Z  DEBUG - database: Query [     0.014ms] -- SELECT "id","created_at","updated_at","origin_id","name","summary","content" FROM "translations" WHERE "origin_id" = ? -- args: [883949]
2025-01-02T11:46:32.488195Z  DEBUG - database: Query [     0.086ms] -- SELECT "type","id","created_at","updated_at","type","subject_iri","name","href" FROM "tags" WHERE "subject_iri" = ? AND "type" IN ("Tag::Hashtag") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:32.488271Z  DEBUG - database: Query [     0.070ms] -- SELECT "type","id","created_at","updated_at","type","subject_iri","name","href" FROM "tags" WHERE "subject_iri" = ? AND "type" IN ("Tag::Mention") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:32.488495Z  DEBUG - database: Query [     0.023ms] -- SELECT "a"."type","a"."id","a"."created_at","a"."updated_at","a"."type","a"."undone_at","a"."iri","a"."visible","a"."published","a"."actor_iri","a"."object_iri","a"."target_iri","a"."to","a"."cc","a"."summary" FROM activities AS a JOIN actors AS t ON t.iri = a.actor_iri WHERE a.object_iri = ? AND a.type IN ("ActivityPub::Activity::Announce","ActivityPub::Activity::Like")  AND t.deleted_at IS NULL AND t.blocked_at IS NULL AND a.undone_at IS NULL ORDER BY a.id ASC -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:32.488747Z  DEBUG - database: Query [     0.234ms] -- WITH RECURSIVE replies_to(iri) AS ( VALUES(?) UNION SELECT o.iri FROM objects AS o, replies_to AS t JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = t.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ) SELECT count(o.iri) - 1 FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:32.488799Z  DEBUG - database: Query [     0.031ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "iri" = ? AND "deleted_at" IS NULL -- args: [nil]
2025-01-02T11:46:32.488917Z  DEBUG - database: Query [     0.098ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://social.jayvii.de/actors/jayvii"]
2025-01-02 11:46:33 UTC 200 GET /remote/objects/883949/thread 5.28ms
2025-01-02T11:46:33.768785Z  DEBUG - database: Query [     0.042ms] -- SELECT "id","created_at","updated_at","session_key","body_json","account_id" FROM "sessions" WHERE "session_key" = ? -- args: ["ulD-PLt-BvKA5QpulVaxwQ"]
2025-01-02T11:46:33.768806Z  DEBUG - database: Query [     0.013ms] -- SELECT "id","created_at","updated_at","username","encrypted_password","language","timezone","iri" FROM "accounts" WHERE "id" = ? -- args: [1]
2025-01-02T11:46:33.768862Z  DEBUG - database: Query [     0.038ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "to_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/remote/objects/883949"]
2025-01-02T11:46:33.769028Z  DEBUG - database: Query [     0.143ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "from_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/remote/objects/883949"]
2025-01-02T11:46:33.769086Z  DEBUG - database: Query [     0.033ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "id" = ? AND "deleted_at" IS NULL -- args: [883949]
2025-01-02T11:46:33.769202Z  DEBUG - database: Query [     0.106ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://social.jayvii.de/actors/jayvii"]
2025-01-02T11:46:33.771241Z  DEBUG - database: Query [     2.020ms] -- WITH RECURSIVE ancestors_of(iri, depth) AS ( VALUES(?, 0) UNION SELECT o.in_reply_to_iri AS iri, p.depth + 1 AS depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri = p.iri AND o.in_reply_to_iri IS NOT NULL AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ), replies_to(iri, position, depth) AS ( SELECT * FROM (SELECT iri, "", 0 FROM ancestors_of ORDER BY depth DESC LIMIT 1) UNION SELECT o.iri, r.position || "." || o.id, r.depth + 1 AS depth FROM objects AS o, replies_to AS r JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = r.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ) SELECT "o"."type","o"."id","o"."blocked_at","o"."created_at","o"."updated_at","o"."deleted_at","o"."type","o"."iri","o"."visible","o"."published","o"."attributed_to_iri","o"."in_reply_to_iri","o"."replies_iri","o"."thread","o"."to","o"."cc","o"."name","o"."summary","o"."content","o"."media_type","o"."language","o"."source","o"."attachments","o"."urls", r.depth FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) ORDER BY r.position -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:33.771909Z  DEBUG - database: Query [     0.650ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "from_iri" = ? AND "to_iri" = ? AND "type" IN ("Relationship::Content::Follow::Thread") -- args: ["https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:33.772387Z  DEBUG - database: Query [     0.196ms] -- SELECT "type","id","created_at","updated_at","type","source_iri","subject_iri","running","complete","backtrace","next_attempt_at","last_attempt_at","state","failures","state" FROM "tasks" WHERE "source_iri" = ? AND "subject_iri" = ? AND "type" IN ("Task::Fetch::Thread") -- args: ["https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:33.772593Z  DEBUG - database: Query [     0.125ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://mastodon.social/users/jwz"]
2025-01-02T11:46:33.772997Z  DEBUG - database: Query [     0.011ms] -- SELECT "id","created_at","updated_at","origin_id","name","summary","content" FROM "translations" WHERE "origin_id" = ? -- args: [883949]
2025-01-02T11:46:33.773345Z  DEBUG - database: Query [     0.243ms] -- WITH RECURSIVE replies_to(iri) AS ( VALUES(?) UNION SELECT o.iri FROM objects AS o, replies_to AS t JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = t.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ) SELECT count(o.iri) - 1 FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:33.773388Z  DEBUG - database: Query [     0.024ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "iri" = ? AND "deleted_at" IS NULL -- args: [nil]
2025-01-02T11:46:34.025833Z  DEBUG - database: Query [     0.044ms] -- SELECT "id","created_at","updated_at","session_key","body_json","account_id" FROM "sessions" WHERE "session_key" = ? -- args: ["ulD-PLt-BvKA5QpulVaxwQ"]
2025-01-02T11:46:34.025853Z  DEBUG - database: Query [     0.012ms] -- SELECT "id","created_at","updated_at","username","encrypted_password","language","timezone","iri" FROM "accounts" WHERE "id" = ? -- args: [1]
2025-01-02T11:46:34.025913Z  DEBUG - database: Query [     0.041ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "to_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/stream/objects/883949"]
2025-01-02T11:46:34.026080Z  DEBUG - database: Query [     0.148ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "from_iri" = ? AND "type" IN ("Relationship::Content::Canonical") -- args: ["/stream/objects/883949"]
2025-01-02T11:46:34.026422Z  DEBUG - database: Query [     0.032ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "id" = ? AND "deleted_at" IS NULL -- args: [883949]
2025-01-02T11:46:34.948907Z  DEBUG - database: Query [     0.378ms] -- UPDATE tasks SET running = 1 WHERE running = 0 AND complete = 0 AND backtrace IS NULL AND (next_attempt_at IS NULL OR next_attempt_at < ?) RETURNING "type","id","created_at","updated_at","type","source_iri","subject_iri","running","complete","backtrace","next_attempt_at","last_attempt_at","failures","state" -- args: [2025-01-02 11:46:34.948506244 UTC]
2025-01-02 11:46:35 UTC 200 POST /remote/objects/883949/fetch/start 5.98ms
2025-01-02T11:46:35.087923Z  DEBUG - database: Query [     0.041ms] -- SELECT "id","created_at","updated_at","session_key","body_json","account_id" FROM "sessions" WHERE "session_key" = ? -- args: ["ulD-PLt-BvKA5QpulVaxwQ"]
2025-01-02T11:46:35.087946Z  DEBUG - database: Query [     0.012ms] -- SELECT "id","created_at","updated_at","username","encrypted_password","language","timezone","iri" FROM "accounts" WHERE "id" = ? -- args: [1]
2025-01-02T11:46:35.088545Z  DEBUG - database: Query [     0.038ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "id" = ? AND "deleted_at" IS NULL -- args: [883949]
2025-01-02T11:46:35.088694Z  DEBUG - database: Query [     0.138ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://social.jayvii.de/actors/jayvii"]
2025-01-02T11:46:35.089185Z  DEBUG - database: Query [     0.473ms] -- WITH RECURSIVE ancestors_of(iri, depth) AS ( VALUES(?, 0) UNION SELECT o.in_reply_to_iri AS iri, p.depth + 1 AS depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri = p.iri AND o.in_reply_to_iri IS NOT NULL AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ), replies_to(iri, position, depth) AS ( SELECT * FROM (SELECT iri, "", 0 FROM ancestors_of ORDER BY depth DESC LIMIT 1) UNION SELECT o.iri, r.position || "." || o.id, r.depth + 1 AS depth FROM objects AS o, replies_to AS r JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = r.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ) SELECT "o"."type","o"."id","o"."blocked_at","o"."created_at","o"."updated_at","o"."deleted_at","o"."type","o"."iri","o"."visible","o"."published","o"."attributed_to_iri","o"."in_reply_to_iri","o"."replies_iri","o"."thread","o"."to","o"."cc","o"."name","o"."summary","o"."content","o"."media_type","o"."language","o"."source","o"."attachments","o"."urls", r.depth FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) ORDER BY r.position -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.089225Z  DEBUG - database: Query [     0.025ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Object::Note") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.090324Z  DEBUG - database: Query [     1.085ms] -- INSERT OR REPLACE INTO objects ("id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) -- args: [883949, nil, 2025-01-01 09:30:52.432000000 UTC, 2025-01-02 11:46:35.089230517 UTC, nil, "ActivityPub::Object::Note", "https://mastodon.social/users/jwz/statuses/113752398211101653", true, 2025-01-01 09:30:49.0 UTC, "https://mastodon.social/users/jwz", nil, nil, "https://mastodon.social/users/jwz/statuses/113752398211101653", ["https://www.w3.org/ns/activitystreams#Public"], ["https://mastodon.social/users/jwz/followers"], nil, nil, "", nil, "en", nil, ["ActivityPub::Object::Attachment(@url=\"https://files.mastodon.social/media_attachments/files/113/752/398/023/486/347/original/bf028e192ebfede3.jpeg\", @media_type=\"image/jpeg\", @caption=nil)"], ["https://mastodon.social/@jwz/113752398211101653"]]
2025-01-02T11:46:35.090350Z  DEBUG - database: Query [     0.015ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "in_reply_to_iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Object::Note") -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.090808Z  DEBUG - database: Query [     0.442ms] -- WITH RECURSIVE ancestors_of(iri, depth) AS ( VALUES(?, 0) UNION SELECT o.in_reply_to_iri AS iri, p.depth + 1 AS depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri = p.iri AND o.in_reply_to_iri IS NOT NULL AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ) SELECT "o"."type","o"."id","o"."blocked_at","o"."created_at","o"."updated_at","o"."deleted_at","o"."type","o"."iri","o"."visible","o"."published","o"."attributed_to_iri","o"."in_reply_to_iri","o"."replies_iri","o"."thread","o"."to","o"."cc","o"."name","o"."summary","o"."content","o"."media_type","o"."language","o"."source","o"."attachments","o"."urls", p.depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri IN (p.iri) AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.090863Z  DEBUG - database: Query [     0.042ms] -- SELECT "type","id","created_at","updated_at","type","source_iri","subject_iri","running","complete","backtrace","next_attempt_at","last_attempt_at","state","failures","state" FROM "tasks" WHERE "source_iri" = ? AND "subject_iri" = ? AND "type" IN ("Task::Fetch::Thread") -- args: ["https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.091448Z  DEBUG - database: Query [     0.484ms] -- WITH RECURSIVE ancestors_of(iri, depth) AS ( VALUES(?, 0) UNION SELECT o.in_reply_to_iri AS iri, p.depth + 1 AS depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri = p.iri AND o.in_reply_to_iri IS NOT NULL AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ), replies_to(iri, position, depth) AS ( SELECT * FROM (SELECT iri, "", 0 FROM ancestors_of ORDER BY depth DESC LIMIT 1) UNION SELECT o.iri, r.position || "." || o.id, r.depth + 1 AS depth FROM objects AS o, replies_to AS r JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = r.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ) SELECT "o"."type","o"."id","o"."blocked_at","o"."created_at","o"."updated_at","o"."deleted_at","o"."type","o"."iri","o"."visible","o"."published","o"."attributed_to_iri","o"."in_reply_to_iri","o"."replies_iri","o"."thread","o"."to","o"."cc","o"."name","o"."summary","o"."content","o"."media_type","o"."language","o"."source","o"."attachments","o"."urls", r.depth FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) ORDER BY r.position -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.092764Z  DEBUG - database: Query [     1.305ms] -- INSERT OR REPLACE INTO tasks ("id","created_at","updated_at","type","source_iri","subject_iri","running","complete","backtrace","next_attempt_at","last_attempt_at","state") VALUES (?,?,?,?,?,?,?,?,?,?,?,?) -- args: [nil, 2025-01-02 11:46:35.090950332 UTC, 2025-01-02 11:46:35.090949861 UTC, "Task::Fetch::Thread", "https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653", false, false, nil, nil, nil, "#<Task::Fetch::Thread::State:0x7f7bc971da00>"]
2025-01-02T11:46:35.092898Z  DEBUG - database: Query [     0.113ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://mastodon.social/users/jwz"]
2025-01-02T11:46:35.092964Z  DEBUG - database: Query [     0.008ms] -- SELECT "id","created_at","updated_at","origin_id","name","summary","content" FROM "translations" WHERE "origin_id" = ? -- args: [883949]
2025-01-02T11:46:35.093212Z  DEBUG - database: Query [     0.214ms] -- WITH RECURSIVE replies_to(iri) AS ( VALUES(?) UNION SELECT o.iri FROM objects AS o, replies_to AS t JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = t.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ) SELECT count(o.iri) - 1 FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.093254Z  DEBUG - database: Query [     0.024ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","visible","published","attributed_to_iri","in_reply_to_iri","replies_iri","thread","to","cc","name","summary","content","media_type","language","source","attachments","urls" FROM "objects" WHERE "iri" = ? AND "deleted_at" IS NULL -- args: [nil]
2025-01-02T11:46:35.094897Z  DEBUG - database: Query [     0.137ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://social.jayvii.de/actors/jayvii"]
2025-01-02T11:46:35.095329Z  DEBUG - database: Query [     0.419ms] -- WITH RECURSIVE ancestors_of(iri, depth) AS ( VALUES(?, 0) UNION SELECT o.in_reply_to_iri AS iri, p.depth + 1 AS depth FROM objects AS o, ancestors_of AS p JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.iri = p.iri AND o.in_reply_to_iri IS NOT NULL AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ), replies_to(iri, position, depth) AS ( SELECT * FROM (SELECT iri, "", 0 FROM ancestors_of ORDER BY depth DESC LIMIT 1) UNION SELECT o.iri, r.position || "." || o.id, r.depth + 1 AS depth FROM objects AS o, replies_to AS r JOIN actors AS a ON a.iri = o.attributed_to_iri WHERE o.in_reply_to_iri = r.iri AND o.deleted_at IS NULL AND o.blocked_at IS NULL AND a.deleted_at IS NULL AND a.blocked_at IS NULL ORDER BY depth DESC ) SELECT "o"."type","o"."id","o"."blocked_at","o"."created_at","o"."updated_at","o"."deleted_at","o"."type","o"."iri","o"."visible","o"."published","o"."attributed_to_iri","o"."in_reply_to_iri","o"."replies_iri","o"."thread","o"."to","o"."cc","o"."name","o"."summary","o"."content","o"."media_type","o"."language","o"."source","o"."attachments","o"."urls", r.depth FROM objects AS o, replies_to AS r WHERE o.iri IN (r.iri) ORDER BY r.position -- args: ["https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.095363Z  DEBUG - database: Query [     0.023ms] -- SELECT "type","id","created_at","updated_at","type","source_iri","subject_iri","running","complete","backtrace","next_attempt_at","last_attempt_at","state","failures","state" FROM "tasks" WHERE "source_iri" = ? AND "subject_iri" = ? AND "type" IN ("Task::Fetch::Thread") -- args: ["https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.095401Z  DEBUG - database: Query [     0.033ms] -- SELECT "type","id","created_at","updated_at","type","from_iri","to_iri","confirmed","visible" FROM "relationships" WHERE "from_iri" = ? AND "to_iri" = ? AND "type" IN ("Relationship::Content::Follow::Thread") -- args: ["https://social.jayvii.de/actors/jayvii", "https://mastodon.social/users/jwz/statuses/113752398211101653"]
2025-01-02T11:46:35.095574Z  DEBUG - database: Query [     0.097ms] -- SELECT "type","id","blocked_at","created_at","updated_at","deleted_at","type","iri","username","pem_public_key","pem_private_key","inbox","outbox","following","followers","name","summary","icon","image","urls","attachments","down_at" FROM "actors" WHERE "iri" = ? AND "deleted_at" IS NULL AND "type" IN ("ActivityPub::Actor::Application","ActivityPub::Actor::Group","ActivityPub::Actor::Organization","ActivityPub::Actor::Person","ActivityPub::Actor::Service","ActivityPub::Actor") -- args: ["https://mastodon.social/users/jwz"]

I cannot really find anything useful in their either, I fear. Obviously, the URL to the image seems to be contained, but is not inserted into the UI, I guess. Any ideas?

@toddsundsted toddsundsted added the bug Something isn't working label Jan 2, 2025
@toddsundsted
Copy link
Owner

toddsundsted commented Jan 2, 2025

thanks for catching this! yes, this was introduced when i refactored the view partial in 0ff9237 and didn't have a test to catch it. this is fixed in 2553856.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants