nicolaslopezj/searchable

Exception when I want to paginate

Open

#42 opened on Apr 16, 2015

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

Description

Hi,

I have a problem when I want to paginate search. Laravel returns

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'relevance' in 'having clause' (SQL: select count(*) as aggregate from `posts` group by `posts`.`id` having relevance > 5.25)

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.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
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.
mostly clear
Prerequisites
Laravel basicsSQL knowledge
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
The error shows a missing 'relevance' column in a HAVING clause. Investigate the package's query building logic in the trait (likely SearchableTrait.php) to see how the 'relevance' column is added or aliased. Check if pagination triggers a different query path that omits the alias. Look at recent comments or related issues for hints.