View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
553RackTablesdefaultpublic2012-05-03 19:362012-05-11 15:20
Reporteruser302Assigned Toadoom42  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Target Version0.20.0Fixed in Version0.20.0 
Summary553: SQL query syntax error
DescriptionMinor SQL query typo. Here's a patch:

$ svn update
At revision 5075.

$ svn diff
Index: wwwroot/inc/database.php
===================================================================
--- wwwroot/inc/database.php (revision 5075)
+++ wwwroot/inc/database.php (working copy)
@@ -1294,7 +1294,7 @@
        // and racks that it is 'Zero-U' mounted in
        $result = usePreparedSelectBlade
        (
- 'SELECT DISTINCT RS.rack_id FROM RackSpace RS LEFT JOIN EntityLink EL ON RS.object_id = EL.parent_entity_id AND EL.parent_entity_type = ?' .
+ 'SELECT DISTINCT RS.rack_id FROM RackSpace RS LEFT JOIN EntityLink EL ON RS.object_id = EL.parent_entity_id AND EL.parent_entity_type = ? ' .
                'WHERE RS.object_id = ? or EL.child_entity_id = ? ' .
                'UNION ' .
                "SELECT parent_entity_id AS rack_id FROM EntityLink where parent_entity_type = 'rack' AND child_entity_type = 'object' AND child_entity_id = ? " .
TagsNo tags attached.

Activities

adoom42

adoom42

2012-05-11 15:20

administrator   ~0000670

Thanks for the notification. It has been fixed in r5082. Note that only trunk was affected, not any released versions.

Issue History

Date Modified Username Field Change
2012-05-03 19:36 user302 New Issue
2012-05-11 15:20 adoom42 Note Added: 0000670
2012-05-11 15:20 adoom42 Assigned To => adoom42
2012-05-11 15:20 adoom42 Status new => closed
2012-05-11 15:20 adoom42 Resolution open => fixed
2012-05-11 15:20 adoom42 Fixed in Version => 0.20.0
2012-05-11 15:20 adoom42 Target Version => 0.20.0