1725: Creating racks in locations fails due to MYSQL strict settings in Version 5.7

ID	Project	Category	View Status	Date Submitted	Last Update

1725	RackTables	default	public	2017-02-02 21:08	2017-02-06 08:06

Reporter	AASithLord	Assigned To
Priority	normal	Severity	crash	Reproducibility	have not tried
Status	closed	Resolution	duplicate
Platform	Linux	OS	Ubuntu	OS Version	16.10
Product Version	0.20.11

Summary	1725: Creating racks in locations fails due to MYSQL strict settings in Version 5.7
Description	I created locations and when attempting to create a rack in a location, an exception was raised, line 287 of database.php, referencing ONLY_FULL_GROUP_BY SQL mode.
Steps To Reproduce	On a fresh install on Ubuntu 16.10 with PHP7.0, MySQL 5.7, Apache2 2.4.18 Create a location add rack - exception raised
Additional Information	I updated the database.php, line 286: from "GROUP BY Row.id"; to "GROUP BY Row.id, Location.id"; and problem resolved, but this may also be repeated in other locations. See https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by and https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html changed line
Tags	No tags attached.

Date Modified	Username	Field	Change
2017-02-02 21:08	AASithLord	New Issue
2017-02-06 08:06	adoom42	Relationship added	duplicate of 1635
2017-02-06 08:06	adoom42	Status	new => closed
2017-02-06 08:06	adoom42	Resolution	open => duplicate