KryptedGaming / krypted

Community management platform by Krypted Gaming.
https://auth.kryptedgaming.com/
MIT License
8 stars 8 forks source link

Issues with Discord Connecter #393

Closed chadbob closed 3 years ago

chadbob commented 3 years ago

HTTP Version Not Supported: /discord/sso/callback

Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query db.query(q) File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1366, "Incorrect string value: '\xF0\x9D\x95\x8A\xF0\x9D...' for column 'username' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner response = get_response(request) File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response response = self.process_exception_by_middleware(e, request) File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response response = wrapped_callback(request, *callback_args, *callback_kwargs) File "/usr/local/lib/python3.6/site-packages/django_discord_connector/views.py", line 67, in sso_callback discord_user.save() File "/usr/local/lib/python3.6/site-packages/django_discord_connector/models.py", line 77, in save super(DiscordUser, self).save(args, **kwargs) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 744, in save force_update=force_update, update_fields=update_fields) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 782, in save_base force_update, using, update_fields, File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 854, in _save_table forced_update) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 903, in _do_update return filtered._update(values) > 0 File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 760, in _update return query.get_compiler(self.db).execute_sql(CURSOR) File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1471, in execute_sql cursor = super().execute_sql(result_type) File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1142, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line 89, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 312, in _query db.query(q) File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 224, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (1366, "Incorrect string value: '\xF0\x9D\x95\x8A\xF0\x9D...' for column 'username' at row 1")

porowns commented 3 years ago

What's the username?

chadbob commented 3 years ago

In Eve? Dagny Gulch Discord it's 𝕊𝕔𝕣𝕦𝕗𝕗𝕪 ℕ𝕖𝕣𝕗 ℍ𝕖𝕣𝕕𝕖𝕣#2219

porowns commented 3 years ago

The characters are probably tripping something off, we accept unicode symbols so I'm surprised if they're not in there though. Short term use normal characters, otherwise we can investigate a fix for the DB codepage

chadbob commented 3 years ago

Ahh got it, it's time to change it anyways has caused nothing but problems. Thanks.

chadbob commented 3 years ago

Yes that worked, Thank you very much!