nicolaslopezj/searchable

Column not found: 1054 Unknown column 'relevance' in 'having clause'

Open

#39 opened on Apr 14, 2015

View on GitHub
 (5 comments) (0 reactions) (0 assignees)PHP (1,999 stars) (292 forks)user submission
bughelp wanted

Description

Just installed the trait, did a basic search: php $files = File::search($input['query'])->paginate(10);

First a PDO Exception: PDOException in Connection.php line 288: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause'

QueryException in Connection.php line 620: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause' (SQL: select count(*) as aggregate from filesgroup byfiles.id having relevance > 5.75)

Contributor guide

Tech stack
phplaravelsql
Domain
backenddatabase
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic PHPLaravel EloquentMySQL knowledge
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50
Research direction
The error occurs because the `relevance` column is used in the HAVING clause but is not selected or aliased in the query. Investigate the `searchable` trait's `scopeSearch` method to ensure `relevance` is computed and included in the select statement. Look at the raw SQL generated and compare with the expected query structure.