View Issue Details

IDProjectCategoryView StatusLast Update
0001683RackTables802.1Q VLANspublic2016-09-05 11:05
ReporterOricAssigned Toinfrastation 
Status closedResolutionfixed 
PlatformLinuxOSUbuntuOS Version16.04
Product Version0.20.11 
Target Version0.20.12Fixed in Version0.20.12 
Summary0001683: 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( FROM VLANDomain vd WHERE vd.group_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:

    [0] => 42S02
    [1] => 1146
    [2] => Table 'racktables.VLANSwitch' doesn't exist


page 8021q


PHPSESSID ghrka9lep3rp769bbhi492n9f5
TagsNo tags attached.




2016-09-05 10:49


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


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