View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1683 | RackTables | 802.1Q VLANs | public | 2016-09-05 10:49 | 2016-09-05 11:05 |
Reporter | Oric | Assigned To | infrastation | ||
Priority | high | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Linux | OS | Ubuntu | OS Version | 16.04 |
Product Version | 0.20.11 | ||||
Target Version | 0.20.12 | Fixed in Version | 0.20.12 | ||
Summary | 1683: PDO exception when navigating to 802.1Q tab | ||||
Description | PDO 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 Reproduce | Click 802.1Q link | ||||
Additional Information | Pdo 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 | ||||
Tags | No tags attached. | ||||
|
|
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. | |
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 |