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

[ikorzha]

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]

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

[netniV]

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

[netniV]

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]

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]

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

[netniV]

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]

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]

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

[netniV]

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

[ikorzha]

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

[ikorzha]

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]

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]

Anyone online to assist

[TheWitness]

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