Project

General

Profile

Actions

Defect #5822

closed

Problem with Gantt and Calendar with SQL Server 2005

Added by Victor Hugo Bueno Silva over 14 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2010-07-05
Due date:
% Done:

0%

Estimated time:
Resolution:
Wont fix
Affected version:

Description

OS: Windows Server 2003
Database: SQL Server 2005
Ruby: ruby 1.8.7 (2010-01-10 patchlevel 249) [i386-mingw32]
Rails: 2.3.8
Redmine: 0.9.3
(gem) ruby-odbc (0.99991)
(gem) activerecord-sqlserver-adapter (2.3.8)

When acessing the calendar page for a project, the calendar appears empty. And when trying to acess the gantt page, the following error shows up on the log file. I guess it is a datetime format problem, but I could not find anything related around.

Rendering template within layouts/base
Rendering issues/gantt.rhtml

ActionView::TemplateError (comparison of Date with Time failed) on line #186 of app/views/issues/gantt.rhtml:
183:     i_done_date = (i_done_date <= @gantt.date_from ? @gantt.date_from : i_done_date )
184:     i_done_date = (i_done_date >= @gantt.date_to ? @gantt.date_to : i_done_date )
185:     
186:     i_late_date = [i_end_date, Date.today].min if i_start_date < Date.today
187:     
188:     i_left = ((i_start_date - @gantt.date_from)*zoom).floor     
189:     i_width = ((i_end_date - i_start_date + 1)*zoom).floor - 2                  # total width of the issue (- 2 for left and right borders)

    app/views/issues/gantt.rhtml:186:in `each'
    app/views/issues/gantt.rhtml:186:in `min'
    app/views/issues/gantt.rhtml:186:in `_run_rhtml_app47views47issues47gantt46rhtml'
    app/views/issues/gantt.rhtml:177:in `each'
    app/views/issues/gantt.rhtml:177:in `_run_rhtml_app47views47issues47gantt46rhtml'
    app/controllers/issues_controller.rb:384
    app/controllers/issues_controller.rb:383:in `gantt'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:76:in `pre_process'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:74:in `catch'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:74:in `pre_process'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:57:in `process'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:42:in `receive_data'
    eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
    eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/backends/base.rb:57:in `start'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/server.rb:156:in `start'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/controllers/controller.rb:80:in `start'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:177:in `send'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:177:in `run_command'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:143:in `run!'
    C:/server/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/bin/thin:6
    C:/server/ruby/bin/thin:19:in `load'
    C:/server/ruby/bin/thin:19

Rendering C:/server/localhost/redmine/public/500.html (500 Internal Server Error)

Files


Related issues

Related to Redmine - Feature #12713: Microsoft SQLServer supportClosedJean-Philippe Lang

Actions
Actions

Also available in: Atom PDF