NetFlow v9 parsing errors and SQL column failures

[somethingwithproof]

Description

Flowview fails to parse NetFlow v9 data correctly, resulting in SQL errors about missing or mismatched columns. The v9 template handling does not properly map all field types, causing INSERT failures when flow records reference fields not present in the database schema.

Symptoms

• SQL errors: column does not exist for v9 flow template fields
• Flowview reports "no data" for v9 sources while v5 sources work correctly
• Errors in Cacti log referencing plugin_flowview_raw table column mismatches

Steps to Reproduce

1. Configure a NetFlow v9 exporter (router/switch)
2. Point it at the Cacti Flowview listener
3. Navigate to Flowview and attempt to view flows
4. Check Cacti log for SQL errors

Expected: v9 flows are parsed and displayed correctly
Actual: SQL column errors, no flow data displayed

Environment

• Cacti versions: reported across 1.2.x releases
• Flowview plugin: multiple versions affected
• NetFlow v9 sources from various vendors (Cisco, etc.)

Forum Reference

Originally reported at https://forums.cacti.net/viewtopic.php?t=60359

Multiple users confirmed v9 parsing failures while v5 works correctly.