Project

General

Profile

Error using Easy Gantt Pro Plugin installed with Microsoft SQL Server database

Added by Renato Santos de Souza over 7 years ago

We are facing an error using Easy Gantt Pro Redmine Plugin (https://www.redmine.org/plugins/easy-gantt) installed with Microsoft SQL Server database.

The application log reports:

NoMethodError (undefined method `-' for "2014-07-07":String):
  plugins/easy_gantt/app/controllers/easy_gantt_controller.rb:223:in `build_dates'
  plugins/easy_gantt/app/controllers/easy_gantt_controller.rb:38:in `projects'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

This is occurring due to the statement "(starts.min || ends.min || Date.today)" form method "build_dates" (see code below) is returning a string type and expected should be date type (then substract 1 day from this value).

    def build_dates(data, starts, ends)
      starts = data.map(&starts).compact
      ends = data.map(&ends).compact

      @start_date = (starts.min || ends.min || Date.today) - 1.day
      @end_date = (ends.max || starts.max || Date.today) + 1.day
    end

The problem is probably related with the the database adaptor to SQL Server database. We are using the following ruby gems to access database: "tiny_tds" (0.6.3.rc2) and "activerecord-sqlserver-adapter" (4.2.18). Also using SQL Server client "freetds" (0.91-6).