mahara-contributors team mailing list archive

[Steven <stevens@xxxxxxxxxxxxxxx>]

Preconditions:
-----------------------------
1. Admin sets site settings to country = Australia 
2. Admin sets the 
settings to Timezone = No Timezone Selected

Test Script:
-----------------------------
1. Log in as admin user 
2. Create a new user (User99) 
3. Log in as User99 
4. Browse to Main menu > Content > Profile > Contact information
5. Confirm that the "Country" field has auto selected the same country as Site settings (Australia) ✔
6. User create a new portfolio page (Timezone Test)
7. Note the date created (date/time) when viewing the displayed page (ie. Updated on 01 June 2018, 9:32 AM)
8. Log out and back in as admin user 
9. Browse to Admin menu > Configure site > Site options > Site Settings
10. Confirm that the "Contry" field has remained the same as original setting (Australia) ✔
11. Confirm that the "Timezone" field has auto selected to Antarctica/Macquaire   (This is expected behaviour) ✔

NOTE: Antarctica/Macquaire is (regionally part of Oceania and
politically a part of Tasmania, Australia, since 1900) and is
alphabetically first in the list of Australia time zones

12. Select "Australia/Perth" from the Timezone dropdown field and save site settings
13. Admin 
create a new portfolio page (Timezone Test2) 
14. Confirm 
the date created (date/time) when viewing the displayed page is Approximately 3 hours difference (Updated on 01 June 2018, 6:49 AM) ✔

NOTE: The Expected behaviour - If a country with multiple time zones is selected and timezone field is set to No Timezone Selected - when content is created the timezone used the first alphabetical timezone for that country
 
Catalyst QA Approved ✔

-- 
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:
  In Progress

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