View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
446 | RackTables | default | public | 2011-07-01 01:21 | 2011-07-01 12:08 |
Reporter | Assigned To | andriyanov | |||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 0.19.5 | ||||
Target Version | 0.19.6 | Fixed in Version | 0.19.6 | ||
Summary | 446: Port List Filter Dies On "Show Ports" | ||||
Description | function findSparePorts() in pop.php on line 48 the SQL 'INNER JOIN Object o ON o.id = p.object_id' needs to be 'INNER JOIN RackObject o ON o.id = p.object_id' | ||||
Additional Information | Pdo exception: PDOException SQLSTATE[42S02]: Base table or view not found: 1146 Table 'racktables.Object' doesn't exist (42S02) at file /usr/local/share/racktables/wwwroot/inc/database.php, line 2732 /usr/local/share/racktables/wwwroot/inc/database.php:2732 execute(Array ( [0] => 24 [1] => 24 [2] => 74 [3] => %wn-srv% ) ) /usr/local/share/racktables/wwwroot/inc/popup.php:113 usePreparedSelectBlade(' SELECT p.id, p.name, p.reservation_comment, p.iif_id, p.type as oif_id, pii.iif_name, d.dict_value as oif_name, p.object_id, o.name as object_name FROM Port p INNER JOIN Object o ON o.id = p.object_id INNER JOIN PortInnerInterface pii ON p.iif_id = pii.id INNER JOIN Dictionary d ON d.dict_key = p.type INNER JOIN ( SELECT Port.id FROM Port INNER JOIN ( SELECT DISTINCT pic2.iif_id FROM PortInterfaceCompat pic2 INNER JOIN PortCompat pc ON pc.type2 = pic2.oif_id WHERE pc.type1 = ? AND pic2.iif_id <> 1 ) AS sub1 USING (iif_id) UNION SELECT Port.id FROM Port INNER JOIN PortCompat ON type1 = type WHERE iif_id = 1 and type2 = ? ) AS sub2 ON sub2.id = p.id WHERE p.id <> ? AND p.id NOT IN (SELECT porta FROM Link) AND p.id NOT IN (SELECT portb FROM Link) AND o.name like ? ORDER BY o.name', Array ( [0] => 24 [1] => 24 [2] => 74 [3] => %wn-srv% ) ) /usr/local/share/racktables/wwwroot/inc/popup.php:378 findSparePorts(Array ( [id] => 74 [object_id] => 1 [name] => Gi1/0/1 [iif_id] => 1 [oif_id] => 24 [l2address] => [reservation_comment] => [object_name] => wn-srv-s1-1 [oif_name] => 1000Base-T [linked] => 0 [iif_name] => hardwired ) , Array ( [racks] => Array ( ) [objects] => wn-srv [ports] => ) ) : renderPopupPortSelector() /usr/local/share/racktables/wwwroot/inc/functions.php:4618 call_user_func_array('renderPopupPortSelector', Array ( ) ) /usr/local/share/racktables/wwwroot/inc/popup.php:456 getOutputOf('renderPopupPortSelector') /usr/local/share/racktables/wwwroot/index.php:193 renderPopupHTML() Error info: Array ( [0] => 42S02 [1] => 1146 [2] => Table 'racktables.Object' doesn't exist ) Parameters: GET module popup helper portlist port 74 filter-obj wn-srv filter-port | ||||
Tags | No tags attached. | ||||
2011-07-01 01:21
|
popup-rackobject-sql.patch (412 bytes)
Index: popup.php =================================================================== --- popup.php (revision 4633) +++ popup.php (working copy) @@ -45,7 +45,7 @@ p.object_id, o.name as object_name FROM Port p -INNER JOIN Object o ON o.id = p.object_id +INNER JOIN RackObject o ON o.id = p.object_id INNER JOIN PortInnerInterface pii ON p.iif_id = pii.id INNER JOIN Dictionary d ON d.dict_key = p.type "; |
Date Modified | Username | Field | Change |
---|---|---|---|
2011-07-01 01:21 |
|
New Issue | |
2011-07-01 01:21 |
|
File Added: popup-rackobject-sql.patch | |
2011-07-01 12:08 | infrastation | Assigned To | => andriyanov |
2011-07-01 12:08 | infrastation | Status | new => closed |
2011-07-01 12:08 | infrastation | Resolution | open => fixed |
2011-07-01 12:08 | infrastation | Fixed in Version | => 0.19.6 |
2011-07-01 12:08 | infrastation | Target Version | => 0.19.6 |