[sql error trigger] missing FROM-clause entry for table "StoryContentModel"

[vibern0]

https://appsignal.com/impactmarket/sites/63c5932e83eb6790d1b8c0f4/logs?query=&timeframe=custom&from=2023-11-19T16%3A06%3A00.000Z&to=2023-11-19T16%3A08%3A00.000Z

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512957][heroku][PURPLE] [11-3] "story_user_report" AS "storyUserReport" ON "storyContent"."id" = "storyUserReport"."contentId" AND "storyUserReport"."address" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' INNER JOIN "story_community" AS "storyCommunity" ON "storyContent"."id" = "storyCommunity"."contentId" LEFT OUTER JOIN "community" AS "storyCommunity->community" ON "storyCommunity"."communityId" = "storyCommunity->community"."id" LEFT OUTER JOIN "story_comment" AS "storyComment" ON "storyContent"."id" = "storyComment"."contentId" WHERE "storyContent"."byAddress" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' AND "storyContent"."isPublic" = true GROUP BY "StoryContentModel"."id", "storyCommunity"."id", "storyCommunity->community"."id", "storyEngagement"."id", "storyUserEngagement"."id", "storyUserReport"."id";

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512957][heroku][PURPLE] [11-2] sql_error_code = 42P01 time_ms = "2023-11-19 16:07:14.566 UTC" pid="1443224" proc_start_time="2023-11-19 16:06:55 UTC" session_id="655a329f.160598" vtid="2/965500" tid="0" log_line="4" database="d56l4mho1dkh25" connection_source="3.252.247.59(45276)" user="u57h2uepi221ft" application_name="[unknown]" STATEMENT: SELECT "StoryContentModel"."id", "storyCommunity"."id", "storyCommunity->community"."id", "storyEngagement"."id", "storyUserEngagement"."id", "storyUserReport"."id", count("storyContent"."id") AS "count" FROM "story_content" AS "storyContent" LEFT OUTER JOIN "story_engagement" AS "storyEngagement" ON "storyContent"."id" = "storyEngagement"."contentId" LEFT OUTER JOIN "story_user_engagement" AS "storyUserEngagement" ON "storyContent"."id" = "storyUserEngagement"."contentId" AND "storyUserEngagement"."address" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' LEFT OUTER JOIN

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512957][heroku][PURPLE] [11-1] sql_error_code = 42P01 time_ms = "2023-11-19 16:07:14.566 UTC" pid="1443224" proc_start_time="2023-11-19 16:06:55 UTC" session_id="655a329f.160598" vtid="2/965500" tid="0" log_line="3" database="d56l4mho1dkh25" connection_source="3.252.247.59(45276)" user="u57h2uepi221ft" application_name="[unknown]" ERROR: missing FROM-clause entry for table "StoryContentModel" at character 8

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512958][heroku][PURPLE] [11-5] "storyCommunity"."id", "storyCommunity->community"."id", "storyEngagement"."id", "storyUserEngagement"."id", "storyUserReport"."id" ORDER BY "storyContent"."postedAt" DESC LIMIT 10 OFFSET 0;

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512958][heroku][PURPLE] [11-4] OUTER JOIN "story_user_engagement" AS "storyUserEngagement" ON "storyContent"."id" = "storyUserEngagement"."contentId" AND "storyUserEngagement"."address" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' LEFT OUTER JOIN "story_user_report" AS "storyUserReport" ON "storyContent"."id" = "storyUserReport"."contentId" AND "storyUserReport"."address" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' INNER JOIN "story_community" AS "storyCommunity" ON "storyContent"."id" = "storyCommunity"."contentId" LEFT OUTER JOIN "community" AS "storyCommunity->community" ON "storyCommunity"."communityId" = "storyCommunity->community"."id" LEFT OUTER JOIN "story_comment" AS "storyComment" ON "storyContent"."id" = "storyComment"."contentId" WHERE "storyContent"."byAddress" = '0xe3029F1084a9CccD7e21Be9FDD8331878aeab715' AND "storyContent"."isPublic" = true GROUP BY "StoryContentModel"."id",

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512958][heroku][PURPLE] [11-2] sql_error_code = 42P01 time_ms = "2023-11-19 16:07:14.568 UTC" pid="1443225" proc_start_time="2023-11-19 16:06:55 UTC" session_id="655a329f.160599" vtid="4/1277708" tid="0" log_line="4" database="d56l4mho1dkh25" connection_source="3.252.247.59(45290)" user="u57h2uepi221ft" application_name="[unknown]" STATEMENT: SELECT "storyContent"."id", "storyContent"."message", "storyContent"."storyMedia", "storyContent"."byAddress", "storyContent"."postedAt", count(distinct("storyComment"."id")) AS "totalComments", "storyEngagement"."id" AS "storyEngagement.id", "storyEngagement"."contentId" AS "storyEngagement.contentId", "storyEngagement"."loves" AS "storyEngagement.loves", "storyUserEngagement"."id" AS "storyUserEngagement.id", "storyUserEngagement"."contentId" AS "storyUserEngagement.contentId", "storyUserEngagement"."address" AS "storyUserEngagement.address", "storyUserReport"."id" AS

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512958][heroku][PURPLE] [11-3] "storyUserReport.id", "storyUserReport"."contentId" AS "storyUserReport.contentId", "storyUserReport"."address" AS "storyUserReport.address", "storyUserReport"."typeId" AS "storyUserReport.typeId", "storyCommunity"."id" AS "storyCommunity.id", "storyCommunity"."contentId" AS "storyCommunity.contentId", "storyCommunity"."communityId" AS "storyCommunity.communityId", "storyCommunity->community"."id" AS "storyCommunity.community.id", "storyCommunity->community"."name" AS "storyCommunity.community.name", "storyCommunity->community"."coverMediaPath" AS "storyCommunity.community.coverMediaPath", "storyCommunity->community"."city" AS "storyCommunity.community.city", "storyCommunity->community"."country" AS "storyCommunity.community.country" FROM "story_content" AS "storyContent" LEFT OUTER JOIN "story_engagement" AS "storyEngagement" ON "storyContent"."id" = "storyEngagement"."contentId" LEFT

+19-11-2023 16:07:14.000[heroku-logs][INFO][postgres.3512958][heroku][PURPLE] [11-1] sql_error_code = 42P01 time_ms = "2023-11-19 16:07:14.568 UTC" pid="1443225" proc_start_time="2023-11-19 16:06:55 UTC" session_id="655a329f.160599" vtid="4/1277708" tid="0" log_line="3" database="d56l4mho1dkh25" connection_source="3.252.247.59(45290)" user="u57h2uepi221ft" application_name="[unknown]" ERROR: missing FROM-clause entry for table "StoryContentModel" at character 2329

+19-11-2023 16:07:14.267[heroku-logs][INFO][router][heroku]at=info method=OPTIONS path="/api/v2/stories?user=0xe3029F1084a9CccD7e21Be9FDD8331878aeab715&limit=10" host=impactmarket-api-production.herokuapp.com request_id=a5660223-a445-410d-8942-b4db606b9674 fwd="196.168.217.2" dyno=web.1 connect=1ms service=1ms status=204 bytes=992 protocol=https