Ecto.Query.CastError at POST /auth/telegram

deps/ecto/lib/ecto/repo/queryable.ex:451: value `{:ok, 5621580744}` in `where` cannot be cast to type :string in query: from u0 in MayorGame.Auth.User, where: u0.telegram_id == ^{:ok, 5621580744}, select: u0

# Ecto.Query.CastError at POST /auth/telegram Exception: ** (Ecto.Query.CastError) deps/ecto/lib/ecto/repo/queryable.ex:451: value `{:ok, 5621580744}` in `where` cannot be cast to type :string in query: from u0 in MayorGame.Auth.User, where: u0.telegram_id == ^{:ok, 5621580744}, select: u0 (elixir 1.12.2) lib/enum.ex:2385: Enum."-reduce/3-lists^foldl/2-0-"/3 (elixir 1.12.2) lib/enum.ex:1704: Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3 (elixir 1.12.2) lib/enum.ex:2385: Enum."-reduce/3-lists^foldl/2-0-"/3 (ecto 3.7.2) lib/ecto/repo/queryable.ex:203: Ecto.Repo.Queryable.execute/4 (ecto 3.7.2) lib/ecto/repo/queryable.ex:19: Ecto.Repo.Queryable.all/3 (ecto 3.7.2) lib/ecto/repo/queryable.ex:146: Ecto.Repo.Queryable.one/3 (mayor_game 0.1.0) lib/mayor_game_web/controllers/auth_controller.ex:20: MayorGameWeb.AuthController.telegram_login/2 (mayor_game 0.1.0) lib/mayor_game_web/controllers/auth_controller.ex:1: MayorGameWeb.AuthController.action/2 (mayor_game 0.1.0) lib/mayor_game_web/controllers/auth_controller.ex:1: MayorGameWeb.AuthController.phoenix_controller_pipeline/2 (phoenix 1.6.16) lib/phoenix/router.ex:354: Phoenix.Router.__call__/2 Code: `lib/enum.ex` No code available. `lib/enum.ex` No code available. `lib/enum.ex` No code available. `lib/ecto/repo/queryable.ex` 198 199 defp execute(operation, name, query, opts) when is_list(opts) do 200 {adapter, %{cache: cache, repo: repo} = adapter_meta} = Ecto.Repo.Registry.lookup(name) 201 {query, opts} = repo.prepare_query(operation, query, opts) 202 query = attach_prefix(query, opts) 203> {query_meta, prepared, params} = Planner.query(query, operation, cache, adapter, 0) 204 205 case query_meta do 206 %{select: nil} -> 207 adapter.execute(adapter_meta, query_meta, prepared, params, opts) 208 `lib/ecto/repo/queryable.ex` 14 query = 15 queryable 16 |> Ecto.Queryable.to_query() 17 |> Ecto.Query.Planner.ensure_select(true) 18 19> execute(:all, name, query, opts) |> elem(1) 20 end 21 22 def stream(name, queryable, opts) when is_list(opts) do 23 query = 24 queryable `lib/ecto/repo/queryable.ex` 141 142 %{query | combinations: combinations} 143 end 144 145 def one(name, queryable, opts) do 146> case all(name, queryable, opts) do 147 [one] -> one 148 [] -> nil 149 other -> raise Ecto.MultipleResultsError, queryable: queryable, count: length(other) 150 end 151 end `lib/mayor_game_web/controllers/auth_controller.ex` 15 16 def telegram_login(conn, %{"initData" => init_data}) do 17 case Telegram.verify_init_data(init_data) do 18 {:ok, telegram_id} -> 19 user = 20> MayorGame.Repo.get_by(MayorGame.Auth.User, telegram_id: telegram_id) || 21 create_telegram_user(telegram_id) 22 23 conn 24 |> put_session(:telegram_id, telegram_id) 25 |> put_flash(:info, "Logged in successfully!") `lib/mayor_game_web/controllers/auth_controller.ex` 1> defmodule MayorGameWeb.AuthController do 2 use MayorGameWeb, :controller 3 4 alias MayorGame.Auth.Telegram 5 6 def telegram_auth(conn, _params) do `lib/mayor_game_web/controllers/auth_controller.ex` 1> defmodule MayorGameWeb.AuthController do 2 use MayorGameWeb, :controller 3 4 alias MayorGame.Auth.Telegram 5 6 def telegram_auth(conn, _params) do `lib/phoenix/router.ex` 349 metadata = %{metadata | conn: halted_conn} 350 :telemetry.execute([:phoenix, :router_dispatch, :stop], measurements, metadata) 351 halted_conn 352 %Plug.Conn{} = piped_conn -> 353 try do 354> plug.call(piped_conn, plug.init(opts)) 355 else 356 conn -> 357 measurements = %{duration: System.monotonic_time() - start} 358 metadata = %{metadata | conn: conn} 359 :telemetry.execute([:phoenix, :router_dispatch, :stop], measurements, metadata) ## Connection details ### Params %{"initData" => "query_id=AAHIgxJPAgAAAMiDEk-6HAoH&user=%7B%22id%22%3A5621580744%2C%22first_name%22%3A%22Bort%22%2C%22last_name%22%3A%22%22%2C%22username%22%3A%22bortisbased%22%2C%22language_code%22%3A%22en%22%2C%22allows_write_to_pm%22%3Atrue%2C%22photo_url%22%3A%22https%3A%5C%2F%5C%2Ft.me%5C%2Fi%5C%2Fuserpic%5C%2F320%5C%2FXnIpq1PD6AtBFJadqYLzuj1H5sOsxMSWCWZPa3fskLILPwYTDXDa_Ebt0l9JjRzh.svg%22%7D&auth_date=1785822611&signature=jmi8j5_3UgfF_kFFQmJtPeyHpENOD3vJ2hHimyrNndysQ_VzFwKAJltsy-SZbbzb2nPIgOjNiRp4umvITkh7Bg&hash=cbc59b853ee72a037f02587f950f24923cd87824327e85d69806061e08d6add3"} ### Request info * URI: http://mayor.tendy.zone:80/auth/telegram * Query string: ### Headers * accept: */* * accept-encoding: gzip, br * accept-language: en,en-US;q=0.9 * cdn-loop: cloudflare; loops=1 * cf-connecting-ip: 2601:1c2:1c82:c50:b510:43e3:34a:5349 * cf-ipcountry: US * cf-ray: a25b49d4b929ccd1-PDX * cf-visitor: {"scheme":"https"} * connection: upgrade * content-length: 586 * content-type: application/json * cookie: _ga=GA1.1.1089340904.1785766980; _mayor_game_key=SFMyNTY.g3QAAAABbQAAAAtfY3NyZl90b2tlbm0AAAAYY3UwVVk1ZVpxdDh1OWk3Wm9UNENDeXFP.vrHM-13uDgabK8wM4f5pv6FgLT95O8hY8NR65ur_B48; _ga_XJE5DTH2CE=GS2.1.s1785818654$o3$g1$t1785818899$j60$l0$h0 * host: mayor.tendy.zone * origin: https://mayor.tendy.zone * priority: u=1, i * referer: https://mayor.tendy.zone/auth/telegram * sec-ch-ua: "Not;A=Brand";v="8", "Chromium";v="150", "Android WebView";v="150" * sec-ch-ua-mobile: ?1 * sec-ch-ua-platform: "Android" * sec-fetch-dest: empty * sec-fetch-mode: cors * sec-fetch-site: same-origin * user-agent: Mozilla/5.0 (Linux; Android 12; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.7871.181 Mobile Safari/537.36 Telegram-Android/12.9.1 (Tcl T767W; Android 12; SDK 31; AVERAGE) * x-csrf-token: AmIGZioKbH8cHAN3IAgxEzx-OTQbEwUiV8h7Ri65_dFEslPpy8SulwNQ * x-forwarded-for: 2601:1c2:1c82:c50:b510:43e3:34a:5349, 104.23.160.175 * x-forwarded-proto: https * x-real-ip: 104.23.160.175 * x-requested-with: org.telegram.messenger.web ### Session %{"_csrf_token" => "cu0UY5eZqt8u9i7ZoT4CCyqO"}

lib/enum.ex

No code available.

Enum."-reduce/3-lists^foldl/2-0-"/3 elixir

lib/enum.ex

No code available.

Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3 elixir

lib/enum.ex

No code available.

Enum."-reduce/3-lists^foldl/2-0-"/3 elixir

lib/ecto/repo/queryable.ex

198 199 defp execute(operation, name, query, opts) when is_list(opts) do 200 {adapter, %{cache: cache, repo: repo} = adapter_meta} = Ecto.Repo.Registry.lookup(name) 201 {query, opts} = repo.prepare_query(operation, query, opts) 202 query = attach_prefix(query, opts) 203 {query_meta, prepared, params} = Planner.query(query, operation, cache, adapter, 0) 204 205 case query_meta do 206 %{select: nil} -> 207 adapter.execute(adapter_meta, query_meta, prepared, params, opts) 208

Ecto.Repo.Queryable.execute/4 ecto

lib/ecto/repo/queryable.ex

14 query = 15 queryable 16 |> Ecto.Queryable.to_query() 17 |> Ecto.Query.Planner.ensure_select(true) 18 19 execute(:all, name, query, opts) |> elem(1) 20 end 21 22 def stream(name, queryable, opts) when is_list(opts) do 23 query = 24 queryable

Ecto.Repo.Queryable.all/3 ecto

lib/ecto/repo/queryable.ex

141 142 %{query | combinations: combinations} 143 end 144 145 def one(name, queryable, opts) do 146 case all(name, queryable, opts) do 147 [one] -> one 148 [] -> nil 149 other -> raise Ecto.MultipleResultsError, queryable: queryable, count: length(other) 150 end 151 end

Ecto.Repo.Queryable.one/3 ecto

lib/mayor_game_web/controllers/auth_controller.ex

