Eager loading many-to-many relationships fails on model2 and succeed on model1

[saberhosneydev]

I made a many-to-many relationship between Agent and Badge models, tried to access the relation with the following code

// Works fine
$agent = Agent::get()->first();
$agent->load('badges');
dd($agent->badges);

// Doesn't work at all, doesnt matter what I do, it gives me "Call to a member function addEagerConstraints() on null."
$badge= Badge::get()->first();
$badge->load('agents');
dd($badge->agents);

// App\Models\Agent.php
class Agent extends Model
{
   // other model properties
    public function user()
    {
        return $this->morphOne(User::class, 'account');
    }

    public function badges()
    {
        return $this->belongsToMany(Badge::class);
    }
}
// App\Models\Badge.php
class Badge extends Model
{
   // other model properties
    public function agents()
    {
        $this->belongsToMany(Agent::class);
    }
}

and finally the migration

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration {
    public function up(): void
    {
        Schema::create('agent_badge', function (Blueprint $table) {
            $table->id();
            $table->bigInteger('badge_id');
            $table->bigInteger('agent_id');
            $table->timestamps();
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('badge_user');
    }
};

[henzeb]

I think it the first works because you have agent_badge, but the second does not because you don't have badge_agent. You should add the table name.

[saberhosneydev]

Actually according to their documentation it doesn't matter, because it always resolves the table name alphabetically so it will always try to load a table called "agent_badge". anyways I found the problem, that "agents" method didn't have a return keyword in the start,
Human error after all 😢