Defect #13626
closedSpent time report. Details: Week
0%
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¶
- link Projects
- link Overall spent time
- button Report
- select the Date range From: date1 To date2
- Select Details:Week
- 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:Files
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)
Updated by Filou Centrinov over 11 years ago
Do you have a screenshot for a concrete example?
Updated by Maxim Drozdov over 11 years ago
- File Overall_spent_time_Details_Week.png Overall_spent_time_Details_Week.png added
- File Project_spent_time_Details_Week_.png Project_spent_time_Details_Week_.png added
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:- choose some certain project;
- link the 'Overview' tab;
- link 'Report'
- select the Date range From: date1 To date2
- select 'Details':'Week'
- select 'Add':'Activity' or any other value
and this bug appear (see the 2nd screenshot).
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.
Updated by Maxim Drozdov over 11 years ago
- File Project_spent_time_Details_Month_v.1.4.4_.png Project_spent_time_Details_Month_v.1.4.4_.png added
- File Project_spent_time_Details_Year_v.1.4.4_.png Project_spent_time_Details_Year_v.1.4.4_.png added
- File Project_spent_time_Details_Days_v.1.4.4_.png Project_spent_time_Details_Days_v.1.4.4_.png added
- File 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.png added
- File 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..png added
- File 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..png added
- File 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.png added
- File 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.png added
- File 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.png added
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).
I chose the Details:Week and set the "Add" parameter into these sequential order:Add "Activity" and some more filter.
- Activity
- Member
- 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.
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'
Updated by Maxim Drozdov over 11 years ago
Hello, Filou
I got:The result should be:
SELECT (DATE_FORMAT(spent_on,'%v') - tweek) as week_diff
FROM time_entries
GROUP BY week_diff
week_diff 0
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).
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.
Updated by Maxim Drozdov over 11 years ago
Hello, Filou!
Due to SQL-queries you recommended, this bug disappeared.
Thank you!
Updated by Etienne Massip over 11 years ago
- Status changed from New to Closed
- Resolution set to Invalid
Thank you.