Tuesday, March 21, 2017

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause'

When im trying to paginate builder from search result:

$users = Searchy::users('name', 'email', 'surname')
            ->query('th')
            ->getQuery()
            /**/;

        $users->paginate(20);
        dd($users);

Im getting this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause' (SQL: select count(*) as aggregate from `users` having `relevance` > 0)

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause'

Does anybody know how to fix it and what actually relevance means?



via Batmannn

Advertisement