UPDATED...
Hello there. Hopefully, you are doing well.
Is anyone faced with this (Exception: SQLSTATE[22P02]) exception?
It is a full error message:
Whoops! An error occurred.
Exception: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "" (SQL: select "cars".*, "makes"."xdo"->>'make' as "make", "models"."xdo"->>'model' as "models", "body"."xdo"->>'body' as "bodyy", "body"."xdo"->>'description' as "body_description" from "mvpw52385_345024" as "cars" left join "mvpw52385_344985" as "makes" on ("cars"."xdo"->>'make_id')::uuid = "makes"."id" left join "mvpw52385_345025" as "models" on ("cars"."xdo"->>'model_id')::uuid = "models"."id" left join "mvpw52385_348021" as "body" on ("cars"."xdo"->>'body_id')::uuid = "body"."id" where ("cars"."xdo"->>'users_id')::uuid = '79512a07-c141-4e76-a916-4dfad1eb96c1')
So, this error happens only with my own user_id. Other users don't get this error. I created a new user_id, copied all my relational data, and pasted it to the new user_id. Now the new user_id has the same issue. It's so strange. I am confused already.
How do I solve it? Please share your thoughts.
Thanks in advance.