[Ntop] Missing table after update - flows_alerts

[Roberto Alvarado]

Hi Folks,

Today after update ntopng I got his errors on the ntopng log:

18/Oct/2017 09:17:14 [AlertsManager.cpp:814] ERROR: SQL Error: step [INSERT INTO flows_alerts (alert_tstamp, alert_type, alert_severity, alert_json, vlan_id, proto, l7_proto, first_switched, last_switched, cli_country, srv_country, cli_os, srv_os, cli_asn, srv_asn, cli_addr, srv_addr, cli_port, srv_port, cli2srv_bytes, srv2cli_bytes, cli2srv_packets, srv2cli_packets, cli2srv_tcpflags, srv2cli_tcpflags, cli_blacklisted, srv_blacklisted, cli_localhost, srv_localhost) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); ][SQL logic error or missing database]

A lots of this lines per second…

But if I check the database:

MariaDB [ntop]> show tables;
+----------------+
| Tables_in_ntop |
+----------------+
| aggrflowsv4 |
| aggrflowsv6 |
| flowsv4 |
| flowsv6 |
+----------------+
4 rows in set (0.00 sec)

MariaDB [ntop]>


The table “flows_alerts” isnt there…

Ntopng version:

***@mhost:/var/log/ntopng# ntopng -V
v.3.1.171018 [Enterprise/Professional build]
GIT rev: dev:5809e7500a6d61c2e2caa56440ba8d3f3e160fb6:20171018
Pro rev: r1196
Built on: Debian GNU/Linux 8.2 (jessie)
System Id: {REMOVED}
Platform: x86_64
Edition: Professional
License Type: Permanent
Maintenance: Until Thu Mar 22 12:28:01 2018 [155 days left]
License: {REMOVED}
***@mhost:/var/log/ntopng#


Can you share with me the create statement for the missing table?


Thanks
Regards
Roberto