SQLite3::SQLException: ambiguous column name how to fix the problem?

Question

Ruby on Rails

I know that when join there is a name conflict, however
I have a skope in which
the controller is being searched

tasks=Task.initiator_filter(params[:initiator_name])

this is a model

scope :initiator_filter, ->(name){ joins(:initiator).where("users.name LIKE ?", "%{name}%")}

The error message is clear, name conflict.

SQLite3::SQLException: ambiguous column name: id: SELECT "tasks".* FROM "tasks" INNER JOIN "users" ON "users"."id" = "tasks"."initiator_id" WHERE (users.name LIKE '% fdghfgfd%') AND (id IN (NULL))

However, I don't understand where this code snippet comes from.

(id IN (NULL)

to fix it, only the code in the controller above is called.
Sincerely, your fool

Answer 1

Go to the console and enter
Next, if the request is normal, then the problem is somewhere in your controller, view or model code (before_action, default_scope, etc.).