i am following along with the Phoenix Up & Running guide at https://phoenixframework.readme.io/docs/up-and-running and when I try to use ecto to create a database (Postgresql) I get the following error $ mix ecto.create 17:55:35.631 [error] GenServer pid <0.215.0> terminating ** (RuntimeError) C…

As I said already, the best is to ditch the guide you follow, and remove the empty project you have so far. Then you mix archive.uninstall phoenix_new, as that is deprecated and only creates outdated project skeletons. Then you start again by following the new guide , updating all those dependencies…

Thanks. I had to google to find how to update that setting and it seems to be a common question. Based on another ElixirForum answer I updated config.exs thus > # This file is responsible for configuring your application > # and its dependencies with the aid of the Mix.Config module. > # > # This…

I don’t know exactly what is going on but postgrex seems to be failing parsing a version, I expect the database’s… You’re on PostgreSQL 11.7 which is from Feb 2020, but your postgrex is very old: v0.12.2 was released in Sep 2016. Try updating your postgrex library version, the latest is v0.15.3. m…

$ mix deps.unlock postgrex $ mix deps.update postgrex warning: found quoted keyword "test" but the quotes are not required. Note that keywords are always atoms, even when quoted. Similar to atoms, keywords made exclusively of Unicode letters, numbers, underscore, and @ do not require quotes mix.ex…

Can you show your deps in mix.exs? Most likely, postgrex is pinned to a specific version. If that’s the case, you can change the version pinning to something like ~> 0.15.

defp deps do [{:phoenix, "~> 1.2.5"}, {:phoenix_pubsub, "~> 1.0"}, {:phoenix_ecto, "~> 3.0"}, {:postgrex, ">= 0.0.0"}, {:phoenix_html, "~> 2.6"}, {:phoenix_live_reload, "~> 1.0", only: :dev}, {:gettext, "~> 0.11"}, {:cowboy, "~> 1.0"}] end this is the defa…

Because there is a lot more of dated dependencies, probably something puts a constraint on postgrex that makes it unable to update. If you put {:postgrex, "~> 0.13"} in your mix.exs and then mix do deps.unlock postgrex, deps.update postgrex again, it will tell you where constraints are comming from…

ok thank you but I did not put that. this is the default mix.exs file. but what you say makes sense. here is the result Resolving Hex dependencies... Failed to use "db_connection" because ecto (version 2.0.6) requires ~> 1.0 postgrex (versions 0.14.0 to 0.14.3) requires ~> 2.0 mix.lock sp…

sorry i did not read the 3rd PS. I will do that and follow the new guide on hexdocs. thanks again. $ mix archive.uninstall phoenix_new Are you sure you want to uninstall /home/max/.mix/archives/phoenix_new? [Yn] Y Done! UPDATE: I followed the Install instructions and Up and Running at hexdocs.p…

Elixir Programming Language Forum

Ecto.create failure

Questions & Help Questions

benwilson512 March 9, 2020, 11:37am 2

Try setting show_sensitive_data_on_connection_error: true in the config block for your repo.