Project

General

Profile

Actions

Defect #12694

closed

Dates in issue journal

Added by Martin Valensky about 11 years ago. Updated about 11 years ago.

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

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

I use MS SQL 2008R2.
The problem is if I change the start date or due date on issue. The values are written to journal and in table journal_details are values and old values in format like mm-dd-yyyy, but the function for date conversion expects another format.
Problem is in file issues_helper.rb:

when 'due_date', 'start_date'
    value = format_date(detail.value.to_date) if detail.value
    old_value = format_date(detail.old_value.to_date) if detail.old_value

The workaround is to create custom function like this:
def format_date_mva(str_value)
    return str_value
end

and replace in code:
when 'due_date', 'start_date'
    value = format_date_mva(detail.value.to_date)
    old_value = format_date_mva(detail.old_value.to_date)

It shows wrong date format so this is cosmetic bug. I can live with that because I use it for private projects.

I'm running on 2.2.0


Related issues

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

Actions
Actions #1

Updated by Jean-Philippe Lang about 11 years ago

  • Category changed from Issues to Database
  • Status changed from New to Closed
  • Resolution set to Wont fix

I'm closing it, MSSQL is not supported.

Actions #2

Updated by Jean-Philippe Lang about 11 years ago

  • Resolution changed from Wont fix to Fixed

This was not a cosmetic bug, dates were not stored in journal_details as expected.
This is fixed in r11117, see #12713.

Actions

Also available in: Atom PDF