语法错误或访问冲突:group by中的1055表达式#17 [英] Syntax error or access violation: 1055 Expression #17 in group by
问题描述
我在laravel 5.3中使用group尝试查询.我抓到
I tried a query using group in laravel 5.3.I caught
SQLSTATE [42000]:语法错误或访问冲突:1055 SELECT列表的表达式#17不在GROUP BY子句中,并且包含未聚合的列"testtravel.country.name",该列在功能上不依赖于GROUP BY子句中的列;这与sql_mode = only_full_group_by(SQL:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'testtravel.country.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL:
select `travel_request`.*, `travel_request`.`id` as `travel_id`,
`department`.`name` as `dept_name`, `users`.`firstname` as `approver_name`,
`travel_purpose`.`purpose`, `country`.`name` as `country_name`,
`traveling_details`.`from_date`, `traveling_details`.`to_date`,
`travel_request_status`.`status`
from `travel_request`
inner join `department` ON `travel_request`.`department_id` = `department`.`id`
inner join `users` ON `travel_request`.`approver_id` = `users`.`id`
inner join `travel_purpose` ON `travel_request`.`travel_purpose_id` = `travel_purpose`.`id`
inner join `traveling_details` ON `travel_request`.`id` = `traveling_details`.`travel_request_id`
inner join `country` ON `country`.`id` = `traveling_details`.`country_id`
inner join `travel_request_status` ON `travel_request`.`status_id` = `travel_request_status`.`id`
where `travel_request`.`approver_id` = 187
and `travel_request`.`status_id` != 4
group by `travel_request`.`id`
limit 2 offset 0)
我复制了查询并在sql中运行.它在mysql中运行良好.我尝试过
I copied the query and run in sql.Its is working well in mysql.I tried as
$users = DB::table('travel_request')
->join('department', 'travel_request.department_id', '=', 'department.id')
->join('users', 'travel_request.approver_id', '=', 'users.id')
->join('travel_purpose', 'travel_request.travel_purpose_id', '=', 'travel_purpose.id')
->join('traveling_details', 'travel_request.id','=','traveling_details.travel_request_id' )
->join('country','country.id', '=', 'traveling_details.country_id')
->join('travel_request_status','travel_request.status_id', '=', 'travel_request_status.id')
->select('travel_request.*', 'travel_request.id as travel_id','department.name as dept_name','users.firstname as approver_name','travel_purpose.purpose','country.name as country_name','traveling_details.from_date','traveling_details.to_date','travel_request_status.status')->where('travel_request.approver_id', $user_id)->where('travel_request.status_id','!=','4')->GROUPBY ('travel_request.id')->paginate(2);
解决了
但是要禁用此功能,只需转到config/database.php并更改严格标志
However to disabled this just go to config/database.php and change strict flag
'mysql' => [
.
.
.
'strict' => false,
//'strict' => true,
.
.
],
推荐答案
打开您的config/database.php
文件并按以下方式更改mysql
配置数组:
Open your config/database.php
file and change mysql
configuration array as following:
来自'strict' => true
到'strict' => false
请务必阅读答案以获取有关该错误的更多信息.
Do read this answer for more information about the error.
这篇关于语法错误或访问冲突:group by中的1055表达式#17的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!