Project

General

Profile

Actions

Defect #16548

closed

Issue Start Date, Due Date problem

Added by lee han over 10 years ago. Updated over 10 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I attached screen shot.


Files

date problem.png (37.6 KB) date problem.png lee han, 2014-04-07 13:41
Actions #1

Updated by lee han over 10 years ago

Added more information.

Environment:
Redmine version 2.4.4.stable
Ruby version 2.1.1-p76 (2014-02-24) [x86_64-linux]
Rails version 3.2.17
Environment production
Database adapter PostgreSQL (9.1)

SCM:
Subversion 1.7.14

Actions #2

Updated by Toshi MARUYAMA over 10 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

It seems you use plugin or modification.
Clean Redmine start and dute date format are 'YYYY-MM-DD'.

Actions #3

Updated by Toshi MARUYAMA over 10 years ago

lee han wrote:

Ruby version 2.1.1-p76 (2014-02-24) [x86_64-linux]

Ruby 2.1.1 is broken.
See #16194.

Actions #4

Updated by lee han over 10 years ago

Toshi MARUYAMA wrote:

lee han wrote:

Ruby version 2.1.1-p76 (2014-02-24) [x86_64-linux]

Ruby 2.1.1 is broken.
See #16194.

I downgrade ruby to 2.0.0. but still problem..

Redmine version 2.4.4.stable
Ruby version 2.0.0-p451 (2014-02-24) [x86_64-linux]
Rails version 3.2.17
Environment production
Database adapter PostgreSQL
SCM:
Subversion 1.7.14

Actions #5

Updated by lee han over 10 years ago

  • Status changed from Closed to Reopened
Actions #6

Updated by lee han over 10 years ago

I don't use any plugin or modification...

Toshi MARUYAMA wrote:

It seems you use plugin or modification.
Clean Redmine start and dute date format are 'YYYY-MM-DD'.

Actions #7

Updated by Toshi MARUYAMA over 10 years ago

  • Status changed from Reopened to Needs feedback
  • Resolution deleted (Invalid)

Check your issues table start_date and due_date types are date.

redmine_test=# \d issues
                                        Table "public.issues" 
      Column      |            Type             |                      Modifiers                      
------------------+-----------------------------+-----------------------------------------------------
 id               | integer                     | not null default nextval('issues_id_seq'::regclass)
 tracker_id       | integer                     | not null
 project_id       | integer                     | not null
 subject          | character varying(255)      | not null default ''::character varying
 description      | text                        | 
 due_date         | date                        | 
 category_id      | integer                     | 
 status_id        | integer                     | not null
 assigned_to_id   | integer                     | 
 priority_id      | integer                     | not null
 fixed_version_id | integer                     | 
 author_id        | integer                     | not null
 lock_version     | integer                     | not null default 0
 created_on       | timestamp without time zone | 
 updated_on       | timestamp without time zone | 
 start_date       | date                        | 
 done_ratio       | integer                     | not null default 0
 estimated_hours  | double precision            | 
 parent_id        | integer                     | 
 root_id          | integer                     | 
 lft              | integer                     | 
 rgt              | integer                     | 
 is_private       | boolean                     | not null default false
 closed_on        | timestamp without time zone | 
Indexes:
    "issues_pkey" PRIMARY KEY, btree (id)
    "index_issues_on_assigned_to_id" btree (assigned_to_id)
    "index_issues_on_author_id" btree (author_id)
    "index_issues_on_category_id" btree (category_id)
    "index_issues_on_created_on" btree (created_on)
    "index_issues_on_fixed_version_id" btree (fixed_version_id)
    "index_issues_on_priority_id" btree (priority_id)
    "index_issues_on_root_id_and_lft_and_rgt" btree (root_id, lft, rgt)
    "index_issues_on_status_id" btree (status_id)
    "index_issues_on_tracker_id" btree (tracker_id)
    "issues_project_id" btree (project_id)

Actions #8

Updated by lee han over 10 years ago

Toshi MARUYAMA wrote:

Check your issues table start_date and due_date types are date.

[...]

Oh!!!!!! thanks for your advice!
problem is due_date, start_date column type!!
My DB is setting timestamp type...
so, I change column type. And work very well~~

Actions #9

Updated by Toshi MARUYAMA over 10 years ago

  • Status changed from Needs feedback to Closed
  • Resolution set to Invalid

Thank you for your feedback.

Actions

Also available in: Atom PDF