Hi all,
After a clean new installation i get the errors below, if i click on a created
Row:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT
list is not in GROUP BY clause and contains nonaggregated column 'Location.id'
which is not functionally dependent on columns in GROUP BY clause; this is
incompatible with sql_mode=only_full_group_by (42000)
at file /usr/local/share/RackTables/wwwroot/inc/database.php, line 4058
/usr/local/share/RackTables/wwwroot/inc/database.php:4058 execute(Array
(
[0] => 2
)
)
/usr/local/share/RackTables/wwwroot/inc/database.php:287
usePreparedSelectBlade('SELECT Row.id AS id, Row.name AS name, COUNT(Rack.id)
AS count, IF(ISNULL(SUM(Rack.height)),0,SUM(Rack.height)) AS sum, Location.id
AS location_id, Location.name AS location FROM Row LEFT JOIN Rack ON
Rack.row_id = Row.id LEFT OUTER JOIN Location ON Row.location_id = Location.id
WHERE Row.id = ? GROUP BY Row.id', Array
(
[0] => 2
)
)
/usr/local/share/RackTables/wwwroot/inc/interface.php:682 getRowInfo('2')
/usr/local/share/RackTables/wwwroot/index.php:35 renderRow('2')
Error info:
Array
(
[0] => 42000
[1] => 1055
[2] => Expression #5 of SELECT list is not in GROUP BY clause and contains
nonaggregated column 'Location.id' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by
)
Parameters:
GET
page row
row_id 2
POST
COOKIE
PHPSESSID 6gl692ufcb740e3l36lvv91un7
[http://assystem.de/mb.jpg]