Skip to content
Advertisement

Unknown column “has” in ‘where clause

I am using laravel 5.7

When I use whereHas to check a relation’s existence, I face with Unknown column "has" in 'where clause Error! Why?

this is my code:

$query->whereHas('departures', function ( $query) {
    $query->whereBetween('depart_date', [date($this->data['departFrom_date']), date($this->data['departTo_date'])]);
});

and this is my model part:

    public function departures()
    {
        return $this->hasMany(CruiseSailingDepartures::class);
    }

Update:

The query was started with:

$query = DB::table('table_name');

Advertisement

Answer

I have found my problem, I was using DB::table('tablename') instead of using the Model (TableName:: ...)

Thanks for all answers

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement