MySQL Error: Unknown column 'mempools.mempool_desc' in 'where clause'

Help
1

librenms.log is filled with errors like this

    2017-10-11 08:25:03 MySQL Error: Unknown column 'mempools.mempool_desc' in 'where clause' (SELECT * FROM devices,mempools WHERE (( mempools.device_id = devices.device_id ) && devices.device_id = '144') && (((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"  &&  mempools.mempool_perc >= "90"  &&  mempools.mempool_desc = "Virtual.*"   ))

====================================

Component Version
LibreNMS 1.32-26-g3381b40
DB Schema 210
PHP 5.4.16
MySQL 5.5.50-MariaDB
RRDTool 1.4.8
SNMP NET-SNMP 5.7.2

====================================

[OK] Database connection successful
[OK] Database schema correct

1 Like
2

A post was merged into an existing topic: Report database schema issues here

4

Looks like you’ve got a bad alert rule. %mempools.mempool_desc when it should be %mempools.mempool_descr

1 Like
6

Thanks laf … I wouldn’t have noticed

1 Like