View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
1699RackTablesdefaultpublic2016-10-26 20:112016-10-26 22:32
Reportertotake Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version0.20.11 
Summary1699: Clicking on row causes exception
DescriptionWhen 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
TagsNo tags attached.

Relationships

duplicate of 1635 closedinfrastation Pdo exception: PDOException 

Activities

There are no notes attached to this issue.

Issue History

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