Hi,
I'm not sure if my DB has become corrupted over time however, I am trying to configure a few alert checks and hitting these errors:
[2016/11/29 18:34:14 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '6' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND `ifType` = 'ethernetCsmacd'
in the logs/db.log file.
Do I need to create the columns that it is asking for or is there something else that needs to be done?
Thanks.
Kaya