Project

General

Profile

Actions

Defect #13626

closed

Spent time report. Details: Week

Added by Maxim Drozdov over 11 years ago. Updated over 11 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

Hello, team!

The 1st system, where this bug appear.

We use:
  • Redmine 1.4.4.stable.10658 (version 2.3.0)
  • Ruby 1.8.7
  • Rails 2.3.14
  • RubyGems 1.8.24
  • MySQL 5.1.63

The 1st system, where this bug appear.

But we duplicated the database to the new server from the system above and installed the 2.3.0 Redmine version on the new server too. The configuration of te new server
  • Redmine 2.3.0.stable.11670
  • Ruby 1.9.2
  • Rails 3.2.13
  • RubyGems 1.3.7
  • MySQL 5.1.66

Way to this bug

  1. link Projects
  2. link Overall spent time
  3. button Report
  4. select the Date range From: date1 To date2
  5. Select Details:Week
  6. select Add:Project (or other)

Bug description: the number of hours in the right bottom corner of table does not correspond to the text "Total: NNN hours".

Note, if you choose another "Details" value on the 5th step (Year, Month or Days), the bug will not appear and the number of hours in the right bottom corner of table will correspond to the text "Total: NNN hours" always.

Please, note, that this problem is not related with:
  • the Defect #5329, because I didn't choose the first or the last week;
  • the Defect #13159, which seems to be duplicated from the #5329.

Files

Overall_spent_time_Details_Week.png (24.9 KB) Overall_spent_time_Details_Week.png 1. Overall spent time. Details: Week Maxim Drozdov, 2013-03-29 05:56
Project_spent_time_Details_Week_.png (16.2 KB) Project_spent_time_Details_Week_.png 2. Project spent time. Details: Week Maxim Drozdov, 2013-03-29 06:13
Project_spent_time_Details_Month_v.1.4.4_.png (15.6 KB) Project_spent_time_Details_Month_v.1.4.4_.png Project spent time. Details:Month Add:Activity v.1.4.4. Maxim Drozdov, 2013-04-01 14:58
Project_spent_time_Details_Year_v.1.4.4_.png (15.8 KB) Project_spent_time_Details_Year_v.1.4.4_.png Project spent time. Details:Year Add:Activity v.1.4.4. Maxim Drozdov, 2013-04-01 14:58
Project_spent_time_Details_Days_v.1.4.4_.png (18.6 KB) Project_spent_time_Details_Days_v.1.4.4_.png Project spent time. Details:Days Add:Activity v.1.4.4. Maxim Drozdov, 2013-04-01 14:58
Project_spent_time_Details_Days_Add_Activity_Member_Status_v.1.4.4.png (24.5 KB) Project_spent_time_Details_Days_Add_Activity_Member_Status_v.1.4.4.png Project spent time. Details:Days Add:Activity+Member+Status v.1.4.4. Maxim Drozdov, 2013-04-01 15:20
Project_spent_time_Details_Month_Add_Activity_Member_Status_v.1.4.4..png (18.7 KB) Project_spent_time_Details_Month_Add_Activity_Member_Status_v.1.4.4..png Project spent time. Details:Month Add:Activity+Member+Status v.1.4.4. Maxim Drozdov, 2013-04-01 15:20
Project_spent_time_Details_Week_Add_Activity_Member_Status_v.1.4.4..png (18.8 KB) Project_spent_time_Details_Week_Add_Activity_Member_Status_v.1.4.4..png Project spent time. Details:Week Add:Activity+Member+Status v.1.4.4. Maxim Drozdov, 2013-04-01 15:20
Project_spent_time_Details_Week_Add_Activity_Member_Status_v.2.3.0.png (19.8 KB) Project_spent_time_Details_Week_Add_Activity_Member_Status_v.2.3.0.png Project spent time. Details:Week Add:Activity+Member+Status v.2.3.0 Maxim Drozdov, 2013-04-01 15:29
Project_spent_time_Details_Days_Add_Activity_Member_Status_v.2.3.0.png (24.6 KB) Project_spent_time_Details_Days_Add_Activity_Member_Status_v.2.3.0.png Project spent time. Details:Days Add:Activity+Member+Status v.2.3.0 Maxim Drozdov, 2013-04-01 15:29
Project_spent_time_Details_Month_Add_Activity_Member_Status_v.2.3.0.png (18.8 KB) Project_spent_time_Details_Month_Add_Activity_Member_Status_v.2.3.0.png Project spent time. Details:Month Add:Activity+Member+Status v.2.3.0 Maxim Drozdov, 2013-04-01 15:29
time_entries_2013-03-11_2013-03-21.csv (145 KB) time_entries_2013-03-11_2013-03-21.csv Maxim Drozdov, 2013-04-02 07:21
Actions #1

