View Issue Details

IDProjectCategoryView StatusLast Update
1683RackTables802.1Q VLANspublic2016-09-05 11:05
ReporterOric Assigned Toinfrastation  
PriorityhighSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformLinuxOSUbuntuOS Version16.04
Product Version0.20.11 
Target Version0.20.12Fixed in Version0.20.12 
Summary1683: PDO exception when navigating to 802.1Q tab
DescriptionPDO exception error occurs when attempting to navigate to the 802.1Q tab from the main racktables menu.

This link has never worked from our initial install of racktables
Steps To ReproduceClick 802.1Q link
Additional InformationPdo exception: PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'racktables.VLANSwitch' doesn't exist (42S02)
at file /var/www/racktables/wwwroot/inc/database.php, line 4058

/var/www/racktables/wwwroot/inc/database.php:4058 execute(Array
(
)
)
/var/www/racktables/wwwroot/inc/database.php:5146 usePreparedSelectBlade('SELECT id, group_id, description, (SELECT COUNT(vd.id) FROM VLANDomain vd WHERE vd.group_id = VLANDomain.id) as subdomc, (SELECT COUNT(vlan_id) FROM VLANDescription WHERE domain_id = id) AS vlanc, (SELECT COUNT(ipv4net_id) FROM VLANIPv4 WHERE domain_id = id) AS ipv4netc, (SELECT COUNT(object_id) FROM VLANSwitch WHERE domain_id = id) AS switchc, (SELECT COUNT(port_name) FROM VLANSwitch AS VS INNER JOIN PortVLANMode AS PVM ON VS.object_id = PVM.object_id WHERE domain_id = id) AS portc FROM VLANDomain ORDER BY description')
/var/www/racktables/wwwroot/inc/interface.php:5783 getVLANDomainStats()
/var/www/racktables/wwwroot/index.php:35 render8021QStatus(NULL)
Error info:

Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'racktables.VLANSwitch' doesn't exist
)
Parameters:

GET

page 8021q
POST

COOKIE

PHPSESSID ghrka9lep3rp769bbhi492n9f5
TagsNo tags attached.

Activities

Oric

Oric

2016-09-05 10:49

reporter  

PDO error.jpg (106,979 bytes)   
PDO error.jpg (106,979 bytes)   
infrastation

infrastation

2016-09-05 11:00

administrator   ~0003477

Ubuntu 16.04 does not work with RackTables 0.20.11 and older. Specifically, the installation fails to complete properly and you should have seen the error messages. The error you are seeing is a consequence of the failure to install. The next version of RackTables will have this issue fixed.

Issue History

Date Modified Username Field Change
2016-09-05 10:49 Oric New Issue
2016-09-05 10:49 Oric Status new => assigned
2016-09-05 10:49 Oric Assigned To => infrastation
2016-09-05 10:49 Oric File Added: PDO error.jpg
2016-09-05 11:00 infrastation Note Added: 0003477
2016-09-05 11:05 infrastation Status assigned => closed
2016-09-05 11:05 infrastation Resolution open => fixed
2016-09-05 11:05 infrastation Fixed in Version => 0.20.12
2016-09-05 11:05 infrastation Target Version => 0.20.12