I have an 500 error when my user changes UUID which is relation to Category UUID for inserting post. ** (exit) an exception was raised: ** (Ecto.ChangeError) value `"a863228-727c-4cf3-93f5-9b2f79df1288"` for `TrangellCmsService.Cms.Db.Post.cms_post_category_id` in `insert` does not match type :…

I use umbrella project, my controller in Phoenix, def create_cms_post(conn, %{"title" => _title, "status" => _status, "post_type" => _post_type, "download_ext_link" => _download_ext_link, "price" => _price, "pic_x1_link" => _pic_x1_link, "pic_x2_link" => _pic_x2_link, "pic_x3_link" => _pic_x3_li…

Is the field actually part of @all_fields? The custome type should validate the format during cast or am I missunderstanding the custom type stuff? And how does the schema looks like?

[image] shahryarjb: “cms_post_category_id” => _cms_post_category_id is in the controller params, so :cms_post_category_id is in @all_fields probably, otherwise I don’t see how it gets into the changeset. Maybe do |> foreign_key_constraint(:cms_post_category_id) only if the changeset is valid…

[image] NobbZ: Is the field actually part of @all_fields ? The custome type should validate the format during cast or am I missunderstanding the custom type stuff? And how does the schema looks like? @NobbZ , my schema is : schema.ex · GitHub My user who is admin in my web service have to …

If I’m not mistaken, a :binary_id cannot be validated during the changeset process because it can be a different actual type based on the database that you are using. For example, Postgres will use Ecto.UUID as it’s :binary_id type. Whereas mongo will use a BSON.ObjectId. Edit This unfortunately l…

Humm.. then , how can I validate UUID , do I have a way for this?

https://github.com/elixir-ecto/ecto/blob/ad8d474d09a4b12bca2145a75491f6210ce8d099/lib/ecto/repo/schema.ex#L785-L794 It can be probably checked on per adapter basis, so postgrex would check for uuid. So @shahryarjb you should try adding a check for it before the actual dumping which I suppose happen…

I have heard not to use raise in my project, because it is a time bomb.

It most certainly could. I just meant that you cannot do it from Ecto.Changeset.cast/4 alone because it does not know which adapter you are going to be using. A schema is not attached to an adapter.

I have heard not to use raise in my project, because it is a time bomb. I actually use raise quite often (“fail fast” and all that). I wouldn’t call it a time bomb …

Elixir Programming Language Forum

How to stop 500 errors when UUID doesn't match

Questions & Help Questions

rameramwe January 3, 2022, 10:13am 30

Thanks!