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