Project

General

Profile

Forums » Plugins »

Redmine Scrumdashboard plugin

Added by Mats Klepsland over 15 years ago

Scrumdashboard is a plugin for Redmine. It enables Redmine to better support the Scrum process by giving the users access to a digital "dashboard". This shows the status for the current sprint through a digital representation of a whiteboard with post-it notes detailing User Stories/Features/etc (from the product backlog) which is often used with projects using Scrum.

The data used in the application to display this information is taken from the "Versions","Trackers" and "Issues" you register in your Redmine project.

In other words, the application does not allow you to register new information, it just allows you to display the current registered information in a new manner to give you a quick status overview. It also allows for manipulation of some of the data (specifically dragging & dropping user stories/tasks to new statues - by supporting the workflow configured for the project).

A typical scenario involves a number of versions, that can be named such as "Sprint 1", "Sprint 2" and a series of trackers, such as "User Story", "Feature", "Bug". It will display all the trackers that are linked to a specific version (sprint) in the application.

Features:
- Drag & Drop to change the status of an issue, following the workflow
- Change the types of statuses/trackers displayed on the dashboard
- Column sorting for statuses
- Choose which version to display on the dashboard
- Tooltips for each issue
- Display all the issues or only the issues assigned to the current user
- Configure colors for issues displayed

For more information check out the README file in our Github repository:
http://github.com/thus/redmine-scrumdashboard-plugin/tree/master

Note that this is our first project in Ruby on Rails so please go easy on us :)

Download all files
scrumdashboard_1.png (80.8 KB) scrumdashboard_1.png Redmine-scrumdashboard-plugin: Main page
scrumdashboard_4.png (97.6 KB) scrumdashboard_4.png Redmine-scrumdashboard-plugin: Configuration page

Replies (137)

RE: Redmine Scrumdashboard plugin - Added by Davide Ferrari over 15 years ago

Just pulled latest git, now translations works with current trunk, and finally the dashboard is usable. I'll start playing with it. Thanks again!

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

It's still not possible to view issues on the dashboard using the current trunk. Trying that leads to an internal error. I'm working on fixing that now. Hopefully that is all that is missing for the plugin to work with the current trunk.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Just committed a new version of the plugin to GitHub with the following change:

- Made it possible to view issues on the dashboard using the Redmine current trunk.

It looks like drag and drop still don't work, but now it's at least possible to view issues on the dashboard using the current trunk.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Mats Klepsland wrote:

Just committed a new version of the plugin to GitHub with the following change:

- Made it possible to view issues on the dashboard using the Redmine current trunk.

It looks like drag and drop still don't work, but now it's at least possible to view issues on the dashboard using the current trunk.

Forget the last sentence in my last post. Dragging and dropping issues works using the current trunk of Redmine. I was to excited to commit the latest release so I only performed a (too) quick functionality test. It looks like the plugin soon works perfect (or at least as good as the stable trunk) with the current trunk. I'll perform a more thorough test tomorrow. The bugs I know of at the moment are:

