search

alexmonteiro / Redmine-Monitoring-Controlling

Redmine Plugin that works with Highcharts to show tasks on project throught Charts.
Other
131 stars 79 forks source link

Redmine 500 error (internal error) #80

Closed surfnet33 closed 11 years ago

surfnet33 commented 11 years ago

Please help, thanks so much.

System

Redmine 2.2.4 Ruby 1.9.3p194 Rails 2.3.15 Gem 1.8.24

Scenario

  1. Install plugin successfully.
  2. Plugin activated in the project.
  3. "Monitoring & Controlling" tab appeared.
  4. When clicking the tab, Redmine 500 error occurred.

    Log error messages

ActiveRecord::StatementInvalid (SQLite3::SQLException: no such column: true: select trackers.name, trackers.position, count() as totalbycategory, (select count() from issues where project_id in (1) and issues.tracker_id = trackers.id and status_id in (select id from issue_statuses where is_closed = true)

                                            ) as totaldone,
                                            (select count(*) 
                                             from issues 
                                             where project_id in (1)
                                             and issues.tracker_id = trackers.id
                                             and status_id in (select id from issue_statuses where is_closed = false)

                                            ) as totalundone
                                            from trackers, projects_trackers, issues
                                            where projects_trackers.tracker_id = trackers.id 
                                            and projects_trackers.project_id = issues.project_id
                                            and issues.tracker_id = trackers.id
                                            and projects_trackers.project_id in (1) 
                                            group by trackers.id, trackers.name, trackers.position
                                            order by 2;):

