View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1699 | RackTables | default | public | 2016-10-26 20:11 | 2016-10-26 22:32 |
| Reporter | totake | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Product Version | 0.20.11 | ||||
| Summary | 1699: Clicking on row causes exception | ||||
| Description | When clickin gon a row in Rackspace -> Browse or Rackspace -> Manage Rows, receiving the following error: Pdo exception: PDOException 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 /var/www/html/racktables/inc/database.php, line 4058 /var/www/html/racktables/inc/database.php:4058 execute(Array ( [0] => 12 ) ) /var/www/html/racktables/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] => 12 ) ) /var/www/html/racktables/inc/interface.php:682 getRowInfo('12') renderRow('12') /var/www/html/racktables/index.php:35 call_user_func('renderRow', '12') 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 12 POST COOKIE PHPSESSID 9e1ldtk50e8vl0o9uc9kfv3au0 | ||||
| Tags | No tags attached. | ||||
| duplicate of | 1635 | closed | infrastation | Pdo exception: PDOException |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-10-26 20:11 | totake | New Issue | |
| 2016-10-26 22:32 | infrastation | Relationship added | duplicate of 1635 |
| 2016-10-26 22:32 | infrastation | Status | new => closed |
| 2016-10-26 22:32 | infrastation | Resolution | open => duplicate |
