On 29/11/2016 23:01:18, Kaya Saman <kayasaman@gmail.com> wrote:
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
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium