Running ecto 3.6.2 and in seeds.exs I’m simply updating every mediaitem with a timestamp and when ecto does the SELECT, it selects a non-existent column channels_id:
# set all seeded mediaitems to be publishable
FaithfulWord.Repo.all(from m in MediaItem)
|> Enum.map(fn mediaitem ->
mediaitem
|> change(published_at: DateTime.utc_now())
|> Repo.update()
end)
error ("* (Postgrex.Error) ERROR 42703 (undefined_column) column m0.channels_id does not exist"):
[debug] QUERY ERROR source="mediaitems" db=0.0ms queue=10.1ms idle=14.9ms
SELECT m0."id", m0."comment", m0."description", m0."dislike_count", m0."size_bytes", m0."filepath", m0."height", m0."like_count", m0."tags", m0."title", m0."filename_hash", m0."upload_date", m0."artist", m0."view_count", m0."webpage_url", m0."width", m0."media_format", m0."skylink_id", m0."language_id", m0."localizedname", m0."ordinal", m0."cdn_path", m0."presenter_name", m0."presented_at", m0."source_material", m0."track_number", m0."media_category", m0."playlist_id", m0."org_id", m0."owner_id", m0."published_at", m0."readable_id", m0."duration", m0."channels_id", m0."playlists_id", m0."inserted_at", m0."updated_at" FROM "mediaitems" AS m0 []
** (Postgrex.Error) ERROR 42703 (undefined_column) column m0.channels_id does not exist
query: SELECT m0."id", m0."comment", m0."description", m0."dislike_count", m0."size_bytes", m0."filepath", m0."height", m0."like_count", m0."tags", m0."title", m0."filename_hash", m0."upload_date", m0."artist", m0."view_count", m0."webpage_url", m0."width", m0."media_format", m0."skylink_id", m0."language_id", m0."localizedname", m0."ordinal", m0."cdn_path", m0."presenter_name", m0."presented_at", m0."source_material", m0."track_number", m0."media_category", m0."playlist_id", m0."org_id", m0."owner_id", m0."published_at", m0."readable_id", m0."duration", m0."channels_id", m0."playlists_id", m0."inserted_at", m0."updated_at" FROM "mediaitems" AS m0
hint: Perhaps you meant to reference the column "m0.channel_id".
(ecto_sql 3.6.2) lib/ecto/adapters/sql.ex:760: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql 3.6.2) lib/ecto/adapters/sql.ex:693: Ecto.Adapters.SQL.execute/5
(ecto 3.6.2) lib/ecto/repo/queryable.ex:224: Ecto.Repo.Queryable.execute/4
(ecto 3.6.2) lib/ecto/repo/queryable.ex:19: Ecto.Repo.Queryable.all/3
priv/repo/seeds.exs:105: (file)
(elixir 1.11.1) lib/code.ex:931: Code.require_file/2
(mix 1.11.1) lib/mix/tasks/run.ex:146: Mix.Tasks.Run.run/5
(mix 1.11.1) lib/mix/tasks/run.ex:86: Mix.Tasks.Run.run/1
(mix 1.11.1) lib/mix/task.ex:394: Mix.Task.run_task/3
(mix 1.11.1) lib/mix/cli.ex:84: Mix.CLI.run_task/2
(elixir 1.11.1) lib/code.ex:931: Code.require_file/2
This was after I added a new column to MediaItem that I call channel_id:
defmodule FaithfulWord.Schema.MediaItem do
use Ecto.Schema
import Ecto.Changeset
...
@primary_key {:id, :binary_id, autogenerate: true}
@foreign_key_type :binary_id
schema "mediaitems" do
...
field :playlist_id, :binary_id
field :channel_id, :binary_id
...
belongs_to :channels, FaithfulWord.Schema.Channel
belongs_to :playlists, FaithfulWord.Schema.Playlist
timestamps(type: :utc_datetime_usec)
end
...
migration:
defmodule FaithfulWord.Repo.Migrations.CreateMediaItems do
use Ecto.Migration
def change do
create table(:mediaitems, primary_key: false) do
add :id, :binary_id, primary_key: true
...
add :org_id, references(:orgs, on_delete: :delete_all, type: :binary_id)
add :owner_id, references(:users, on_delete: :delete_all, type: :binary_id)
add :channel_id, references(:channels, on_delete: :delete_all, type: :binary_id)
add :playlist_id, references(:playlists, on_delete: :delete_all, type: :binary_id) timestamps(type: :utc_datetime_usec)
...
end
...
Any idea ecto seems to add a pluralized version(“channels_id”) of the actual column(“channel_id”)? Is there a workaround?
Michael
