Graph Plugin returning black square and sql error

Added by Hugo Marcelino over 8 years ago

Hello everyone!

After i looked at the available plugins, this was one that called my attention, because it is very usefull to analyse a project in production.
After i've installed i come across with two bugs.

There was one error with an sql query and the graphics were showing black.

1. The sql query was easy to repair. Only had to add the keyword as.

Please could you add to the sql the keyword 'as' because my postgres dont like renaming columns without this keyword.

The error is at:

/app/controllers/graphs_controller.rb

from: sql = "SELECT project_id, COUNT issue_count" (...)

to: sql = "SELECT project_id, COUNT as issue_count"

2. About the second error, is that i'm getting a black square for each graphic displayed. (added screenshot)

Hope this can help.

Best Regards.

Hugo Marcelino

Devcontrol_Tracking_Issue_-_DevControl_Tracking_Issue.png - graphics as black squares (92.5 KB)

Replies (10)

RE: Graph Plugin returning black square and sql error - Added by Mike D. Smith over 8 years ago

I had the same problem with the black graph on the 0.8.x branch with Firefox. I had to comment out the :no_css, and :style_sheet lines in the plugin's app/controllers/graphs_controller.rb file. There are 6 lines total. Haven't had time to look into this further yet.

-Mike

RE: Graph Plugin returning black square and sql error - Added by Markus Peter over 8 years ago

I just installed the latest version from the trunk of the graphs plugin in a redmine application from yesterday's trunk, and I also did get the black square. Commenting out :no_css and :style_sheet lines as Mike suggested did make appear the graphs.

RE: Graph Plugin returning black square and sql error - Added by Curtis Stewart over 8 years ago

I have been trying to use the graphs plugin for a while and have always received the same black boxes described above. Commented out the lines as Mr. Smith said and it works perfect. Thanks for the help.

RE: Graph Plugin returning black square and sql error - Added by Michael Aye over 8 years ago

Man, this was a waste of time to search for this.
Brad, could you not make a hint of this problem at the plugin page?
But thanks otherwise for this great plugin!
Best regards,
Michael

RE: Graph Plugin returning black square and sql error - Added by Michael Aye over 8 years ago

forgot to say and confirm, that commenting out the css related lines helped me as well.

RE: Graph Plugin returning black square and sql error - Added by Brad Beattie over 8 years ago

The issue is that I've developed the graphs plugin on a Redmine domain (e.g. redmine.example.com) whereas the folks with this CSS issue are running in a subdirectory (e.g. example.com/redmine). This is the cause of the mismatched URLs. It's not exactly a priority for me as that's not the environment I run in, although I do intend on fixing at some point in the near future.

As mentioned the other day:

That's the nature of open source development: If you don't do it yourself there's no guarantee anyone will do it. That being said, you have a number of options.

  • Implement the feature requests yourself and provide them either as patches or plugins (requires the ability to program).
  • Hire a developer to do the programming for you (requires money).
  • Wait and hope someone will implement that feature independent of your desire (requires patience).

RE: Graph Plugin returning black square and sql error - Added by Michael Aye over 8 years ago

I don't think you are being fair, Brad, as I have not even asked that this will be fixed --- I generally never do if I get something for free ;) ---, but only that a hint of the existing incompatibility is put on the plugin wiki page, so that one can have that workaround fast, instead of searching around.

Wouldn't it be a shame if some people refrain from using your nice plugin just b/c of a lack of this fast workaround? ;)

RE: Graph Plugin returning black square and sql error - Added by Brad Beattie over 8 years ago

Michael Aye wrote:

I don't think you are being fair, Brad, as I have not even asked that this will be fixed --- I generally never do if I get something for free ;) ---, but only that a hint of the existing incompatibility is put on the plugin wiki page, so that one can have that workaround fast, instead of searching around.

Wouldn't it be a shame if some people refrain from using your nice plugin just b/c of a lack of this fast workaround? ;)

Mm. I know what you mean. Unfortunately, I don't have access to edit that page. The only recourse I have is to fix the bug.

RE: Graph Plugin returning black square and sql error - Added by Michael Aye over 8 years ago

Oh, I see!
You can either send any Wiki updates to Eric Davis or ask Jean-Phillippe for Wiki edit rights.
Jim Mulholland got them after adding the Google Calendar plugin as you can read here.
And I would rate your plugin at least to the same value! ;)

(1-10/10)