Notifications: Error fetching updates
Backend Version 1.0.0-786-gdab36d89-develop
Frontend Version
221db9f2
LOG:
23:17:19.727 request_id=FbqYFcEaIjW5ahoAABKh [error] Internal server error: %Ecto.MultipleResultsError{message: "expected at most one result but got 2 in query:\n\nfrom a0 in Pleroma.Activity,\n where: fragment(\"coalesce((?)->'object'->>'id', (?)->>'object') = ?\", a0.data, a0.data, ^\"tag:gnusocial.villanos.net,2018-08-06:noticeId=167476:objectType=comment\"),\n where: fragment(\"(?)->>'type' = 'Create'\", a0.data),\n where: fragment(\"? not in (SELECT ap_id FROM users WHERE info->'deactivated' @> 'true')\", a0.actor)\n"}
23:17:19.730 [error] #PID<0.2135.0> running Pleroma.Web.Endpoint (connection #PID<0.2134.0>, stream id 1) terminated
Server: pleroma.libretux.com:80 (http)
Request: GET /api/v1/notifications?count=20&with_muted=false
** (exit) an exception was raised:
** (Ecto.MultipleResultsError) expected at most one result but got 2 in query:
from a0 in Pleroma.Activity,
where: fragment("coalesce((?)->'object'->>'id', (?)->>'object') = ?", a0.data, a0.data, ^"tag:gnusocial.villanos.net,2018-08-06:noticeId=167476:objectType=comment"),
where: fragment("(?)->>'type' = 'Create'", a0.data),
where: fragment("? not in (SELECT ap_id FROM users WHERE info->'deactivated' @> 'true')", a0.actor)
(ecto) lib/ecto/repo/queryable.ex:70: Ecto.Repo.Queryable.one/3
(pleroma) lib/pleroma/web/mastodon_api/views/notification_view.ex:25: Pleroma.Web.MastodonAPI.NotificationView.render/2
(elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2
(elixir) lib/enum.ex:1336: Enum."-map/2-lists^map/1-0-"/2
(phoenix) lib/phoenix/view.ex:399: Phoenix.View.render_to_iodata/3
(phoenix) lib/phoenix/controller.ex:729: Phoenix.Controller.__put_render__/5
(pleroma) lib/pleroma/web/endpoint.ex:5: Pleroma.Web.Endpoint.instrument/4
(phoenix) lib/phoenix/controller.ex:746: Phoenix.Controller.instrument_render_and_send/4
Edited by Haelwenn