sqlite3 (1.3.7) lib/sqlite3/database.rb:91:in initialize' sqlite3 (1.3.7) lib/sqlite3/database.rb:91:innew' sqlite3 (1.3.7) lib/sqlite3/database.rb:91:in prepare' activerecord (3.2.13) lib/active_record/connection_adapters/sqlite_adapter.rb:246:inblock in exec_query' activerecord (3.2.13) lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' activesupport (3.2.13) lib/active_support/notifications/instrumenter.rb:20:ininstrument' activerecord (3.2.13) lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' activerecord (3.2.13) lib/active_record/connection_adapters/sqlite_adapter.rb:242:inexec_query' activerecord (3.2.13) lib/active_record/connection_adapters/sqlite_adapter.rb:467:in select' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/database_statements.rb:18:inselect_all' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in block in select_all' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/query_cache.rb:75:incache_sql' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in select_all' activerecord (3.2.13) lib/active_record/querying.rb:38:inblock in find_by_sql' activerecord (3.2.13) lib/active_record/explain.rb:41:in logging_query_plan' activerecord (3.2.13) lib/active_record/querying.rb:37:infind_by_sql' plugins/redmine_monitoring_controlling/app/controllers/home_monitoring_controlling_project_controller.rb:25:in index' actionpack (3.2.13) lib/action_controller/metal/implicit_render.rb:4:insend_action' actionpack (3.2.13) lib/abstract_controller/base.rb:167:in process_action' actionpack (3.2.13) lib/action_controller/metal/rendering.rb:10:inprocess_action' actionpack (3.2.13) lib/abstract_controller/callbacks.rb:18:in block in process_action' activesupport (3.2.13) lib/active_support/callbacks.rb:480:in_run2698418605445250936process_action2052071873877612548callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:405:in __run_callback' activesupport (3.2.13) lib/active_support/callbacks.rb:385:in_run_process_action_callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:81:in run_callbacks' actionpack (3.2.13) lib/abstract_controller/callbacks.rb:17:inprocess_action' actionpack (3.2.13) lib/action_controller/metal/rescue.rb:29:in process_action' actionpack (3.2.13) lib/action_controller/metal/instrumentation.rb:30:inblock in process_action' activesupport (3.2.13) lib/active_support/notifications.rb:123:in block in instrument' activesupport (3.2.13) lib/active_support/notifications/instrumenter.rb:20:ininstrument' activesupport (3.2.13) lib/active_support/notifications.rb:123:in instrument' actionpack (3.2.13) lib/action_controller/metal/instrumentation.rb:29:inprocess_action' actionpack (3.2.13) lib/action_controller/metal/params_wrapper.rb:207:in process_action' activerecord (3.2.13) lib/active_record/railties/controller_runtime.rb:18:inprocess_action' actionpack (3.2.13) lib/abstract_controller/base.rb:121:in process' actionpack (3.2.13) lib/abstract_controller/rendering.rb:45:inprocess' actionpack (3.2.13) lib/action_controller/metal.rb:203:in dispatch' actionpack (3.2.13) lib/action_controller/metal/rack_delegation.rb:14:indispatch' actionpack (3.2.13) lib/action_controller/metal.rb:246:in block in action' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:73:incall' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:73:in dispatch' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:36:incall' journey (1.0.4) lib/journey/router.rb:68:in block in call' journey (1.0.4) lib/journey/router.rb:56:ineach' journey (1.0.4) lib/journey/router.rb:56:in call' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:612:incall' rack-openid (1.3.1) lib/rack/openid.rb:98:in call' actionpack (3.2.13) lib/action_dispatch/middleware/best_standards_support.rb:17:incall' rack (1.4.5) lib/rack/etag.rb:23:in call' rack (1.4.5) lib/rack/conditionalget.rb:25:incall' actionpack (3.2.13) lib/action_dispatch/middleware/head.rb:14:in call' actionpack (3.2.13) lib/action_dispatch/middleware/params_parser.rb:21:incall' actionpack (3.2.13) lib/action_dispatch/middleware/flash.rb:242:in call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:incontext' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in call' actionpack (3.2.13) lib/action_dispatch/middleware/cookies.rb:341:incall' activerecord (3.2.13) lib/active_record/query_cache.rb:64:in call' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:incall' actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:28:in block in call' activesupport (3.2.13) lib/active_support/callbacks.rb:405:in_run1284105963513986564call2467856053762605425callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:405:in __run_callback' activesupport (3.2.13) lib/active_support/callbacks.rb:385:in_run_call_callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:81:in run_callbacks' actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:27:incall' actionpack (3.2.13) lib/action_dispatch/middleware/remote_ip.rb:31:in call' actionpack (3.2.13) lib/action_dispatch/middleware/debug_exceptions.rb:16:incall' actionpack (3.2.13) lib/action_dispatch/middleware/show_exceptions.rb:56:in call' railties (3.2.13) lib/rails/rack/logger.rb:32:incall_app' railties (3.2.13) lib/rails/rack/logger.rb:16:in block in call' activesupport (3.2.13) lib/active_support/tagged_logging.rb:22:intagged' railties (3.2.13) lib/rails/rack/logger.rb:16:in call' actionpack (3.2.13) lib/action_dispatch/middleware/request_id.rb:22:incall' rack (1.4.5) lib/rack/methodoverride.rb:21:in call' rack (1.4.5) lib/rack/runtime.rb:17:incall' activesupport (3.2.13) lib/active_support/cache/strategy/local_cache.rb:72:in call' rack (1.4.5) lib/rack/lock.rb:15:incall' actionpack (3.2.13) lib/action_dispatch/middleware/static.rb:63:in call' rack-cache (1.2) lib/rack/cache/context.rb:136:inforward' rack-cache (1.2) lib/rack/cache/context.rb:245:in fetch' rack-cache (1.2) lib/rack/cache/context.rb:185:inlookup' rack-cache (1.2) lib/rack/cache/context.rb:66:in call!' rack-cache (1.2) lib/rack/cache/context.rb:51:incall' railties (3.2.13) lib/rails/engine.rb:479:in call' railties (3.2.13) lib/rails/application.rb:223:incall' railties (3.2.13) lib/rails/railtie/configurable.rb:30:in method_missing' passenger (3.0.19) lib/phusion_passenger/rack/request_handler.rb:96:inprocess_request' passenger (3.0.19) lib/phusion_passenger/abstract_request_handler.rb:516:in accept_and_process_next_request' passenger (3.0.19) lib/phusion_passenger/abstract_request_handler.rb:274:inmain_loop' passenger (3.0.19) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in start_request_handler' passenger (3.0.19) lib/phusion_passenger/classic_rails/application_spawner.rb:275:inblock in handle_spawn_application' passenger (3.0.19) lib/phusion_passenger/utils.rb:470:in safe_fork' passenger (3.0.19) lib/phusion_passenger/classic_rails/application_spawner.rb:270:inhandle_spawn_application' passenger (3.0.19) lib/phusion_passenger/abstract_server.rb:357:in server_main_loop' passenger (3.0.19) lib/phusion_passenger/abstract_server.rb:206:instart_synchronously' passenger (3.0.19) lib/phusion_passenger/abstract_server.rb:180:in start' passenger (3.0.19) lib/phusion_passenger/classic_rails/application_spawner.rb:149:instart' passenger (3.0.19) lib/phusion_passenger/spawn_manager.rb:219:in block (2 levels) in spawn_rails_application' passenger (3.0.19) lib/phusion_passenger/abstract_server_collection.rb:132:inlookup_or_add' passenger (3.0.19) lib/phusion_passenger/spawn_manager.rb:214:in block in spawn_rails_application' passenger (3.0.19) lib/phusion_passenger/abstract_server_collection.rb:82:inblock in synchronize' internal:prelude:10:in synchronize' passenger (3.0.19) lib/phusion_passenger/abstract_server_collection.rb:79:insynchronize' passenger (3.0.19) lib/phusion_passenger/spawn_manager.rb:213:in spawn_rails_application' passenger (3.0.19) lib/phusion_passenger/spawn_manager.rb:132:inspawn_application' passenger (3.0.19) lib/phusion_passenger/spawn_manager.rb:275:in handle_spawn_application' passenger (3.0.19) lib/phusion_passenger/abstract_server.rb:357:inserver_main_loop' passenger (3.0.19) lib/phusion_passenger/abstract_server.rb:206:in start_synchronously' passenger (3.0.19) helper-scripts/passenger-spawn-server:99:in

'

alexmonteiro commented 11 years ago

Thanks for report @surfnet33, Pull the last commit d3732eba03349b7987f3cfdbb48ff34b15aa839d , I changed the query parameters to work with any redmine database.

surfnet33 commented 11 years ago

Bravo! The bug has been fixed! I can see some nice charts now. Good quality work!

Nice job! Not only was the problem solved, but was also solved in a speedy way.

Keep it up, Alex!