error in get_account_posts_by_blog in rc10
Seems like the issue happens for several upper-level functions (get_account_posts_by_blog
, get_account_posts_by_posts
, bridge_api_get_discussion
) that share the create_bridge_post_object call for formatting their output. I don't have an API call example that does it, I just found these errors in the psotgres logs.
The full error is on s10, but here's the gist of it:
024-12-20 00:38:22 UTC [76992]: app=hive-mind-postgrest ERROR: invalid input syntax for type json
2024-12-20 00:38:22 UTC [76992]: app=hive-mind-postgrest DETAIL: Expected "," or "]", but found ""statistics"".
2024-12-20 00:38:22 UTC [76992]: app=hive-mind-postgrest CONTEXT: JSON data, line 1: {"tags":["ru""statistics"...
PL/pgSQL assignment "_result = jsonb_build_object(
'post_id', _row.id,
'author', _row.author,
'permlink', _row.permlink,
'category', (CASE
WHEN _row.category IS NULL THEN ''
ELSE _row.category
...
)"
PL/pgSQL function hivemind_postgrest_utilities.get_account_posts_by_blog(text,integer,integer,integer,integer,integer,boolean) line 19 at assignment
PL/pgSQL function bridge_api_get_account_posts(jsonb) line 42 at RETURN
PL/pgSQL function hivemind_postgrest_utilities.get_bridge_method(text,jsonb) line 15 at assignment
PL/pgSQL function hivemind_postgrest_utilities.dispatch(text,text,jsonb) line 11 at assignment
PL/pgSQL function home(json) line 14 at RETURN
Edited by Dan Notestein