Hello, we are running 17.5.8545 rolling and the Real time traffic graph is not working with the following error: “Can’t get data about port (port id)” regardless of port id.

 

This was previously working for all ports and now is not.

 

 

We are also seeing the following errors in db.log when loading the page with the graph.

 

[2017/05/19 12:54:44 +0100] index.php(3222): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'where clause'), Query: SELECT COUNT(*) FROM `ports` WHERE `pagpGroupIfIndex` = '10114' and `device_id` = '12'

[2017/05/19 12:56:44 +0100] index.php(3222): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'where clause'), Query: SELECT COUNT(*) FROM `ports` WHERE `pagpGroupIfIndex` = '10114' and `device_id` = '12'

[2017/05/19 12:57:44 +0100] index.php(16550): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'field list'), Query: SELECT `pagpGroupIfIndex` FROM `ports`   WHERE `device_id` = '25' GROUP BY `pagpGroupIfIndex`

[2017/05/19 12:57:58 +0100] index.php(3222): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'where clause'), Query: SELECT COUNT(*) FROM `ports` WHERE `pagpGroupIfIndex` = '10114' and `device_id` = '12'

[2017/05/19 13:00:42 +0100] index.php(9137): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'where clause'), Query: SELECT COUNT(*) FROM `ports` WHERE `pagpGroupIfIndex` = '10114' and `device_id` = '12'

[2017/05/19 13:02:56 +0100] index.php(16122): Failed dbQuery (#1054 - Unknown column 'pagpGroupIfIndex' in 'field list'), Query: SELECT `pagpGroupIfIndex` FROM `ports`   WHERE `device_id` = '25' GROUP BY `pagpGroupIfIndex`

 

Some help with fault finding this would be appreciated.

 

Regards

 

 

 

cid:image001.jpg@01CE9215.D39244B0

Richard Wigzell
Networks, Security and Server Specialist
IT Services | University of Oxford

13 Banbury Road, Oxford OX2 6NN


T: 01865 616282
www.it.ox.ac.uk