+1

+1

Environment:
Redmine version 2.5.2.stable.13366
Ruby version 2.0.0-p481 (2014-05-08) [x86_64-linux]
Rails version 3.2.19
Environment production
Database adapter Mysql2
SCM:
Subversion 1.8.8
Git 1.9.1
Filesystem

+1

Feel free to ask if you need any details.

Hi guys, there are 3 issues describing this problem (#932, #900, and this one).

I decided to post my complete solution here because it is the oldest issue.

Source of the problem¶

I use scrum version 8.0.0

As the log says, Column 'start_date' in where clause is ambiguous

The column start_date is defined in table sprints but also in the core table of Redmine.

Summarized solution¶

1. renaming the ambiguous columns
2. refer to the new name in scrum plugin's code

Detailed solution (I assume you use MySQL)¶

1. Connect to your database : mysql --user=<mysql_user> --password=<mysql_password> <database_name>
2. Rename start_date column : ALTER TABLE sprints CHANGE start_date sprint_start_date date;
3. Rename end_date column (it is ambiguous too) : ALTER TABLE sprints CHANGE end_date sprint_end_date date;
4. Exit MySQL and go to your plugin's scrum directory : cd /<path_to_redmine/plugins/scrum/db/migrate
5. Edit the file 20130815170700_create_sprints.rb (the name may depend on your installation, look for *_create_sprints.rb)
6. Rename start_date and end_date for sprint_start_date and sprint_end_date
7. Reinstall the plugin : rake redmine:plugins:migrate RAILS_ENV=production
8. Restart your redmine : /etc/init.d/apache2 restart

Enjoy :)

Note : as I don't know how to develop in Ruby and don't have time to learn so I don't give a solution where the "migrate" script would do that automatically.
Now the solution is released I am pretty sure, that someone could create a patch that could rename the columns.

I use scrum version 8.0.0

I meant 0.8.0 off course.

Sorry,

I totally forgot to tell to modify the occurences of start_date in the plugin's code.

It appears heavier than just modify the core CalendarController of Redmine (as suggested here : https://redmine.ociotec.com/boards/11/topics/153?r=175#message-175) but I think it is more sustainable to modify the plugin's code.
Plugins should adapt to core, not the reverse.

7 files needs to update, replace the default start_date, end_date to new names consistent with the fields in database:

\htdocs\plugins\scrum\app\controllers\sprints_controller.rb
\htdocs\plugins\scrum\app\models\sprint.rb
\htdocs\plugins\scrum\app\views\post_its\sprint_board\_head.html.erb
\htdocs\plugins\scrum\app\views\projects\settings\_sprints.html.erb
\htdocs\plugins\scrum\app\views\sprints\_form.html.erb
\htdocs\plugins\scrum\app\views\sprints\edit_effort.html.erb
\htdocs\plugins\scrum\lib\scrum\project_patch.rb (2 hits)

then migrate the database and restart redmine, calendar can be available!

Thanks for the details.

Can you confirm that your Scrum plugin continues to work as before your modifications ?