Redmine

rake db:migrate : no messages.

SQL Server 2005.
Plugins:
- DMSF v1.4.5 stable
- Redmine Impasse plugin : 1.2.2
- Issue CheckList plugin: 2.0.0
- Stealth plugin : 0.6.0
- Sidebar content: 0.1.0

Columns in issue table seems Ok (both are date format).

Sorry, not exactly same error on log file :)

ActionView::Template::Error (can't convert Date into an exact number)
89:
90: # Width of the entire chart
91: g_width = ((@gantt.date_to - @gantt.date_from + 1) * zoom).to_i
92: @gantt.render(:top => headers_height + 8,
93: :zoom => zoom,
94: :g_width => g_width,
95: :subject_width => subject_width)
lib/redmine/helpers/gantt.rb:641:in `coordinates'
lib/redmine/helpers/gantt.rb:289:in `line_for_project'

Stéphane POTTIER wrote:

My base is now Under SQL Server 2008 -

Did you backup/restore from SQL Server 2005 or recreate the database from migration?

Edit:

Can you give me more information about database config (database encoding, ...) so i can look further to a solution.

All default, no specific configuration is needed.

I did a backup/restore from SQL Server 2005, and change due_date / start_date to date type in management studio (with migration it was in datetime).

Stéphane POTTIER wrote:

I did a backup/restore from SQL Server 2005, and change due_date / start_date to date type in management studio (with migration it was in datetime).

Could you run migration to create the schema objects then restore data only?

Calendar error resolved (with date type) but gantt style on error.

Message change in log file:

ActionView::Template::Error (comparison of Date with Time failed):
89:
90: # Width of the entire chart
91: g_width = ((@gantt.date_to - @gantt.date_from + 1) * zoom).to_i
92: @gantt.render(:top => headers_height + 8,
93: :zoom => zoom,
94: :g_width => g_width,
95: :subject_width => subject_width)

Stéphane POTTIER wrote:

Calendar error resolved (with date type) but gantt style on error.

I'm sorry, what do you mean exactly?

Don't be sorry :)

Issues now appear in calendar vue but i've still get error 500 on gantt visualisation.

Ok, could you please give the full error stack (the lines starting with lib/redmine/helpers) then?

Here is the log. Thanks again

Started GET "/redmine/projects/si-rh-tdc/issues/gantt" for 172.18.1.23 at 2013-03-22 16:42:03 +0100
Processing by GanttsController#show as HTML
Parameters: {"project_id"=>"si-rh-tdc"}
Current user: spottier (id=1)
Rendered queries/_filters.html.erb (31.3ms)
Rendered gantts/show.html.erb within layouts/base (93.8ms)
Completed 500 Internal Server Error in 1000ms

ActionView::Template::Error (comparison of Date with Time failed):
89:
90: # Width of the entire chart
91: g_width = ((@gantt.date_to - @gantt.date_from + 1) * zoom).to_i
92: @gantt.render(:top => headers_height + 8,
93: :zoom => zoom,
94: :g_width => g_width,
95: :subject_width => subject_width)
app/models/project.rb:561:in `each'
app/models/project.rb:561:in `max'
app/models/project.rb:561:in `due_date'
app/models/project.rb:568:in `overdue?'
lib/redmine/helpers/gantt.rb:271:in `subject_for_project'
lib/redmine/helpers/gantt.rb:210:in `render_project'
lib/redmine/helpers/gantt.rb:201:in `block in render'
app/models/project.rb:733:in `block in project_tree'
app/models/project.rb:729:in `each'
app/models/project.rb:729:in `project_tree'
lib/redmine/helpers/gantt.rb:199:in `render'
app/views/gantts/show.html.erb:92:in `_app_views_gantts_show_html_erb__326700193_30497328'
app/controllers/gantts_controller.rb:43:in `block (2 levels) in show'
app/controllers/gantts_controller.rb:42:in `show'

Is the 'effective_date' of your 'versions' table a date too?

Hi,

That's it ! The effective_date type in versions table was wrong.

Thanks a lot for your help!

Stéphane POTTIER wrote:

That's it ! The effective_date type in versions table was wrong.

Although it should not be if you created this table from migration in SQL Server 2008?

Wow, I finally understood why we're having issues on our Redmine installation from reading that bug...

We've been using an MS SQL 2005, which does NOT support DATE field types, it only has DATETIME or SMALLDATETIME or TIMESTAMP, which all include the time in the output.

The conclusion is that indeed, Redmine is NOT compatible with MS SQL 2005...