Laravel whereMorph query not working in laravel-10

Question


$table->unsignedBigInteger('creater_id')->nullable();
$table->string('creater_type')->nullable();
$table->unsignedBigInteger('updater_id')->nullable();
$table->string('updater_type')->nullable();
$table->unsignedBigInteger('deleter_id')->nullable();
$table->string('deleter_type')->nullable();

public function creater()
{
    return $this->morphTo();
}
public function updater()
{
    return $this->morphTo();
}
public function deleter()
{
    return $this->morphTo();
}


function dm(){
    return auth()->guard('dm')->user();
}

public function index(): View
    {
        $data['lams'] = LocalAreaManager::with('creater')->whereMorph('creater_type', get_class(dm()), 'creater_id')->latest()->get();
        return view('district_manager.lam_management.index', $data);
    }

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'morph' in 'where clause'

Give me an error :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'morph' in 'where clause'

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Feb 6, 2024 at 10:46

mzeng zahmatkesh · Accepted Answer · 2024-02-05 08:53:14Z

0

i think you must use creatable and updatable and deletable instead creater and updater and deleter in your Model

for example in laravel documentation :

public function imageable(): MorphTo
{
    return $this->morphTo();
}

answered Feb 5, 2024 at 8:53

mzeng zahmatkesh

12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel whereMorph query not working in laravel-10

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related