Unable to add a new report in reportit: "There are no report templates available."

Cacti / plugin_reportit

ReportIt Plugin for Cacti

GNU General Public License v2.0

7 stars 9 forks source link

Unable to add a new report in reportit: "There are no report templates available." #44

Closed ikorzha closed 6 years ago

ikorzha commented 6 years ago

I am unable to add a new report in reportit with msg: "There are no report templates available." See the screenshot below 1: However I do have a report template available that is published see the screenshot below 2:

Please advise

netniV commented 6 years ago

Yes, this seems like a new issue. I'll have to take a look shortly.

netniV commented 6 years ago

Well, I managed to create a report template, with the only error being that the save reported as unsuccessful but it was.

netniV commented 6 years ago

I believe that this issue is down to the fact you may have it on a test system and no other graphs created. Let me know if I have that right?

ikorzha commented 6 years ago

No i have it installed on my prod system, same system I gave you a copy of DB from. I didn't have an issue creating a report template, that portion worked. Creating an actual report that is based on existing template that is what producing an error. See original screenshot. Please let me know if there are further questions.

netniV commented 6 years ago

Oh sorry, I'll go take a look at that side.

netniV commented 6 years ago

For a report to appear, it must be unlocked and enabled.

SELECT id, description
FROM plugin_reportit_templates
WHERE `locked` = '' AND `enabled` = 'on' ORDER BY description

ikorzha commented 6 years ago

netniV, thank you for your investigation, you are absolutely right as soon as I unlocked the template I was able to create a report. However behavior for end user is absolutely in-intuitive. I think to avoid any questions from end users in the future it would be best to add a tip on a screenshot page I have attached. Stating: "For a reportit template to appear, it must be unlocked and enabled."

I also went back and checked old version in 0.8.8x Cacti running 0.8 reportIT. Behavior is identical in new version of reportit, I am not sure why I didn't run into this problem in the old version too..

Feel free to close this issue either with or without tip up to you :)

netniV commented 6 years ago

I think probably because you had a different issue... why can't I see that report? oh yeah I haven't unlocked it.

netniV commented 6 years ago

I have now updated the message. Check it out and let me know what you think.

ikorzha commented 6 years ago

Your fix is excellent. At least now some one can make a connection between locked template and reporting. Thank you.

ikorzha commented 6 years ago

netniV, there is another related issue #45 this time related to template lock. Can you please take a look when you have a chance.

wekesa254 commented 7 months ago

Am experiencing the same problem on Cacti v1.2.26.

I have tried to run the above SQL command and below is the output

wekesa254 commented 7 months ago

Anyone online to assist

TheWitness commented 7 months ago

You have to create a template first. Check under templates. I don't know much about this plugin. Maybe @xmacan or @browniebraun can assist.