aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRoman Chvanikov <chvanikoff@pm.me>2020-01-14 19:53:28 +0300
committerRoman Chvanikov <chvanikoff@pm.me>2020-01-14 19:53:28 +0300
commit0709757e47a546225163482474a46e8bc3d09837 (patch)
tree041563672ba4b204074218c703537d5531220c3f
parentd150c598d7e9bb9d5a72bea04c65c1206f55f3bd (diff)
downloadpleroma-0709757e47a546225163482474a46e8bc3d09837.tar.gz
Check if object->data is array when looking up attachment objects to delete
-rw-r--r--lib/pleroma/object.ex3
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/pleroma/object.ex b/lib/pleroma/object.ex
index 2452a7389..6c56a9c62 100644
--- a/lib/pleroma/object.ex
+++ b/lib/pleroma/object.ex
@@ -203,7 +203,8 @@ defmodule Pleroma.Object do
from(o in Object,
where:
fragment(
- "to_jsonb(array(select jsonb_array_elements((?)#>'{url}') ->> 'href'))::jsonb \\?| (?)",
+ "to_jsonb(array(select jsonb_array_elements((?)#>'{url}') ->> 'href' where jsonb_typeof((?)#>'{url}') = 'array'))::jsonb \\?| (?)",
+ o.data,
o.data,
^hrefs
)