- Using certain characters (such as single quotes (')) in issues creates problems with the tooltip.
- Problem with check-boxes under the issue-tab at the settings page. The check-box for the maintracker won't activate as it should.
- The settings-button should be visible even when there are no versions.
- The filter option disappears when there is only one version.

These are the problems I can think of at the moment. Please let me know if any of you find more bugs/problems.

RE: Redmine Scrumdashboard plugin - Added by Mischa The Evil over 15 years ago

Mats Klepsland wrote:

The bugs I know of at the moment are:

- Using certain characters (such as single quotes (')) in issues creates problems with the tooltip.
- Problem with check-boxes under the issue-tab at the settings page. The check-box for the maintracker won't activate as it should.
- The settings-button should be visible even when there are no versions.
- The filter option disappears when there is only one version.

These are the problems I can think of at the moment.

I think this list is pretty complete now... :)

Kind regards,

Mischa.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Just committed a new version of the plugin to GitHub with the following change:

- Fixed so that the the settings button is visible even when there are no versions.
- The filter option will no longer disappear when there is only one version.
- Made versions with long names look better on the dashboard (fixed width on version drop-down-box).

The only problems (that I know of) that are left to fix now are problems with JavaScript. These problems only occur using the current branch of Redmine. When they are corrected the plugin should be fully functional using the current branch. I'm really looking forward to removing the "0.8.x only!" part from the plugin wiki :)

RE: Redmine Scrumdashboard plugin - Added by Holger Winkelmann over 15 years ago

Mats Klepsland wrote:

Scrumdashboard is a plugin for Redmine. It enables Redmine to better support the Scrum process by giving the users access to a digital "dashboard". This shows the status for the current sprint through a digital representation of a whiteboard with post-it notes detailing User Stories/Features/etc (from the product backlog) which is often used with projects using Scrum.

The data used in the application to display this information is taken from the "Versions","Trackers" and "Issues" you register in your Redmine project.

In other words, the application does not allow you to register new information, it just allows you to display the current registered information in a new manner to give you a quick status overview. It also allows for manipulation of some of the data (specifically dragging & dropping user stories/tasks to new statues - by supporting the workflow configured for the project).

A typical scenario involves a number of versions, that can be named such as "Sprint 1", "Sprint 2" and a series of trackers, such as "User Story", "Feature", "Bug". It will display all the trackers that are linked to a specific version (sprint) in the application.

Features:
- Drag & Drop to change the status of an issue, following the workflow
- Change the types of statuses/trackers displayed on the dashboard
- Column sorting for statuses
- Choose which version to display on the dashboard
- Tooltips for each issue
- Display all the issues or only the issues assigned to the current user
- Configure colors for issues displayed

For more information check out the README file in our Github repository:
http://github.com/thus/redmine-scrumdashboard-plugin/tree/master

Note that this is our first project in Ruby on Rails so please go easy on us :)

one question, how is your project related to the SA Taskboard ? Can your plugin used together with the burndown plugin ?

Thanks a lot,

Holger

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

one question, how is your project related to the SA Taskboard ? Can your plugin used together with the burndown plugin ?

I have actually never tested the SA Taskboard plugin, so I'm in no position to answer your first question. You'll just have to try both plugins and choose the one that you prefer.

I can't see any reasons why our plugin shouldn't work with the burndown plugin. It's a totally different plugin and should therefore have no problems coexisting with our plugin. We actually planned to make our own burn-down-chart plugin early in the development but our product owner changed his mind so we had to scrap the idea.

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Galaxy King over 15 years ago

Hello,

I'm getting this error. How should i create dashboards table?

[dnwtechc@server30 pm]$ rake db:migrate_plugins RAILS_ENV=production
(in /home/dnwtechc/public_html/pm)
Migrating engines...
Migrating actionwebservice...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating classic_pagination...
Migrating coderay-0.7.6.227...
Migrating gloc-1.1.0...
Migrating gravatar...
Migrating redmine_issues_group...
Migrating redmine_scrumdashboard...
2 Dashboardstatuses: migrating ===========================================
-- create_table("dashboard_statuses", {:force=>true})
-> 0.3044s
rake aborted!
Mysql::Error: Table 'dnwtechc_redmine.dashboards' doesn't exist: SELECT * FROM `dashboards`

(See full trace by running task with --trace)
[dnwtechc@server30 pm]$

Thanks.

RE: Redmine Scrumdashboard plugin - Added by Holger Winkelmann over 15 years ago

I have just installed the dashboard plugin. If i drop a issue to the same origin status I have a entry in the activity list says status changed from assigned to assigned. I think its valid to drop a issue same status specially if you have dragged the wrong issue but this should not appear in the activity list.

Holger

RE: Redmine Scrumdashboard plugin - Added by Holger Winkelmann over 15 years ago

I noticed the configuration Screen has a version number in the URL:

http://172.20.100.10/dashboard/settings/scg?version=6

whats about this version ? it started with version=4 now is version=6

Holger

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Holger Winkelmann wrote:

I noticed the configuration Screen has a version number in the URL:

[...]

whats about this version ? it started with version=4 now is version=6

The version number you are seeing is for referencing only. It makes it possible to return to the version you were viewing when you pressed the settings link. It's not really a problem, but I'm thinking of concealing it from the user to avoid further confusion :)

Holger Winkelmann wrote:

I have just installed the dashboard plugin. If i drop a issue to the same origin status I have a entry in the activity list says status > changed from assigned to assigned. I think its valid to drop a issue same status specially if you have dragged the wrong issue but this > should not appear in the activity list.

I totally agree with you! I'm going to change this as soon as I can. Just added it to my todo list!

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Galaxy King wrote:

Hello,

I'm getting this error. How should i create dashboards table?

[dnwtechc@server30 pm]$ rake db:migrate_plugins RAILS_ENV=production
(in /home/dnwtechc/public_html/pm)
Migrating engines...
Migrating actionwebservice...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating classic_pagination...
Migrating coderay-0.7.6.227...
Migrating gloc-1.1.0...
Migrating gravatar...
Migrating redmine_issues_group...
Migrating redmine_scrumdashboard...
2 Dashboardstatuses: migrating ===========================================
-- create_table("dashboard_statuses", {:force=>true})
-> 0.3044s
rake aborted!
Mysql::Error: Table 'dnwtechc_redmine.dashboards' doesn't exist: SELECT * FROM `dashboards`

(See full trace by running task with --trace)
[dnwtechc@server30 pm]$

Thanks.

To be honest I have no idea why you are getting this error. The dashboards table should be automatically created when you run:

rake db:migrate_plugins

Could you try running migrate_plugins with the trace option and posting the results here? Perhaps that would reveal what the problem is.

rake db:migrate_plugins --trace

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Jason Messmer over 15 years ago

I would like to see the "Choose version" be the current "target version". Right now it defaults the latest target version.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Jason Messmer wrote:

I would like to see the "Choose version" be the current "target version". Right now it defaults the latest target version.

We defaulted it to the latest version, since that was what our customer wanted at the time we developed the plugin. I'll look into changing it to the current version instead, but I don't have a lot of time right now, so it would have to wait. There are other issues that are more important than this at the moment. Thank you for taking the time posting! Let me know if there are more you don't think feels right about the plugin :)

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Rander Castro over 15 years ago

Hello 4all,

Yesterday, I have downloaded the plugin and instaled. When I goes to the tab "Dashboard" I have the links: Please set a main tracker and Settings. When, I click whatever this links I have folowing error page:

404

The page you were trying to access doesn't exist or has been removed.

Back

Thanks!

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Rander Castro wrote:

Hello 4all,

Yesterday, I have downloaded the plugin and instaled. When I goes to the tab "Dashboard" I have the links: Please set a main tracker and Settings. When, I click whatever this links I have folowing error page:

404

The page you were trying to access doesn't exist or has been removed.

Back

Thanks!

I managed to replicate the problem you are experiencing. I think it's a problem with the latest version of the plugin (yeah, I screwed up while trying to fix something else :p). I think I know what the problem is and I'm going to fix it as soon as I can.

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Rander Castro over 15 years ago

Thanks, Mats. I will wait for the fix!

RE: Redmine Scrumdashboard plugin - Added by Galaxy King over 15 years ago

Mats Klepsland wrote:

Galaxy King wrote:

Hello,

I'm getting this error. How should i create dashboards table?

[dnwtechc@server30 pm]$ rake db:migrate_plugins RAILS_ENV=production
(in /home/dnwtechc/public_html/pm)
Migrating engines...
Migrating actionwebservice...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating classic_pagination...
Migrating coderay-0.7.6.227...
Migrating gloc-1.1.0...
Migrating gravatar...
Migrating redmine_issues_group...
Migrating redmine_scrumdashboard...
2 Dashboardstatuses: migrating ===========================================
-- create_table("dashboard_statuses", {:force=>true})
-> 0.3044s
rake aborted!
Mysql::Error: Table 'dnwtechc_redmine.dashboards' doesn't exist: SELECT * FROM `dashboards`

(See full trace by running task with --trace)
[dnwtechc@server30 pm]$

Thanks.

To be honest I have no idea why you are getting this error. The dashboards table should be automatically created when you run:
[...]

Could you try running migrate_plugins with the trace option and posting the results here? Perhaps that would reveal what the problem is.
[...]

Kind regards,

Mats.

Mats - thanks for looking into it. I have run it with --trace. Any clue?

[dnwtechc@server30 pm]$ rake db:migrate_plugins --trace
(in /home/dnwtechc/public_html/pm)
  • Invoke db:migrate_plugins (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute db:migrate_plugins
    Migrating engines...
    Migrating actionwebservice...
    Migrating acts_as_activity_provider...
    Migrating acts_as_attachable...
    Migrating acts_as_customizable...
    Migrating acts_as_event...
    Migrating acts_as_list...
    Migrating acts_as_searchable...
    Migrating acts_as_tree...
    Migrating acts_as_versioned...
    Migrating acts_as_watchable...
    Migrating awesome_nested_set...
    Migrating classic_pagination...
    Migrating coderay-0.7.6.227...
    Migrating gloc-1.1.0...
    Migrating gravatar...
    Migrating redmine_issues_group...
    Migrating redmine_scrumdashboard...
    2 Dashboardstatuses: migrating ===========================================
    -- create_table("dashboard_statuses", {:force=>true})
    -> 0.0629s
    rake aborted!
    Mysql::Error: Table 'dnwtechc_redmine.dashboards' doesn't exist: SELECT * FROM ` dashboards`
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connec tion_adapters/abstract_adapter.rb:147:in `log'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connec tion_adapters/mysql_adapter.rb:302:in `execute'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connec tion_adapters/mysql_adapter.rb:537:in `select'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connec tion_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cac he'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connec tion_adapters/abstract/query_cache.rb:61:in `select_all'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/base.r b:586:in `find_by_sql'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/base.r b:1345:in `find_every'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/base.r b:540:in `find'
    /home/dnwtechc/public_html/pm/vendor/plugins/redmine_scrumdashboard/db/migrate/0 02_dashboardstatuses.rb:27:in `up_without_benchmarks'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:280:in `send'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:280:in `migrate'
    /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:280:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:455:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:445:in `each'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:445:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:373:in `up'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migrat ion.rb:356:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/plugins/engines/lib/engines/plugin/migrator .rb:23:in `migrate_plugin'
    /home/dnwtechc/public_html/pm/config/../vendor/plugins/engines/lib/engines/plugi n.rb:122:in `migrate'
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:8
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:5:in `each'
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:5
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `call'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:578:in `invoke_with_call_chai n'
    /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:571:in `invoke_with_call_chai n'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:564:in `invoke'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2027:in `invoke_task'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_h andling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1999:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1977:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_h andling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1974:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/bin/rake:31
    /usr/bin/rake:19:in `load'
    /usr/bin/rake:19

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Galaxy King wrote:

Mats - thanks for looking into it. I have run it with --trace. Any clue?

It looks like the migrate doesn't create the dashboards table as it should. Have you checked your database to see if it is there? If it's not you could try to manually create it and then try migrate_plugins again. This is the only option I can think of at the moment. Here is a dump of my dashboards table:

DROP TABLE IF EXISTS `dashboards`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dashboards` (
  `id` int(11) NOT NULL auto_increment,
  `project_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

Rander Castro wrote:

Thanks, Mats. I will wait for the fix!

I'm sorry that the fix hasn't been released yet. I'm moving again and that's consuming all my time at the moment. It's probably going to take a couple of days before I have the time to fix it. You could try the link below just to be able to access the settings page until the fix is done:

http://127.0.0.1:3000/dashboard/settings/<project identifier>

Note that you'll have to change the ip-address to your ip-address and the project identifier to the identifier of your project :)

The link above would allow you to enter the settings page and change the settings. You'll still get the 404 page not found message when you submit but the settings gets saved at least. This is only meant as a temporary fix. I'll fix this problem as soon as I can!

Kind regards,

Mats.

RE: Redmine Scrumdashboard plugin - Added by Rander Castro over 15 years ago

Thanks Mats!

I have done this. I alredy working with Dashboard! I linking this tool. Congratulations!

RE: Redmine Scrumdashboard plugin - Added by Galaxy King over 15 years ago

Mats Klepsland wrote:

Galaxy King wrote:

Mats - thanks for looking into it. I have run it with --trace. Any clue?

It looks like the migrate doesn't create the dashboards table as it should. Have you checked your database to see if it is there? If it's not you could try to manually create it and then try migrate_plugins again. This is the only option I can think of at the moment. Here is a dump of my dashboards table:

[...]

Rander Castro wrote:

Thanks, Mats. I will wait for the fix!

I'm sorry that the fix hasn't been released yet. I'm moving again and that's consuming all my time at the moment. It's probably going to take a couple of days before I have the time to fix it. You could try the link below just to be able to access the settings page until the fix is done:

[...]

Note that you'll have to change the ip-address to your ip-address and the project identifier to the identifier of your project :)

The link above would allow you to enter the settings page and change the settings. You'll still get the 404 page not found message when you submit but the settings gets saved at least. This is only meant as a temporary fix. I'll fix this problem as soon as I can!

Kind regards,

Mats.

Thanks Mats. I got another error..

[dnwtechc@server30 pm]$ rake db:migrate_plugins RAILS_ENV=production --trace
(in /home/dnwtechc/public_html/pm)
  • Invoke db:migrate_plugins (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute db:migrate_plugins
    Migrating engines...
    Migrating actionwebservice...
    Migrating acts_as_activity_provider...
    Migrating acts_as_attachable...
    Migrating acts_as_customizable...
    Migrating acts_as_event...
    Migrating acts_as_list...
    Migrating acts_as_searchable...
    Migrating acts_as_tree...
    Migrating acts_as_versioned...
    Migrating acts_as_watchable...
    Migrating awesome_nested_set...
    Migrating classic_pagination...
    Migrating coderay-0.7.6.227...
    Migrating gloc-1.1.0...
    Migrating gravatar...
    Migrating redmine_issues_group...
    Migrating redmine_scrumdashboard...
    3 MoreMaintrackers: migrating ============================================
    -- add_column(:dashboard_trackers, :maintracker, :integer, {:default=>0})
    rake aborted!
    Mysql::Error: Table 'dnwtechc_redmine.dashboard_trackers' doesn't exist: ALTER TABLE `dashboard_trackers` ADD `maintracker` int(11) DEFAULT 0
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:302:in `execute'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:189:in `add_column'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:346:in `send'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:346:in `method_missing'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:326:in `say_with_time'
    /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:326:in `say_with_time'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:342:in `method_missing'
    /home/dnwtechc/public_html/pm/vendor/plugins/redmine_scrumdashboard/db/migrate/003_more_maintrackers.rb:21:in `up_without_benchmarks'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `send'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate'
    /usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:455:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `each'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:373:in `up'
    /home/dnwtechc/public_html/pm/vendor/rails/activerecord/lib/active_record/migration.rb:356:in `migrate'
    /home/dnwtechc/public_html/pm/vendor/plugins/engines/lib/engines/plugin/migrator.rb:23:in `migrate_plugin'
    /home/dnwtechc/public_html/pm/config/../vendor/plugins/engines/lib/engines/plugin.rb:122:in `migrate'
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:8
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:5:in `each'
    /home/dnwtechc/public_html/pm/lib/tasks/migrate_plugins.rake:5
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `call'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in `execute'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:578:in `invoke_with_call_chain'
    /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:571:in `invoke_with_call_chain'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:564:in `invoke'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2027:in `invoke_task'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `each'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_handling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1999:in `top_level'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1977:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_handling'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1974:in `run'
    /usr/lib/ruby/gems/1.8/gems/rake-0.8.4/bin/rake:31
    /usr/bin/rake:19:in `load'
    /usr/bin/rake:19

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Galaxy King wrote:

Thanks Mats. I got another error..

Have you checked that the user you are using for Redmine is allowed to create and alter tables in the database?

RE: Redmine Scrumdashboard plugin - Added by Galaxy King over 15 years ago

Yes, just double checked. It has all privileges.

RE: Redmine Scrumdashboard plugin - Added by Mats Klepsland over 15 years ago

Galaxy King wrote:

Yes, just double checked. It has all privileges.

I have no idea why it won't work even when your database user is allowed to create tables. The only "solution" I see to this problem is to manually import the database tables. The reason why I've put quotes around solution is because this is not really a solution. At best it is a dirty fix, but it is the only one I can offer you at the moment. It's up to you to decide if it's worth the hassle of having to move the plugin folder (redmine_scrumdashboard) away from "vendor/plugins" every time you are doing a migrate because it will fail otherwise.

I personally thinks this looks like a database problem, but I'm working with limited information so it's not easy to tell. The only thing I know is that tables don't get created as they should. I attached a dump of the plugins database tables if you want to take a shoot at trying it. Good luck :)

Kind regards,

Mats.

dump.db (1.45 KB) dump.db
(26-50/137)