{"action":"created","issue":{"url":"https://api.github.com/repos/writeas/writefreely/issues/51","repository_url":"https://api.github.com/repos/writeas/writefreely","labels_url":"https://api.github.com/repos/writeas/writefreely/issues/51/labels{/name}","comments_url":"https://api.github.com/repos/writeas/writefreely/issues/51/comments","events_url":"https://api.github.com/repos/writeas/writefreely/issues/51/events","html_url":"https://github.com/writeas/writefreely/issues/51","id":393801058,"node_id":"MDU6SXNzdWUzOTM4MDEwNTg=","number":51,"title":"Time/Date issue","user":{"login":"misaka00251","id":3908746,"node_id":"MDQ6VXNlcjM5MDg3NDY=","avatar_url":"https://avatars1.githubusercontent.com/u/3908746?v=4","gravatar_id":"","url":"https://api.github.com/users/misaka00251","html_url":"https://github.com/misaka00251","followers_url":"https://api.github.com/users/misaka00251/followers","following_url":"https://api.github.com/users/misaka00251/following{/other_user}","gists_url":"https://api.github.com/users/misaka00251/gists{/gist_id}","starred_url":"https://api.github.com/users/misaka00251/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/misaka00251/subscriptions","organizations_url":"https://api.github.com/users/misaka00251/orgs","repos_url":"https://api.github.com/users/misaka00251/repos","events_url":"https://api.github.com/users/misaka00251/events{/privacy}","received_events_url":"https://api.github.com/users/misaka00251/received_events","type":"User","site_admin":false},"labels":[{"id":574621721,"node_id":"MDU6TGFiZWw1NzQ2MjE3MjE=","url":"https://api.github.com/repos/writeas/writefreely/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/writeas/writefreely/milestones/9","html_url":"https://github.com/writeas/writefreely/milestone/9","labels_url":"https://api.github.com/repos/writeas/writefreely/milestones/9/labels","id":3830016,"node_id":"MDk6TWlsZXN0b25lMzgzMDAxNg==","number":9,"title":"0.7","description":"","creator":{"login":"thebaer","id":1138779,"node_id":"MDQ6VXNlcjExMzg3Nzk=","avatar_url":"https://avatars2.githubusercontent.com/u/1138779?v=4","gravatar_id":"","url":"https://api.github.com/users/thebaer","html_url":"https://github.com/thebaer","followers_url":"https://api.github.com/users/thebaer/followers","following_url":"https://api.github.com/users/thebaer/following{/other_user}","gists_url":"https://api.github.com/users/thebaer/gists{/gist_id}","starred_url":"https://api.github.com/users/thebaer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thebaer/subscriptions","organizations_url":"https://api.github.com/users/thebaer/orgs","repos_url":"https://api.github.com/users/thebaer/repos","events_url":"https://api.github.com/users/thebaer/events{/privacy}","received_events_url":"https://api.github.com/users/thebaer/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":1,"state":"open","created_at":"2018-11-19T03:09:03Z","updated_at":"2018-12-24T13:24:42Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2018-12-24T03:02:40Z","updated_at":"2018-12-24T15:52:55Z","closed_at":null,"author_association":"NONE","body":"### Describe the bug\r\nSo I'm in UTC+8, and I want to edit the post's time.\r\nAssume now my local time is `2018-10-04 17:43:00`.\r\nFirst, type the time and click save.\r\nThen for a few seconds, it changes the time to `2018-10-04 09:43:00` (minus 8 hours) and have a UTC outside the label.\r\nThen the page refreshed, and now it said the time is `2018-10-05 01:43:00` (plus another 8 hours).\r\n\r\n### Steps to reproduce (if necessary)\r\nSteps to reproduce the behavior:\r\n1. Post or edit any posts.\r\n2. Change the date.\r\n\r\n### Expected behavior\r\nSave my local time `2018-10-04 17:43:00`.\r\n\r\n### Application configuration\r\n - **Single mode** \r\n\r\n**Version or last commit**: 0.6.0"},"comment":{"url":"https://api.github.com/repos/writeas/writefreely/issues/comments/449748905","html_url":"https://github.com/writeas/writefreely/issues/51#issuecomment-449748905","issue_url":"https://api.github.com/repos/writeas/writefreely/issues/51","id":449748905,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0OTc0ODkwNQ==","user":{"login":"thebaer","id":1138779,"node_id":"MDQ6VXNlcjExMzg3Nzk=","avatar_url":"https://avatars2.githubusercontent.com/u/1138779?v=4","gravatar_id":"","url":"https://api.github.com/users/thebaer","html_url":"https://github.com/thebaer","followers_url":"https://api.github.com/users/thebaer/followers","following_url":"https://api.github.com/users/thebaer/following{/other_user}","gists_url":"https://api.github.com/users/thebaer/gists{/gist_id}","starred_url":"https://api.github.com/users/thebaer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thebaer/subscriptions","organizations_url":"https://api.github.com/users/thebaer/orgs","repos_url":"https://api.github.com/users/thebaer/repos","events_url":"https://api.github.com/users/thebaer/events{/privacy}","received_events_url":"https://api.github.com/users/thebaer/received_events","type":"User","site_admin":false},"created_at":"2018-12-24T15:52:55Z","updated_at":"2018-12-24T15:52:55Z","author_association":"MEMBER","body":"This happens because the app assumes your database timezone is set to UTC. So when updating post metadata, on the client-side it converts the time you supply into UTC (which you can see) and then stores that in the database.\r\n\r\nI could see a solution going one of two ways:\r\n\r\n* The app supports databases set to any time zone. Presumably, this would be for installs on personal computers, instead of servers. This potentially causes issues in locales that observe daylight savings time, or while traveling and changing timezones.\r\n* We add a requirement that the database timezone is set to UTC.\r\n\r\nI think the second solution would be the best, but I'm open to ideas / input from everyone else."}}
{"actor":{"display_login":"thebaer"}}