← Back to team overview

mahara-contributors team mailing list archive

[Bug 1771362] [NEW] Times reported inaccurately when DB timezone does not match PHP timezone

 

Public bug reported:

See
https://wiki.mahara.org/index.php/System_Administrator%27s_Guide/Installing_Mahara/Troubleshooting#Q:_Time_zone_problems_.2F_Mahara_is_showing_incorrect_times_for_forum_posts
for a full breakdown of the problem.

TL,DR Mahara has no support for multiple timezones and assumes that the
PHP date.timezone and the database server's timezone are identical. If
they are not, then all dates that get stored into the database and
displayed back to the user will be off by (Database UTC offset - PHP UTC
offset).

** Affects: mahara
     Importance: Undecided
     Assignee: Mark Webster (mark-webster-v)
         Status: New

** Changed in: mahara
     Assignee: (unassigned) => Mark Webster (mark-webster-v)

-- 
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/1771362

Title:
  Times reported inaccurately when DB timezone does not match PHP
  timezone

Status in Mahara:
  New

Bug description:
  See
  https://wiki.mahara.org/index.php/System_Administrator%27s_Guide/Installing_Mahara/Troubleshooting#Q:_Time_zone_problems_.2F_Mahara_is_showing_incorrect_times_for_forum_posts
  for a full breakdown of the problem.

  TL,DR Mahara has no support for multiple timezones and assumes that
  the PHP date.timezone and the database server's timezone are
  identical. If they are not, then all dates that get stored into the
  database and displayed back to the user will be off by (Database UTC
  offset - PHP UTC offset).

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


Follow ups