lundi 15 juillet 2019

SQLSTATE 42S22 Column not found

I know that i don't have the table in phpmyadmin but the problem is i don't know how to do it right way

The code

    public function DriverRefer($id)
{
    $driver = Driver::find($id);
    $query = ReferralDiscount::where([['referral_driver_id', '=', $id], ['referral_sender_id', '!=', 0]])->latest();
    $referral_details = $query->paginate(25);
    return view('merchant.driver.driver_refer', compact('referral_details', 'driver'));
}

Illuminate \ Database \ QueryException (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'referral_driver_id' in 'where clause' (SQL: select count(*) as aggregate from referral_discounts where (referral_driver_id = 4130 and referral_sender_id != 0)) Previous exceptions SQLSTATE[42S22]: Column not found: 1054 Unknown column 'referral_driver_id' in 'where clause' (42S22)



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire