Unable to create report

[lbsou]

Hi!

I'm having an issue trying to get reportit to work with cacti 1.x

I'm using reportit for years on pre-1 cacti releases.

Cacti 1.1.33 Reportit 1.0 (latest version on github)

I can create the template without problem but when I try to create the report, I select the template, hit create and then the page reset to no template selected without creating the report.

I already tried to delete reportit, refetch the latest version and recreate the template.

I activated the debug on :

reports.php reports_admin.php reports_user.php + and the module "Reporting tool for Cacti"

and get no error message in the logs.

Any idea ?

Thanks, LB

[lbsou]

The record get created in the plugins_reportit_reports table...

Here is the export of the record :

"id" "name" "description" "user_id" "template_id" "host_template_id" "data_source_filter" "preset_timespan" "last_run" "runtime" "public" "start_date" "end_date" "ds_description" "rs_def" "sp_def" "sliding" "present" "scheduled" "autorrdlist" "auto_email" "email_subject" "email_body" "email_format" "subhead" "state" "graph_permission" "frequency" "autoarchive" "autoexport" "autoexport_max_records" "autoexport_no_formatting" "1" "BW" "BW" "13" "0" "0" "" "" "0000-00-00 00:00:00" "0" "1" "0000-00-00" "0000-00-00" "" "" "" "0" "0" "" "" "" "" "" "" "" "0" "on" "" "1" "" "0" "on"

But nothing get displayed on the webpage...

[lbsou]

From the debug log, the SQL query that is use to display the report list is :

2018/06/28 10:43:34 - DBCALL DEVEL: SQL Assoc: "SELECT a., b.description AS template_description, c.ds_cnt, d.username, b.locked, a.state FROM plugin_reportit_reports AS a LEFT JOIN plugin_reportit_templates AS b ON b.id = a.template_id LEFT JOIN (SELECT report_id, count() as ds_cnt FROM plugin_reportit_data_items GROUP BY report_id) AS c ON c.report_id = a.id LEFT JOIN user_auth AS d ON d.id = a.user_id WHERE a.description LIKE '%' ORDER BY name ASC LIMIT 150,50"

The "ASC LIMIT 150,50" prevent the record to get displayed

If i choose to display 5000 records :

2018/06/28 10:54:26 - DBCALL DEVEL: SQL Assoc: "SELECT a., b.description AS template_description, c.ds_cnt, d.username, b.locked, a.state FROM plugin_reportit_reports AS a LEFT JOIN plugin_reportit_templates AS b ON b.id = a.template_id LEFT JOIN (SELECT report_id, count() as ds_cnt FROM plugin_reportit_data_items GROUP BY report_id) AS c ON c.report_id = a.id LEFT JOIN user_auth AS d ON d.id = a.user_id WHERE a.description LIKE '%' ORDER BY name ASC LIMIT 15000,5000"

[lbsou]

OK, so I just upgraded to cacti 1.1.38 and everything is working :)