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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
