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.