'Portfolios with reviewers' report date calculation error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Confirmed
|
Medium
|
Unassigned |
Bug Description
Reports > Configure report > Dates: 14th March - 23rd April, 2022, Report type: Portfolios with reviewers
Tested in both mysql and postgres
When the dates in the institution_data table are within a certain range, all the information does not appear on the report.
Test cases:
Given there are two entry sets in the institution_data table (created by cron run each Monday) on these dates ('ctime') and the reporting time period is set to be between 14th March - 23rd April, 2022, in this case we only get data from the 18th April (despite the paginator counting 2 results):
2022-04-04 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
AND
2022-04-11 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
However, for the same reporting period, we get BOTH results when the entries in the table are the following:
2022-03-21 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
And..
2022-03-28 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
The theory is that it's something to do with Daylight Savings time, which comes into effect on 2nd of April. Specifically, line 2450 in htdocs/
description: | updated |
Changed in mahara: | |
status: | Incomplete → Confirmed |
importance: | Undecided → Medium |
What are possible solutions?