In systemctl status : CMDPHP: ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list' about plugin_flowview HOT 5 CLOSED

Latest commit aabe379

Can also see Undefined variable: path in /var/www/html/cacti/plugins/flowview/service/flow-capture on line 55 But I think that's not used anymore and should not affect ?

Also in cacti log :

2020/01/30 14:20:57 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[331]:process_fv5(), /plugins/flowview/flow_collector.php[439]:db_execute(), /lib/database.php[191]:db_execute_prepared())

2020/01/30 14:20:57 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list'
2020/01/30 14:20:57 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[331]:process_fv5(), /plugins/flowview/flow_collector.php[396]:CactiErrorHandler())
2020/01/30 14:20:57 - ERROR PHP WARNING in Plugin 'flowview': Division by zero in file: /var/www/html/cacti/plugins/flowview/flow_collector.php on line: 396

from plugin_flowview.

Okay, I'm fixing a few of these. I'm not sure about the INF column missing. I'm guessing you are getting more than flow data coming into the port. Maybe we need to verify that it's actually flow data.

from plugin_flowview.

Thanks,

these errors are gone now.

• receiving v5 flows in the database now.
• v9 I get sql errors. but have to make sure it is not my side first.

from plugin_flowview.

I've corrected the data collector. I added a few cacti_log messages. Look for them, and report any new findings.

from plugin_flowview.

I have not seen anything in the log referencing this after your update.

from plugin_flowview.