Required help in flowview configuration

[drewyort]

confirmed that the new develop branch is working better now, the service stays up and the flowview logs are cleaner, although not 100% fixed. I really appreciate everyone's help with this!

Here are the remaining errors/logs in the general cacti log file for flowview after enabling and setting up a listener.

2024-05-21 15:06:36 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_process.php[96]:flowview_db_fetch_assoc(), /plugins/flowview/database.php[153]:db_fetch_assoc(), /lib/database.php[707]:db_fetch_assoc_prepared(), /lib/database.php[727]:db_execute_prepared())
2024-05-21 15:06:36 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'enabled' in 'where clause'
2024-05-21 15:06:36 - CMDPHP SQL Backtrace: (/poller.php[941]:api_plugin_hook(),
/lib/plugins.php[95]:api_plugin_run_plugin_hook(), /lib/plugins.php[237]:flowview_poller_bottom(), /plugins/flowview/setup.php[439]:flowview_db_execute(), /plugins/flowview/database.php[69]:db_execute(), /lib/database.php[385]:db_execute_prepared())
2024-05-21 15:06:36 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'time' in 'where clause'

My config.php is set to true; and credentials match my database username/password and cacti as the DB name.

here are some tables now created in the cactidb after getting the latest development branch:
| plugin_flowview_devices |
| plugin_flowview_dnscache |
| plugin_flowview_ports |
| plugin_flowview_queries |
| plugin_flowview_raw_202413608 |
| plugin_flowview_raw_202413609 |
| plugin_flowview_raw_202413610 |
| plugin_flowview_raw_202413611 |
| plugin_flowview_raw_202413612 |
| plugin_flowview_schedules |


There are quite a few raw tables created (128 to be exact, not sure if that is intended or not).

Again, appreciate everyone's feedback and help with this!

[macan]

I guess that you still have any older flowview version which was update incorrectly. Missing column (maybe more) "enabled". Correct plugin_flowview_schedules is:
| plugin_flowview_schedules | CREATE TABLE `plugin_flowview_schedules` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) NOT NULL DEFAULT '',
`enabled` varchar(3) NOT NULL DEFAULT 'on',
`sendinterval` bigint(20) unsigned NOT NULL,
`lastsent` bigint(20) unsigned NOT NULL,
`start` datetime NOT NULL,
`email` text NOT NULL,
`format_file` varchar(128) DEFAULT '',
`query_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `query_id` (`query_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Plugin Flowview - Scheduling for running and emails of saved queries' |

Try to add this column:
alter table plugin_flowview_schedules add `enabled` varchar(3) NOT NULL DEFAULT 'on'

[TheWitness]

We are working on a new release now.