Error trying to follow someone
When I try to follow someone (https://pleroma.soykaf.com/users/3460, just because experimenting), I get the following error:
[error] #PID<0.491.0> running Pleroma.Web.Endpoint terminated Server: mastodon.thezombie.net:80 (http) Request: GET /api/externalprofile/show.json?profileurl=nicknicknicknick@mastodon.social ** (exit) an exception was raised: ** (Postgrex.Error) ERROR 42601 (syntax_error): syntax error at or near "ON" (ecto) lib/ecto/adapters/sql.ex:571: Ecto.Adapters.SQL.struct/7 (ecto) lib/ecto/repo/schema.ex:467: Ecto.Repo.Schema.apply/4 (ecto) lib/ecto/repo/schema.ex:205: anonymous fn/13 in Ecto.Repo.Schema.do_insert/4 (ecto) lib/ecto/repo/schema.ex:684: anonymous fn/3 in Ecto.Repo.Schema.wrap_in_transaction/6 (ecto) lib/ecto/adapters/sql.ex:620: anonymous fn/3 in Ecto.Adapters.SQL.do_transaction/3 (db_connection) lib/db_connection.ex:1275: DBConnection.transaction_run/4 (db_connection) lib/db_connection.ex:1199: DBConnection.run_begin/3 (db_connection) lib/db_connection.ex:790: DBConnection.transaction/3 (pleroma) lib/pleroma/web/twitter_api/twitter_api.ex:319: Pleroma.Web.TwitterAPI.TwitterAPI.get_external_profile/2 (pleroma) lib/pleroma/web/twitter_api/twitter_api_controller.ex:239: Pleroma.Web.TwitterAPI.Controller.external_profile/2 (pleroma) lib/pleroma/web/twitter_api/twitter_api_controller.ex:1: Pleroma.Web.TwitterAPI.Controller.action/2 (pleroma) lib/pleroma/web/twitter_api/twitter_api_controller.ex:1: Pleroma.Web.TwitterAPI.Controller.phoenix_controller_pipeline/2 (pleroma) lib/pleroma/web/endpoint.ex:1: Pleroma.Web.Endpoint.instrument/4 (phoenix) lib/phoenix/router.ex:278: Phoenix.Router.__call__/1 (pleroma) lib/pleroma/web/endpoint.ex:1: Pleroma.Web.Endpoint.plug_builder_call/2 (pleroma) lib/plug/debugger.ex:99: Pleroma.Web.Endpoint."call (overridable 3)"/2 (pleroma) lib/pleroma/web/endpoint.ex:1: Pleroma.Web.Endpoint.call/2 (plug) lib/plug/adapters/cowboy/handler.ex:15: Plug.Adapters.Cowboy.Handler.upgrade/4 (cowboy) /home/nerdicus/src/pleroma/deps/cowboy/src/cowboy_protocol.erl:442: :cowboy_protocol.execute/4
This comes right after I have this in the logs:
[debug] QUERY OK source="users" db=1.0ms SELECT u0."id", u0."bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."following", u0."ap_id", u0."avatar", u0."local", u0."info", u0."follower_address", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://mastodon.social/users/nicknicknicknick"] [debug] QUERY OK db=0.1ms begin [] [debug] QUERY ERROR db=5.7ms INSERT INTO "users" ("ap_id","avatar","bio","follower_address","following","info","local","name","nickname","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) ON CONFLICT ("nickname") DO UPDATE SET "ap_id" = EXCLUDED."ap_id","avatar" = EXCLUDED."avatar","bio" = EXCLUDED."bio","follower_address" = EXCLUDED."follower_address","following" = EXCLUDED."following","info" = EXCLUDED."info","local" = EXCLUDED."local","name" = EXCLUDED."name","nickname" = EXCLUDED."nickname","inserted_at" = EXCLUDED."inserted_at","updated_at" = EXCLUDED."updated_at" RETURNING "id" ["https://mastodon.social/users/nicknicknicknick", %{"type" => "Image", "url" => [%{"href" => "https://files.mastodon.social/accounts/avatars/000/010/961/original/media.png", "mediaType" => "image/png", "type" => "Link"}]}, "<p>hello.<br />how are you.<br />he/him/ho-hum.<br /><a href=\"http://nicknicknicknick.net/\" rel=\"nofollow noopener\" target=\"_blank\"><span class=\"invisible\">http://</span><span class=\"\">nicknicknicknick.net</span><span class=\"invisible\"></span></a></p>", "http://mastodon.thezombie.net:10298/users/nicknicknicknick@mastodon.social/followers", [], %{"avatar" => %{"type" => "Image", "url" => [%{"href" => "https://files.mastodon.social/accounts/avatars/000/010/961/original/media.png", "mediaType" => "image/png", "type" => "Link"}]}, "bio" => "<p>hello.<br />how are you.<br />he/him/ho-hum.<br /><a href=\"http://nicknicknicknick.net/\" rel=\"nofollow noopener\" target=\"_blank\"><span class=\"invisible\">http://</span><span class=\"\">nicknicknicknick.net</span><span class=\"invisible\"></span></a></p>", "fqn" => "nicknicknicknick@mastodon.social", "host" => "mastodon.social", "hub" => "https://mastodon.social/api/push", "magic_key" => "RSA.3n3ymEyROeeOYtviYrJzvi4_md7yY-35d5bvRLFgsvX1iz5NYja_LiYaYugSt3L7bIeJEestDgTo4PmGTWBIbImVa1FMcNc-W18tZRHYcKLHOOdwhRT30jzddRCVj6JLwDZ2tu536vhF0KAx9hBiOul8hYyjvd7fPNBR8mU72ALkV4Tx3rXjdS12NwTBxXSHX4U11xNf-3n1aqRAKXdluY1rf8hLVyayHxBj6vDCO79pt8WqokbJqzpb7A1ZBp-9-scx_X-W21tOXFIGJ9ylp6bOAFKTqrmhpUqSyd6ndqLmxaDiJZjKEEteYPSAm7qAYjqA91vk2MA_RkpfgLsrZQ==.AQAB", "name" => "nick nick nick nick", "nickname" => "nicknicknicknick", "salmon" => "https://mastodon.social/api/salmon/10961", "subject" => "acct:nicknicknicknick@mastodon.social", "topic" => "https://mastodon.social/users/nicknicknicknick.atom", "uri" => "https://mastodon.social/users/nicknicknicknick"}, false, "nick nick nick nick", "nicknicknicknick@mastodon.social", {{2017, 11, 15}, {18, 18, 16, 503625}}, {{2017, 11, 15}, {18, 18, 16, 506230}}]
This is just me punching the nickname in my instance. Instance: https://mastodon.thezombie.net