gcalendarsync icon indicating copy to clipboard operation
gcalendarsync copied to clipboard

Published 20 hours ago • verified publisher icon Davepar

FATAL ERROR: all events are one day off (-1 day in calendar)

Open crysman opened this issue 3 years ago • 10 comments

I am unable to solve this FATAL ERROR: all events are one day off (-1 day in calendar) even though both sheet and calendar use the same GMT offset (+2):

Google Sheet: image

image

image image

Extension settings: image

Google Calendar: image

image

BTW, I must select "Athens" in Google Sheets, because "Prague" is for some reason listed incorrectly as GMT+1. When I select "Prague" in both, however, problem doesn't get fixed anyways.

Any ideas? Thanks!

crysman avatar Sep 02 '20 14:09 crysman

Hello, please, any info if this will be fixed? I mean: I can make all our events one day off, but that will make it unstable - when you release a fix, we will get one day off... Would be helpful if I knew realistically, what will happen in next 2 weeks, whether:

  1. I forcefully make all our events one day off (offset)
  2. Wait 2 weeks to have it fixed by developer(s) and so have it fixed by fixing the bug

Thanks a lot

crysman avatar Sep 07 '20 09:09 crysman

Sorry for these issues. It was partly caused by Google always assuming US/Pacific time zone. This should be fixed now. Re-open the issue if it isn't.

davepar avatar Sep 08 '20 03:09 davepar

Unfortunately, there is an error now: image image

and calendar is not synced :(

crysman avatar Sep 11 '20 08:09 crysman

@Davepar thanks for fixing the TypeError, unfortunately the original issue persists - in Google Calendar, all events are -1 day off :disappointed:

crysman avatar Sep 14 '20 17:09 crysman

To make it easier for you to debug, here are the resources:

sheet: https://docs.google.com/spreadsheets/d/1HvsaNjmquyga7ruJmEEPOLrPhbY8b4vRRFu99OdSxgw/edit#gid=901722093

calendar: [email protected]

please let us know soon what is going on here... thanks a lot!

itluzanky avatar Sep 15 '20 13:09 itluzanky

I can't seem to re-create this problem on my computer. I'm in the US/Pacific time zone (-7) and have no issues. I've set everything I can think of to New Zealand time (+12) which is a day ahead of me, and still have no issues syncing either way. I've found 4 different places to set time zone, in the sheet, in the specific calendar, in Calendar general settings, and on my computer.

I was able to make everything off by a day (including non-all day events) by setting both Calendar time zones to something different than my computer time zone. You have all 4 places I mentioned above set to the same time zone, right?

davepar avatar Sep 16 '20 01:09 davepar

Or this is interesting, the dates seem to actually start going off by one day when I set the "secondary time zone" in Calendar settings. When I unchecked "secondary time zone", still off by one day. It wasn't until I actually changed the secondary time zone to the same as my primary time zone that it was fixed. That seems like a bug in Calendar.

davepar avatar Sep 16 '20 01:09 davepar

I might have figured out the problem. I just uploaded a new version that uses the spreadsheet's time zone for all-day events. Hopefully that works for you.

davepar avatar Sep 16 '20 02:09 davepar

@Davepar thanks a lot - at last, this has fixed the problem ... well, almost :( - see #77

by the way... how do you feel about me posting so many issues - aren't you tired? I can imagine you've got other things to do than maintaining some side project - I want to add sincere thank you for providing us an open source piece of software and maintaining it - I do not take is as granted. Thanks!

itluzanky avatar Sep 16 '20 22:09 itluzanky

might be closed now I think https://github.com/Davepar/gcalendarsync/issues/76#issuecomment-695979460

itluzanky avatar Sep 21 '20 08:09 itluzanky