500 Internal error - Home_Monitoring_Controlling

Added by Mak Kil over 8 years ago

Hello,

I just installed Monitoring and Controlling plugin on Redmine 1.4. I followed the instructions given at http://www.redmine.org/plugins/monitoring-controlling but I am getting the error below when I click on Monitoring and Controlling tab. I am running OpenSuse 11.4, redmine 1.4, ruby 1.8.7 and postgresql. Can someone please help me? I did lots of goggling but not much help so far.

Thank you,
Mak

Processing HomeMonitoringControllingProjectController#index (for 10.1.70.28 at 2014-02-17 14:41:22) [GET]
Parameters: {"action"=>"index", "controller"=>"home_monitoring_controlling_project", "id"=>"test"}

NoMethodError (undefined method where' for #<Class:0x7f77c89d1768>):
vendor/plugins/redmine_monitoring_controlling/app/controllers/home_monitoring_controlling_project_controller.rb:22:inindex'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in service'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:65:inrun'
/usr/lib64/ruby/1.8/webrick/server.rb:173:in start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:162:instart'
/usr/lib64/ruby/1.8/webrick/server.rb:162:in start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:95:instart'
/usr/lib64/ruby/1.8/webrick/server.rb:92:in each'
/usr/lib64/ruby/1.8/webrick/server.rb:92:instart'
/usr/lib64/ruby/1.8/webrick/server.rb:23:in start'
/usr/lib64/ruby/1.8/webrick/server.rb:82:instart'
server:3:in `require'
server:3

Rendering /srv/redmine/redmine-1.4/public/500.html (500 Internal Server Error)

Replies (4)

RE: 500 Internal error - Home_Monitoring_Controlling - Added by Marco Gutsche over 8 years ago

Have you installed 0.1.0?

If so, this versions seems to be incompatible with your redmine version and you should use 0.0.1.

RE: 500 Internal error - Home_Monitoring_Controlling - Added by Mak Kil over 8 years ago

Thanks for the quick reply. I have 0.1.1 installed. I will try 0.0.1 now.

Mak

RE: 500 Internal error - Home_Monitoring_Controlling - Added by Mak Kil over 8 years ago

Hello again,

I installed 0.0.1 but now I got the following error. I saw that there is an update to solve this problem with postgres and installed 0.0.2 but I got the same error. Any other ideas? I am really stuck on this issue. I wonder whether I uninstall/install properly or not? To install it, I copy the files from https://github.com/alexmonteiro/Redmine-Monitoring-Controlling/tree/v0.0.3 for example.
- Unzip the file and copy it to ../vendor/plugins folder.
- run rake db:migrate_plugins RAILS_ENV=production
- restart redmine * I do ps aux|grep webr and kill the process * kill -9 23432 * ruby server webrick -e production -d

I am not touching postgres.

Thank you.

ActiveRecord::StatementInvalid (PG::Error: ERROR: division by zero
: SELECT *,
((SELECT COUNT FROM issues where project_id in (33) and status_id = issue_statuses.id)
/
(SELECT COUNT FROM issues where project_id in (33)))*100 as percent,
(SELECT COUNT FROM issues where project_id in (33) and status_id = issue_statuses.id)
AS totalissues
FROM issue_statuses;):
vendor/plugins/redmine_monitoring_controlling/app/controllers/home_monitoring_controlling_project_controller.rb:40:in `index'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib64/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:23:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /srv/redmine/redmine-1.4/public/500.html (500 Internal Server Error)

RE: 500 Internal error - Home_Monitoring_Controlling - Added by Mak Kil over 8 years ago

Can someone please help me with this problem? I really appreciate any help. I am not an expert on this subject and have exhausted all the options.

Thank you in advance,

Mak

(1-4/4)