nicolaslopezj/searchable

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

Open

#39 建立於 2015年4月14日

在 GitHub 查看
 (5 留言) (0 反應) (0 負責人)PHP (1,999 star) (292 fork)user submission
bughelp wanted

描述

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)

貢獻者指南

技術棧
phplaravelsql
領域
backenddatabase
議題類型
bug
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
2
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-3 hours
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Basic PHPLaravel EloquentMySQL knowledge
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
50
研究方向
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.
Column not found: 1054 Unknown column 'relevance' in 'having clause' · nicolaslopezj/searchable#39 | Good First Issue