View Issue Details

IDProjectCategoryView StatusLast Update
446RackTablesdefaultpublic2011-07-01 12:08
Reporteruser221Assigned Toandriyanov  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version0.19.5 
Target Version0.19.6Fixed in Version0.19.6 
Summary446: Port List Filter Dies On "Show Ports"
Descriptionfunction 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 InformationPdo 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
TagsNo tags attached.

Activities

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
 ";
popup-rackobject-sql.patch (412 bytes)   

Issue History

Date Modified Username Field Change
2011-07-01 01:21 user221 New Issue
2011-07-01 01:21 user221 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