Updated by Maxim Drozdov over 11 years ago

I've forgotten to write, that this bug appears in both systems (old 1.4.4 and new 2.3.0)

Actions #2

Updated by Filou Centrinov over 11 years ago

Do you have a screenshot for a concrete example?

Actions #3

Updated by Maxim Drozdov over 11 years ago

Filou Centrinov wrote:

Do you have a screenshot for a concrete example?

Hello Filou,

yes, please see the 1st screenshot i've attached.

I want to add some info that this bug appear by another way:
  1. choose some certain project;
  2. link the 'Overview' tab;
  3. link 'Report'
  4. select the Date range From: date1 To date2
  5. select 'Details':'Week'
  6. select 'Add':'Activity' or any other value

and this bug appear (see the 2nd screenshot).

Actions #4

Updated by Filou Centrinov over 11 years ago

Your screenshots are not made in 2.3, but I can hope that is looking the same in 2.3.
I can't reproduce this bug. May you can make some more analyze? Are the sums of a single activity correct? Add "Activity" and some more filter. May this helps you to locate the bug and us to reproduce your bug.

Actions #5

Updated by Maxim Drozdov over 11 years ago

Hello, Filou!

Your screenshots are not made in 2.3

Yes, that screenshots are made in v. Redmine 1.4.4.stable.10658
(version 2.3.0) was a misprint

May you can make some more analyze?

Yes, of course.

Are the sums of a single activity correct?

No, they aren't correct.
However, if I choose Details:Month or Details:Year or Details:Days, all sums will be correct (see the new screenshots).

Add "Activity" and some more filter.

I chose the Details:Week and set the "Add" parameter into these sequential order:
  1. Activity
  2. Member
  3. Status

then i got the same wrong view (see).

Investigation of the v.2.3.0

A result is the same (see screenshots for v.2.3.0).
"Details:Week" leads wrong sums.

Actions #6

Updated by Filou Centrinov over 11 years ago

For me it seems, that there is something wrong in the database. Could you apply the following script to your database?

SELECT (DATE_FORMAT(spent_on,'%v') - tweek) as week_diff
FROM time_entries
GROUP BY week_diff

The result should be:
week_diff
0

EDIT:
Or just upload the export from table time_entries:

SELECT *
FROM time_entries
WHERE spent_on >= '2013-03-11' AND
      spent_on <= '2013-03-21'

Actions #7

Updated by Maxim Drozdov over 11 years ago

Hello, Filou

SELECT (DATE_FORMAT(spent_on,'%v') - tweek) as week_diff
FROM time_entries
GROUP BY week_diff

The result should be:
week_diff
0
I got:
week_diff
0
1

Or just upload the export from table time_entries:

SELECT *
FROM time_entries
WHERE spent_on >= '2013-03-11' AND
spent_on <= '2013-03-21'

Please, see in the time_entries_2013-03-11_2013-03-21.csv

And note, that these troubles with the 'Details:Week' appeare in another time gaps (not only from 2013-03-11 to 2013-03-21).

Actions #8

Updated by Filou Centrinov over 11 years ago

Your weeks havn't been saved corretly in your database. Run this SQL-query to fix your database table:

UPDATE time_entries 
SET    tweek = DATE_FORMAT(spent_on,'%v');

I don't know how you got wrong values into your database. Let us know, if this bug occurs again.

Actions #9

Updated by Maxim Drozdov over 11 years ago

Hello, Filou!

Due to SQL-queries you recommended, this bug disappeared.

Thank you!

Actions #10

Updated by Etienne Massip over 11 years ago

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

Thank you.

Actions

Also available in: Atom PDF