mahara-contributors team mailing list archive

[mafen <1846750@xxxxxxxxxxxxxxxxxx>]

We are still on Mahara Version 19.04.0 (2019031906) and we are still
having this problem.


@Robert
SELECT @@global.time_zone, @@session.time_zone;
Output: SYSTEM/SYSTEM
SELECT TIMESTAMPDIFF(HOUR, UTC_TIMESTAMP(), NOW()) AS tz_offset;
Output: 2


"date" command on server shows:
Do 16. Jul 14:59:26 CEST 2020
This is the correct time here right now.


Infos about database: SHOW VARIABLES LIKE "%version%";

innodb_version: 5.5.61-MariaDB-38.13
protocol_version: 10
version: 5.5.65-MariaDB


Client OS: Windows 10 Enterprise 1909 (but also other Win10 non Enterprise and earlier Versions)


Browser:
Chrome Version 83.0.4103.97
Firefox 78.0.2
Microsoft Edge
(but also earlier Versions)


Like i said before:

This only happens when I select a date which is in winter time (Winterzeit MEZ/CET UTC+1)
It doesn' happen when I select a date which is in summer time (Sommerzeit MESZ/CEST UTC+2)

For example saving 2020/07/16 works correctly.
But saving 2020/11/16 ends up showing as 2020/11/15 after saving.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1846750

Title:
  Datepicker saves wrong date (1 day back)

Status in Mahara:
  New

Bug description:
  When creating a new 'task' under 'plans'
  (/artefact/plans/new.php?id=xxxxx) or editing a task
  (/artefact/plans/edit/task.php?id=xxxx) the date i select for
  'completion date' is being saved incorrectly.

  I select '2019/10/31' in the datepicker.
  The input field shows '2019/10/31' correctly.
  After I click 'save task' it then shows '2019/10/30' in the task overview. (which is one day before my selected date)

  This only happens when I select a date which is in winter time (Winterzeit MEZ: UTC+1)
  It doesn' happen when I select a date which is in summer time (Sommerzeit MESZ: UTC+2)

  Under siteconfiguration i have set country and timezone correctly.

  I can imagine thatthe problem is somewhere in the conversion to UTC,
  but i dont know how to fix it in my case.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1846750/+subscriptions