MarcelRobitaille / nextcloud_google_synchronization

🇬 Google integration into Nextcloud
GNU Affero General Public License v3.0
19 stars 2 forks source link

UTF 8 Error #17

Open CreativePR opened 4 months ago

CreativePR commented 4 months ago

Which version of synchronization_google are you using?

2.1.1

Which version of Nextcloud are you using?

28.0.4

Which browser are you using? In case you are using the phone App, specify the Android or iOS version and device please.

NA

Describe the Bug

Error - "message": "Error when creating calendar event \"\" An exception occurred while executing a query: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding \"UTF8\": 0xd0\nCONTEXT: unnamed portal parameter $6", "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 16_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Mobile/15E148 Safari/604.1",

Expected Behavior

No error

To Reproduce

Synchronize Google calendar with Russian Cyrillic characters

MarcelRobitaille commented 4 months ago

Thanks for the bug report. Where do the Cyrillic characters appear in the calendar? In the calendar name? In an event title? In the event description? All of the above?

CreativePR commented 4 months ago

Thanks for the bug report. Where do the Cyrillic characters appear in the calendar? In the calendar name? In an event title? In the event description? All of the above?

I believe in the calendar name, but let me confirm that. I had the user doing some troubleshooting for some other issues and had them remove the affected calendars I'll have them put them back and give you some more detailed information.

CreativePR commented 4 months ago

Thanks for the bug report. Where do the Cyrillic characters appear in the calendar? In the calendar name? In an event title? In the event description? All of the above?

I think it might be in calendar name

Here is another error that is in logs

[google_synchronization] Warning: Error when creating calendar event "" An exception occurred while executing a query: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0xd0 CONTEXT: unnamed portal parameter $6 from ? by -- at May 11, 2024 at 7:16:32 AM

MarcelRobitaille commented 3 months ago

@CreativePR Can you please provide an example calendar name that triggers this error?

CreativePR commented 2 months ago

I'll check at my next opportunity