Illuminate\Database\QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column in

        // message to include the bindings with SQL, which will make this exception a

        // lot more helpful to the developer instead of just the database's errors.

        catch (Exception $e) {

            throw new QueryException(

                $query, $this->prepareBindings($bindings), $e

            );

Solution

I was using eloquent Were to get a user role by doing whereRoleId, but instead I mistakenly had it written with a capital ID which wasn't supposed to be so as it didn't match the table column name.