Problem with Ecto prefix: usage

Can you post Ecto version info from your mix.exs file?
and mysql library as well.

You need to wrap the parameters you’re getting by in a list instead of using the last arg syntax sugar:

Repo.get_by(Ticket, [ticket: ticket_params[:ticket]], prefix: "other_db")

What you have is being interpreted as:

Repo.get_by(Ticket, [ticket: ticket_params[:ticket], prefix: "other_db"])

ah..right.. so the 2nd param is a Keyword. so prefix: “other_db” is just another element in the 2nd param Keyword List.

I’ll give it a shot - what you are saying makes sense to me.

I’ve made the code changes but I can’t test it until tomorrow because my ‘process’ has already been run for today so my code won’t attempt to do anything.

I’ll let everyone know tomorrow (7 Mar 2019), if it worked or not.

      {:phoenix_ecto, "~> 3.2"},
      {:mariaex, ">= 0.0.0"},

I created another server and in the process was able to run my changed code.

Bracketing the query parameters as suggested by benwilson512 worked a treat!!

Thanks.