compserv / hknweb

The new HKN website (using Django, hopefully at hkn.eecs.berkeley.edu soon)
https://dev-hkn.eecs.berkeley.edu
MIT License
19 stars 113 forks source link

Phantom event on google calendar #537

Open lo-maxwell opened 1 year ago

lo-maxwell commented 1 year ago

If a user adds the event calendar to their personal google calendar and then an event date is changed, it is not deleted from their personal calendar (a second event will appear with the correct time that can be rsvped to, but the old event is just floating there and cannot be interacted with).

"Hey y'all, is there a way to have events removed from google calendar if they're removed from the hkn calendar? I have a few "phantom events" that were deleted off the hkn calendar but I can't get them off my calendar"

lo-maxwell commented 1 year ago

Also if someone uses emojis in the event name it creates the event fine in google calendar but crashes dev-hkn, which can cause buildup of multiple bad events on google calendar. Look into doing all or nothing for creation of events (or do dev-hkn first, then gCal, then rollback if gCal fails)

bri25yu commented 1 year ago

From @oliver-ni: hknweb uses OCF's mysql database server which uses utf8mb4 encoding which is 4 bytes and supports emojis. So the database encoding itself may not be the problem, maybe it's the database encoding setting on the Django side https://github.com/compserv/hknweb/blob/master/hknweb/settings/common.py#L106

oliver-ni commented 1 year ago

Emoji issue has been fixed in #551