1.2.x - unknown sorting columnt (combaination with plugin reportit)

[xmacan]

Go to management -> Reports Set sorting column (public, state, ...) Go to Reporting tab

In logs will be SQL error:

2024-03-17 16:41:00 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'public' in 'order clause' 2024-03-17 16:40:46 - CMDPHP SQL Backtrace: (/reports_admin.php[166]:reports(), /lib/html_reports.php[1909]:db_fetch_assoc(), /lib/database.php[707]:db_fetch_assoc_prepared(), /lib/database.php[727]:db_execute_prepared()) 2024-03-17 16:40:46 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'last_run' in 'order clause'

[TheWitness]

Up late.

[TheWitness]

Must be a session name.

[TheWitness]

I suspect that ReportIT plugin is using the same settings session variable as Cacti's reports.

The session is $_SESSION['sess_reports'] set in the function call:

validate_store_request_vars($filters, 'sess_reports');

If you can fix this in ReportIT, I would appreciate it.

[xmacan]

Ok, I will fix it

[TheWitness]

@xmacan, Thanks!

[xmacan]

Fixed in reportit plugin, closing