15 16 def telegram_login(conn, %{"initData" => init_data}) do 17 case Telegram.verify_init_data(init_data) do 18 {:ok, telegram_id} -> 19 user = 20 MayorGame.Repo.get_by(MayorGame.Auth.User, telegram_id: telegram_id) || 21 create_telegram_user(telegram_id) 22 23 conn 24 |> put_session(:telegram_id, telegram_id) 25 |> put_flash(:info, "Logged in successfully!")

MayorGameWeb.AuthController.telegram_login/2 Docs mayor_game

lib/mayor_game_web/controllers/auth_controller.ex

1defmodule MayorGameWeb.AuthController do 2 use MayorGameWeb, :controller 3 4 alias MayorGame.Auth.Telegram 5 6 def telegram_auth(conn, _params) do

MayorGameWeb.AuthController.action/2 mayor_game

lib/mayor_game_web/controllers/auth_controller.ex

1defmodule MayorGameWeb.AuthController do 2 use MayorGameWeb, :controller 3 4 alias MayorGame.Auth.Telegram 5 6 def telegram_auth(conn, _params) do

MayorGameWeb.AuthController.phoenix_controller_pipeline/2 mayor_game

lib/phoenix/router.ex

349 metadata = %{metadata | conn: halted_conn} 350 :telemetry.execute([:phoenix, :router_dispatch, :stop], measurements, metadata) 351 halted_conn 352 %Plug.Conn{} = piped_conn -> 353 try do 354 plug.call(piped_conn, plug.init(opts)) 355 else 356 conn -> 357 measurements = %{duration: System.monotonic_time() - start} 358 metadata = %{metadata | conn: conn} 359 :telemetry.execute([:phoenix, :router_dispatch, :stop], measurements, metadata)

Phoenix.Router.__call__/2 phoenix

Show only app frames

Params

initData

"query_id=AAHIgxJPAgAAAMiDEk-6HAoH&user=%7B%22id%22%3A5621580744%2C%22first_name%22%3A%22Bort%22%2C%22last_name%22%3A%22%22%2C%22username%22%3A%22bortisbased%22%2C%22language_code%22%3A%22en%22%2C%22allows_write_to_pm%22%3Atrue%2C%22photo_url%22%3A%22https%3A%5C%2F%5C%2Ft.me%5C%2Fi%5C%2Fuserpic%5C%2F320%5C%2FXnIpq1PD6AtBFJadqYLzuj1H5sOsxMSWCWZPa3fskLILPwYTDXDa_Ebt0l9JjRzh.svg%22%7D&auth_date=1785822611&signature=jmi8j5_3UgfF_kFFQmJtPeyHpENOD3vJ2hHimyrNndysQ_VzFwKAJltsy-SZbbzb2nPIgOjNiRp4umvITkh7Bg&hash=cbc59b853ee72a037f02587f950f24923cd87824327e85d69806061e08d6add3"

Request info

URI:: http://mayor.tendy.zone:80/auth/telegram

Query string:

Headers

accept: */*

accept-encoding: gzip, br

accept-language: en,en-US;q=0.9

cdn-loop: cloudflare; loops=1

cf-connecting-ip: 2601:1c2:1c82:c50:b510:43e3:34a:5349

cf-ipcountry: US

cf-ray: a25b49d4b929ccd1-PDX

cf-visitor: {"scheme":"https"}

connection: upgrade

content-length: 586

content-type: application/json

cookie: _ga=GA1.1.1089340904.1785766980; _mayor_game_key=SFMyNTY.g3QAAAABbQAAAAtfY3NyZl90b2tlbm0AAAAYY3UwVVk1ZVpxdDh1OWk3Wm9UNENDeXFP.vrHM-13uDgabK8wM4f5pv6FgLT95O8hY8NR65ur_B48; _ga_XJE5DTH2CE=GS2.1.s1785818654$o3$g1$t1785818899$j60$l0$h0

host: mayor.tendy.zone

origin: https://mayor.tendy.zone

priority: u=1, i

referer: https://mayor.tendy.zone/auth/telegram

sec-ch-ua: "Not;A=Brand";v="8", "Chromium";v="150", "Android WebView";v="150"

sec-ch-ua-mobile: ?1

sec-ch-ua-platform: "Android"

sec-fetch-dest: empty

sec-fetch-mode: cors

sec-fetch-site: same-origin

user-agent: Mozilla/5.0 (Linux; Android 12; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.7871.181 Mobile Safari/537.36 Telegram-Android/12.9.1 (Tcl T767W; Android 12; SDK 31; AVERAGE)

x-csrf-token: AmIGZioKbH8cHAN3IAgxEzx-OTQbEwUiV8h7Ri65_dFEslPpy8SulwNQ

x-forwarded-for: 2601:1c2:1c82:c50:b510:43e3:34a:5349, 104.23.160.175

x-forwarded-proto: https

x-real-ip: 104.23.160.175

x-requested-with: org.telegram.messenger.web

Session

_csrf_token

"cu0UY5eZqt8u9i7ZoT4CCyqO"