search

pharmazone / redmine_charts2

Plugin which integrates with Redmine 2.0.3 and 2.1.x following charts: burndown, timeline, ratios of logged hours and issues, deviations of logged hours.
http://github.com/pharmazone/redmine_charts2
MIT License
51 stars 22 forks source link

Add support for 2.5 #43

Open emoritz opened 10 years ago

emoritz commented 10 years ago

Installed redmine_charts2 on Redmine 2.5.1.stable.13103 but get the following runtime error:

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'railsapp_production.chart_time_entries' doesn't exist: SELECT chart_time_entries.day as range_value, 'days' as range_type, sum(logged_hours) as logged_hours, sum(entries) as entries, 'issue_id' as grouping, chart_time_entries.issue_id as group_id FROM chart_time_entries left join issues on issues.id = issue_id WHERE chart_time_entries.project_id IN (27) AND issues.fixed_version_id IN (60) AND (chart_time_entries.day BETWEEN '2014071' AND '2014182') GROUP BY chart_time_entries.day, chart_time_entries.issue_id ORDER BY 1 asc, 6 asc): activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in query' activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inblock in execute' activerecord (3.2.17) lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' activesupport (3.2.17) lib/active_support/notifications/instrumenter.rb:20:ininstrument' activerecord (3.2.17) lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inexecute' activerecord (3.2.17) lib/active_record/connection_adapters/mysql2_adapter.rb:213:in execute' activerecord (3.2.17) lib/active_record/connection_adapters/mysql2_adapter.rb:217:inexec_query' activerecord (3.2.17) lib/active_record/connection_adapters/mysql2_adapter.rb:226:in select' activerecord (3.2.17) lib/active_record/connection_adapters/abstract/database_statements.rb:18:inselect_all' activerecord (3.2.17) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in block in select_all' activerecord (3.2.17) lib/active_record/connection_adapters/abstract/query_cache.rb:75:incache_sql' activerecord (3.2.17) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in select_all' activerecord (3.2.17) lib/active_record/querying.rb:38:inblock in find_by_sql' activerecord (3.2.17) lib/active_record/explain.rb:41:in logging_query_plan' activerecord (3.2.17) lib/active_record/querying.rb:37:infind_by_sql' activerecord (3.2.17) lib/active_record/relation.rb:174:in block in exec_queries' activerecord (3.2.17) lib/active_record/identity_map.rb:72:inwithout' activerecord (3.2.17) lib/active_record/relation.rb:173:in exec_queries' activerecord (3.2.17) lib/active_record/relation.rb:160:inblock in to_a' activerecord (3.2.17) lib/active_record/explain.rb:41:in logging_query_plan' activerecord (3.2.17) lib/active_record/relation.rb:159:into_a' activerecord (3.2.17) lib/active_record/relation/finder_methods.rb:159:in all' activerecord (3.2.17) lib/active_record/querying.rb:5:inall' plugins/redmine_charts2/app/models/chart_time_entry.rb:44:in get_timeline' plugins/redmine_charts2/app/controllers/charts_burndown2_controller.rb:78:inget_data_for_burndown_chart' plugins/redmine_charts2/app/controllers/charts_burndown2_controller.rb:22:in get_data' plugins/redmine_charts2/app/controllers/charts_controller.rb:111:increate_chart' plugins/redmine_charts2/app/controllers/charts_controller.rb:84:in index' actionpack (3.2.17) lib/action_controller/metal/implicit_render.rb:4:insend_action' actionpack (3.2.17) lib/abstract_controller/base.rb:167:in process_action' actionpack (3.2.17) lib/action_controller/metal/rendering.rb:10:inprocess_action' actionpack (3.2.17) lib/abstract_controller/callbacks.rb:18:in block in process_action' activesupport (3.2.17) lib/active_support/callbacks.rb:491:in_run152307204process_action237776379callbacks' activesupport (3.2.17) lib/active_support/callbacks.rb:405:in __run_callback' activesupport (3.2.17) lib/active_support/callbacks.rb:385:in_run_process_action_callbacks' activesupport (3.2.17) lib/active_support/callbacks.rb:81:in run_callbacks' actionpack (3.2.17) lib/abstract_controller/callbacks.rb:17:inprocess_action' actionpack (3.2.17) lib/action_controller/metal/rescue.rb:29:in process_action' actionpack (3.2.17) lib/action_controller/metal/instrumentation.rb:30:inblock in process_action' activesupport (3.2.17) lib/active_support/notifications.rb:123:in block in instrument' activesupport (3.2.17) lib/active_support/notifications/instrumenter.rb:20:ininstrument' activesupport (3.2.17) lib/active_support/notifications.rb:123:in instrument' actionpack (3.2.17) lib/action_controller/metal/instrumentation.rb:29:inprocess_action' actionpack (3.2.17) lib/action_controller/metal/params_wrapper.rb:207:in process_action' activerecord (3.2.17) lib/active_record/railties/controller_runtime.rb:18:inprocess_action' actionpack (3.2.17) lib/abstract_controller/base.rb:121:in process' actionpack (3.2.17) lib/abstract_controller/rendering.rb:45:inprocess' actionpack (3.2.17) lib/action_controller/metal.rb:203:in dispatch' actionpack (3.2.17) lib/action_controller/metal/rack_delegation.rb:14:indispatch' actionpack (3.2.17) lib/action_controller/metal.rb:246:in block in action' actionpack (3.2.17) lib/action_dispatch/routing/route_set.rb:73:incall' actionpack (3.2.17) lib/action_dispatch/routing/route_set.rb:73:in dispatch' actionpack (3.2.17) 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.17) lib/action_dispatch/routing/route_set.rb:608:incall' rack-openid (1.4.2) lib/rack/openid.rb:98:in call' actionpack (3.2.17) 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.17) lib/action_dispatch/middleware/head.rb:14:in call' actionpack (3.2.17) lib/action_dispatch/middleware/params_parser.rb:21:incall' actionpack (3.2.17) 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.17) lib/action_dispatch/middleware/cookies.rb:341:incall' activerecord (3.2.17) lib/active_record/query_cache.rb:64:in call' activerecord (3.2.17) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:incall' actionpack (3.2.17) lib/action_dispatch/middleware/callbacks.rb:28:in block in call' activesupport (3.2.17) lib/active_support/callbacks.rb:405:in_run139321153call574389408callbacks' activesupport (3.2.17) lib/active_support/callbacks.rb:405:in __run_callback' activesupport (3.2.17) lib/active_support/callbacks.rb:385:in_run_call_callbacks' activesupport (3.2.17) lib/active_support/callbacks.rb:81:in run_callbacks' actionpack (3.2.17) lib/action_dispatch/middleware/callbacks.rb:27:incall' actionpack (3.2.17) lib/action_dispatch/middleware/remote_ip.rb:31:in call' actionpack (3.2.17) lib/action_dispatch/middleware/debug_exceptions.rb:16:incall' actionpack (3.2.17) lib/action_dispatch/middleware/show_exceptions.rb:56:in call' railties (3.2.17) lib/rails/rack/logger.rb:32:incall_app' railties (3.2.17) lib/rails/rack/logger.rb:16:in block in call' activesupport (3.2.17) lib/active_support/tagged_logging.rb:22:intagged' railties (3.2.17) lib/rails/rack/logger.rb:16:in call' actionpack (3.2.17) 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.17) lib/active_support/cache/strategy/local_cache.rb:72:in call' rack (1.4.5) lib/rack/lock.rb:15:incall' actionpack (3.2.17) 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.17) lib/rails/engine.rb:484:in call' railties (3.2.17) lib/rails/application.rb:231:incall' railties (3.2.17) lib/rails/railtie/configurable.rb:30:in method_missing' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/rack/request_handler.rb:92:inprocess_request' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/abstract_request_handler.rb:207:in main_loop' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/rack/application_spawner.rb:120:inrun' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/rack/application_spawner.rb:65:in block in spawn_application' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/utils.rb:252:insafe_fork' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/rack/application_spawner.rb:58:in spawn_application' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/rack/application_spawner.rb:41:inspawn_application' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/spawn_manager.rb:159:in spawn_application' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/spawn_manager.rb:287:inhandle_spawn_application' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/abstract_server.rb:352:in main_loop' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/lib/phusion_passenger/abstract_server.rb:196:instart_synchronously' /usr/local/lib/ruby/gems/1.8/gems/passenger-2.2.14/bin/passenger-spawn-server:61:in `

'

pharmazone commented 10 years ago

Have you run migrations? Does table "railsapp_production.chart_time_entries" exist in DB?