sklarsa / django-sendgrid-v5

An implementation of Django's EmailBackend compatible with sendgrid-python v5+
MIT License
323 stars 54 forks source link

Database error in Django 3.2.5. and django-sendgrid-v5 v5 0.9.1 #88

Closed nokemono closed 3 years ago

nokemono commented 3 years ago

django-sendgrid-v5 v5 0.9.1 does not seem to be supported by Django 3.2.5.

sklarsa commented 3 years ago

Are you getting any errors? Can you post a stack trace?

On Jul 18, 2021, at 12:22 AM, nokemono @.***> wrote:

 django-sendgrid-v5 v5 0.9.1 does not seem to be supported by Django 3.2.5.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

nokemono commented 3 years ago

DatabaseError at /accounts/password/reset/ No exception message supplied Request Method: POST Request URL: http://localhost:56000/accounts/password/reset/ Django Version: 3.2.5 Exception Type: DatabaseError Exception Location: C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\cursor.py, line 59, in execute Python Executable: C:\Users\dxdt\AppData\Local\Programs\Python\Python37\python.exe Python Version: 3.7.8 Python Path:
['F:\Project\TestDjango\TestDjango', 'F:\Project\TestDjango\TestDjango', 'C:\Users\dxdt\AppData\Local\Programs\Python\Python37\python37.zip', 'C:\Users\dxdt\AppData\Local\Programs\Python\Python37\DLLs', 'C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib', 'C:\Users\dxdt\AppData\Local\Programs\Python\Python37', 'C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages'] Server time: Mon, 19 Jul 2021 11:06:50 +0000 Traceback Switch to copy-and-paste view C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\cursor.py, line 56, in execute params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 783, in init self._query = self.parse() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 875, in parse raise e … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 856, in parse return handler(self, statement) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 932, in _select return SelectQuery(self.db, self.connection_properties, sm, self._params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 116, in init super().init(args) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 62, in init self.parse() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\query.py, line 152, in parse self.where = WhereConverter(self, statement) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\converters.py, line 27, in init self.parse() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\converters.py, line 122, in parse params=self.query.params … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\operators.py, line 476, in init self.evaluate() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\operators.py, line 465, in evaluate op.evaluate() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\operators.py, line 465, in evaluate op.evaluate() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\operators.py, line 279, in evaluate raise SQLDecodeError … ▶ Local vars The above exception ( Keyword: None Sub SQL: None FAILED SQL: ('SELECT "account_emailaddress"."id", "account_emailaddress"."user_id", "account_emailaddress"."email", "account_emailaddress"."verified", "account_emailaddress"."primary" FROM "account_emailaddress" INNER JOIN "custom_user" ON ("account_emailaddress"."user_id" = "custom_user"."id") WHERE ("account_emailaddress"."email" iLIKE %(0)s AND "custom_user"."is_active")',) Params: (('TestDjangotest3@gmail.com',),) Version: 1.3.3) was the direct cause of the following exception: C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 84, in _execute return self.cursor.execute(sql, params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\cursor.py, line 59, in execute raise db_exe from e … ▶ Local vars The above exception () was the direct cause of the following exception: C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\exception.py, line 47, in inner response = get_response(request) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py, line 181, in _get_response response = wrapped_callback(request, callback_args, callback_kwargs) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\views\generic\base.py, line 70, in view return self.dispatch(request, *args, *kwargs) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\views\generic\base.py, line 98, in dispatch return handler(request, args, kwargs) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\allauth\account\views.py, line 101, in post if form.is_valid(): … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\forms.py, line 175, in is_valid return self.is_bound and not self.errors … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\forms.py, line 170, in errors self.full_clean() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\forms.py, line 372, in full_clean self._clean_fields() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\forms.py, line 393, in _cleanfields value = getattr(self, 'clean%s' % name)() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\allauth\account\forms.py, line 525, in clean_email self.users = filter_users_by_email(email, is_active=True) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\allauth\account\utils.py, line 427, in filter_users_by_email for e in mails.prefetch_related("user"): … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py, line 280, in iter self._fetch_all() … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py, line 1324, in _fetch_all self._result_cache = list(self._iterable_class(self)) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py, line 51, in iter results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\compiler.py, line 1175, in execute_sql cursor.execute(sql, params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 98, in execute return super().execute(sql, params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 75, in _execute_with_wrappers return executor(sql, params, many, context) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 84, in _execute return self.cursor.execute(sql, params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py, line 90, in exit raise dj_exc_value.with_traceback(traceback) from exc_value … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\utils.py, line 84, in _execute return self.cursor.execute(sql, params) … ▶ Local vars C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\cursor.py, line 59, in execute raise db_exe from e … ▶ Local vars Request information USER AnonymousUser

GET No GET data

POST Variable Value csrfmiddlewaretoken '60g6WadcObISZmWAFIYpolrC59oUQNShoGIAldub1LU0fvqqEz1Yqd11Jdt0cDrT' email
'TestDjangotest3@gmail.com' FILES No FILES data

COOKIES Variable Value messages
('b5f2b03c5657914e354ea751ec0817c872084cab$[["json_message",0,25,"You have ' 'signed out."],["__json_message",0,25,"Successfully signed in as ' 'TestDjango.test@gmail.com."],["json_message",0,25,"Password successfully ' 'changed."],["json_message",0,25,"Password successfully ' 'changed."],["__json_message",0,25,"Password successfully ' 'changed."],["json_message",0,20,"Confirmation e-mail sent to ' 'TestDjangotest3@gmail.com."],["json_message",0,25,"You have confirmed ' 'TestDjangotest3@gmail.com."],["json_message",0,25,"Successfully signed in as ' 'TestDjangotest3@gmail.com."]]') sessionid
'nvjanxg8nkljw0rkrqtcl479u1ldfegc' META Variable Value ALLUSERSPROFILE 'C:\ProgramData' APPDATA 'C:\Users\dxdt\AppData\Roaming' COMMONPROGRAMFILES
'C:\Program Files\Common Files' COMMONPROGRAMFILES(X86) 'C:\Program Files (x86)\Common Files' COMMONPROGRAMW6432
'C:\Program Files\Common Files' COMPLUS_INSTALLROOT '' COMPLUS_VERSION '' COMPUTERNAME
'ENERMAX' COMSPEC 'C:\WINDOWS\system32\cmd.exe' CONTENT_LENGTH
'116' CONTENT_TYPE
'application/x-www-form-urlencoded' CSRF_COOKIE '6ogUn2oLd2g0uPQnJLt1BKTjXggd5Hzyo4IoM5FKqCs8KYkdICwADCtIBkljrx8a' DJANGO_SETTINGS_MODULE
'TestDjango.settings' DRIVERDATA
'C:\Windows\System32\Drivers\DriverData' FORCEIDENTITYAUTHENTICATIONTYPE 'Embedded' FPS_BROWSER_APP_PROFILE_STRING
'Internet Explorer' FPS_BROWSER_USER_PROFILE_STRING 'Default' GATEWAY_INTERFACE
'CGI/1.1' HOMEDRIVE
'C:' HOMEPATH
'\Users\dxdt' HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.9' HTTP_ACCEPT_ENCODING
'gzip, deflate, br' HTTP_ACCEPT_LANGUAGE
'ja-JP,ja;q=0.9,en-US;q=0.8,en;q=0.7' HTTP_CACHE_CONTROL
'max-age=0' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE ('messages="b5f2b03c5657914e354ea751ec0817c872084cab$[[\"
json_message\"\0540\05425\054\"You ' 'have signed ' 'out.\"]\054[\"
json_message\"\0540\05425\054\"Successfully signed ' 'in as ' 'TestDjango.test@gmail.com.\"]\054[\"json_message\"\0540\05425\054\"Password ' 'successfully ' 'changed.\"]\054[\"__json_message\"\0540\05425\054\"Password ' 'successfully ' 'changed.\"]\054[\"json_message\"\0540\05425\054\"Password ' 'successfully ' 'changed.\"]\054[\"json_message\"\0540\05420\054\"Confirmation ' 'e-mail sent to ' 'TestDjangotest3@gmail.com.\"]\054[\"__json_message\"\0540\05425\054\"You ' 'have confirmed ' 'TestDjangotest3@gmail.com.\"]\054[\"json_message\"\0540\05425\054\"Successfully ' 'signed in as TestDjangotest3@gmail.com.\"]]"; ' 'sessionid=nvjanxg8nkljw0rkrqtcl479u1ldfegc') HTTP_HOST
'localhost:56000' HTTP_ORIGIN 'http://localhost:56000' HTTP_REFERER
'http://localhost:56000/accounts/password/reset/' HTTP_SEC_CH_UA
'" Not;A Brand";v="99", "Google Chrome";v="91", "Chromium";v="91"' HTTP_SEC_CH_UA_MOBILE
'?0' HTTP_SEC_FETCH_DEST 'document' HTTP_SEC_FETCH_MODE 'navigate' HTTP_SEC_FETCH_SITE 'same-origin' HTTP_SEC_FETCH_USER '?1' HTTP_UPGRADE_INSECURE_REQUESTS
'1' HTTP_USER_AGENT ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like ' 'Gecko) Chrome/91.0.4472.124 Safari/537.36') LOCALAPPDATA
'C:\Users\dxdt\AppData\Local' LOGONSERVER '\\ENERMAX' MEMU_PATH
'C:\Program Files (x86)\Microvirt' MSBUILDLOADMICROSOFTTARGETSREADONLY 'true' NUMBER_OF_PROCESSORS
'8' ONEDRIVE
'C:\Users\dxdt\OneDrive' OS
'Windows_NT' PATH
('C:\Program Files (x86)\Intel\Intel(R) Management Engine ' 'Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine ' 'Components\iCLS\;C:\Program Files (x86)\Common ' 'Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program ' 'Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA ' 'Corporation\NVIDIA NvDLISR;C:\Users\dxdt\.dnx\bin;C:\Program ' 'Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL ' 'Server\130\Tools\Binn\;C:\Program Files (x86)\Intel\Intel(R) ' 'Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) ' 'Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) ' 'Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) ' 'Management Engine Components\IPT;C:\Program Files\dotnet\;C:\Program ' 'Files\WinMerge;C:\Program Files\TortoiseGit\bin;C:\Program ' 'Files\Git\cmd;C:\Program Files (x86)\GnuWin32\bin;C:\Program Files ' '(x86)\curl-7.73.0-win64-mingw\bin;;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program ' 'Files\Microsoft SQL Server\Client ' 'SDK\ODBC\170\Tools\Binn\;C:\Program ' 'Files\Docker\Docker\resources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Users\dxdt\AppData\Local\Microsoft\WindowsApps;;C:\Users\dxdt\AppData\Local\Programs\Microsoft ' 'VS Code\bin;C:\Users\dxdt\.dotnet\tools') PATHEXT '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC' PATH_INFO
'/accounts/password/reset/' PKGDEFAPPLICATIONCONFIGFILE 'C:\Users\dxdt\AppData\Local\Microsoft\VisualStudio\16.0_fcbf9ac1\devenv.exe.config' PROCESSOR_ARCHITECTURE
'AMD64' PROCESSOR_IDENTIFIER
'Intel64 Family 6 Model 158 Stepping 9, GenuineIntel' PROCESSOR_LEVEL '6' PROCESSOR_REVISION
'9e09' PROGRAMDATA 'C:\ProgramData' PROGRAMFILES
'C:\Program Files' PROGRAMFILES(X86)
'C:\Program Files (x86)' PROGRAMW6432
'C:\Program Files' PSMODULEPATH
('C:\Program ' 'Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program ' 'Files\Intel\Wired Networking\') PUBLIC
'C:\Users\Public' PYTHONIOENCODING
'utf-8' PYTHONPATH
'F:\Project\TestDjango\TestDjango\' PYTHONUNBUFFERED
'1' QUERY_STRING
'' REMOTE_ADDR '127.0.0.1' REMOTE_HOST '' REQUEST_METHOD
'POST' SCRIPT_NAME '' SERVER_HOST 'localhost' SERVER_NAME 'kubernetes.docker.internal' SERVER_PORT '56000' SERVER_PROTOCOL 'HTTP/1.1' SERVER_SOFTWARE 'WSGIServer/0.2' SERVICEHUBLOGSESSIONKEY '****' SESSIONNAME 'Console' SIGNINWITHHOMETENANTONLY
'False' SYSTEMDRIVE 'C:' SYSTEMROOT
'C:\WINDOWS' TEMP
'C:\Users\dxdt\AppData\Local\Temp' THREADEDWAITDIALOGDPICONTEXT
'-4' TMP 'C:\Users\dxdt\AppData\Local\Temp' USERDOMAIN
'ENERMAX' USERDOMAIN_ROAMINGPROFILE
'ENERMAX' USERNAME
'dxdt' USERPROFILE 'C:\Users\dxdt' VISUALSTUDIODIR 'C:\Users\dxdt\Documents\Visual Studio 2019' VISUALSTUDIOEDITION 'Microsoft Visual Studio Community 2019' VISUALSTUDIOVERSION '16.0' VS140COMNTOOLS
'C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools\' VSAPPIDDIR
('C:\Program Files (x86)\Microsoft Visual ' 'Studio\2019\Community\Common7\IDE\') VSAPPIDNAME 'devenv.exe' VSLANG
'1041' VSSKUEDITION
'Community' WINDIR
'C:\WINDOWS' _PTVS_PID
'13948' wsgi.errors <colorama.ansitowin32.StreamWrapper object at 0x000001B3EA609C08> wsgi.file_wrapper
<class 'wsgiref.util.FileWrapper'> wsgi.input
<django.core.handlers.wsgi.LimitedStream object at 0x000001B3EBB35788> wsgi.multiprocess
False wsgi.multithread
True wsgi.run_once
False wsgi.url_scheme 'http' wsgi.version
(1, 0) Settings Using settings module TestDjango.settings Setting Value ABSOLUTE_URL_OVERRIDES
{} ACCOUNT_AUTHENTICATION_METHOD
'email' ACCOUNT_CONFIRM_EMAIL_ON_GET
True ACCOUNT_EMAIL_CONFIRMATION_ANONYMOUS_REDIRECT_URL
'/' ACCOUNT_EMAIL_CONFIRMATION_EXPIRE_DAYS
1 ACCOUNT_EMAIL_REQUIRED
True ACCOUNT_EMAIL_VERIFICATION
'mandatory' ACCOUNT_LOGOUT_REDIRECT_URL '/' ACCOUNT_USERNAME_REQUIRED
False ACCOUNT_USER_MODEL_USERNAME_FIELD
None ADMINS
[] ALLOWED_HOSTS
['*'] APPEND_SLASH
True AUTHENTICATION_BACKENDS ['django.contrib.auth.backends.ModelBackend'] AUTH_PASSWORD_VALIDATORS
'****' AUTH_USER_MODEL 'app.CustomUser' BASE_DIR
'F:\Project\TestDjango\TestDjango' CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} CACHE_MIDDLEWARE_ALIAS
'default' CACHE_MIDDLEWARE_KEY_PREFIX '****' CACHE_MIDDLEWARE_SECONDS
600 CSRF_COOKIE_AGE 31449600 CSRF_COOKIE_DOMAIN
None CSRF_COOKIE_HTTPONLY
False CSRF_COOKIE_NAME
'csrftoken' CSRF_COOKIE_PATH
'/' CSRF_COOKIE_SAMESITE
'Lax' CSRF_COOKIE_SECURE
False CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure' CSRF_HEADER_NAME
'HTTP_X_CSRFTOKEN' CSRF_TRUSTED_ORIGINS
[] CSRF_USE_SESSIONS
True DATABASES
{'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CLIENT': {'host': 'mongodb://TestDjango:@localhost:47019/TestDjango_user_account_db'}, 'CONN_MAX_AGE': 0, 'ENGINE': 'djongo', 'HOST': '', 'NAME': 'TestDjango_user_account_db', 'OPTIONS': {}, 'PASSWORD': '****', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIGRATE': True, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': ''}} DATABASE_ROUTERS
[] DATA_UPLOAD_MAX_MEMORY_SIZE 2621440 DATA_UPLOAD_MAX_NUMBER_FIELDS
1000 DATETIME_FORMAT 'N j, Y, P' DATETIME_INPUT_FORMATS
['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M'] DATE_FORMAT 'N j, Y' DATE_INPUT_FORMATS
['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y'] DEBUG
True DEBUG_PROPAGATE_EXCEPTIONS
False DECIMAL_SEPARATOR
'.' DEFAULT_AUTO_FIELD
'django.db.models.AutoField' DEFAULT_CHARSET 'utf-8' DEFAULT_EXCEPTION_REPORTER
'django.views.debug.ExceptionReporter' DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter' DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage' DEFAULT_FROM_EMAIL
'認証 test.auth@gmail.com' DEFAULT_HASHING_ALGORITHM
'sha256' DEFAULT_INDEX_TABLESPACE
'' DEFAULT_TABLESPACE
'' DISALLOWED_USER_AGENTS
[] EMAIL_BACKEND
'sendgrid_backend.SendgridBackend' EMAIL_HOST
'localhost' EMAIL_HOST_PASSWORD '****' EMAIL_HOST_USER '' EMAIL_PORT
25 EMAIL_SSL_CERTFILE
None EMAIL_SSL_KEYFILE
'****' EMAIL_SUBJECT_PREFIX
'[Django] ' EMAIL_TIMEOUT
None EMAIL_USE_LOCALTIME False EMAIL_USE_SSL
False EMAIL_USE_TLS
False FILE_UPLOAD_DIRECTORY_PERMISSIONS
None FILE_UPLOAD_HANDLERS
['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] FILE_UPLOAD_MAX_MEMORY_SIZE 2621440 FILE_UPLOAD_PERMISSIONS 420 FILE_UPLOAD_TEMP_DIR
None FIRST_DAY_OF_WEEK
0 FIXTURE_DIRS
[] FORCE_SCRIPT_NAME
None FORMAT_MODULE_PATH
None FORM_RENDERER
'django.forms.renderers.DjangoTemplates' IGNORABLE_404_URLS
[] INSTALLED_APPS
['app', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.sites', 'allauth', 'allauth.account', 'allauth.socialaccount', 'bootstrap4'] INTERNAL_IPS
[] LANGUAGES
[('af', 'Afrikaans'), ('ar', 'Arabic'), ('ar-dz', 'Algerian Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('hy', 'Armenian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('ig', 'Igbo'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('ky', 'Kyrgyz'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('tg', 'Tajik'), ('th', 'Thai'), ('tk', 'Turkmen'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('uz', 'Uzbek'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')] LANGUAGES_BIDI
['he', 'ar', 'ar-dz', 'fa', 'ur'] LANGUAGE_CODE
'en-us' LANGUAGE_COOKIE_AGE None LANGUAGE_COOKIE_DOMAIN
None LANGUAGE_COOKIE_HTTPONLY
False LANGUAGE_COOKIE_NAME
'django_language' LANGUAGE_COOKIE_PATH
'/' LANGUAGE_COOKIE_SAMESITE
None LANGUAGE_COOKIE_SECURE
False LOCALE_PATHS
[] LOGGING {} LOGGING_CONFIG
'logging.config.dictConfig' LOGIN_REDIRECT_URL
'/' LOGIN_URL
'/' LOGOUT_REDIRECT_URL None MANAGERS
[] MEDIA_ROOT
'' MEDIA_URL
'/' MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage' MIDDLEWARE
['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] MIGRATION_MODULES
{} MONTH_DAY_FORMAT
'F j' NUMBER_GROUPING 0 PASSWORD_HASHERS
'****' PASSWORD_RESET_TIMEOUT
'****' PASSWORD_RESET_TIMEOUT_DAYS '****' PREPEND_WWW False ROOT_URLCONF
'TestDjango.urls' SECRET_KEY
'****' SECURE_BROWSER_XSS_FILTER
False SECURE_CONTENT_TYPE_NOSNIFF True SECURE_HSTS_INCLUDE_SUBDOMAINS
False SECURE_HSTS_PRELOAD False SECURE_HSTS_SECONDS 0 SECURE_PROXY_SSL_HEADER None SECURE_REDIRECT_EXEMPT
[] SECURE_REFERRER_POLICY
'same-origin' SECURE_SSL_HOST None SECURE_SSL_REDIRECT False SENDGRID_API_KEY
'****' SENDGRID_SANDBOX_MODE_IN_DEBUG
False SERVER_EMAIL
'認証 test.auth@gmail.com' SESSION_CACHE_ALIAS 'default' SESSION_COOKIE_AGE
1209600 SESSION_COOKIE_DOMAIN
None SESSION_COOKIE_HTTPONLY True SESSION_COOKIE_NAME 'sessionid' SESSION_COOKIE_PATH '/' SESSION_COOKIE_SAMESITE 'Lax' SESSION_COOKIE_SECURE
False SESSION_ENGINE
'django.contrib.sessions.backends.db' SESSION_EXPIRE_AT_BROWSER_CLOSE False SESSION_FILE_PATH
None SESSION_SAVE_EVERY_REQUEST
False SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer' SETTINGS_MODULE 'TestDjango.settings' SHORT_DATETIME_FORMAT
'm/d/Y P' SHORT_DATE_FORMAT
'm/d/Y' SIGNING_BACKEND 'django.core.signing.TimestampSigner' SILENCED_SYSTEM_CHECKS
[] SITE_ID 7 STATICFILES_DIRS
[] STATICFILES_FINDERS ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage' STATIC_ROOT None STATIC_URL
'/static/' TEMPLATES
[{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['F:\Project\TestDjango\TestDjango\app\templates', 'F:\Project\TestDjango\TestDjango\app\templates\allauth'], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}}] TEST_NON_SERIALIZED_APPS
[] TEST_RUNNER 'django.test.runner.DiscoverRunner' THOUSAND_SEPARATOR
',' TIME_FORMAT 'P' TIME_INPUT_FORMATS
['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] TIME_ZONE
'UTC' USE_I18N
True USE_L10N
True USE_THOUSAND_SEPARATOR
False USE_TZ
True USE_X_FORWARDED_HOST
False USE_X_FORWARDED_PORT
False WSGI_APPLICATION
'TestDjango.wsgi.application' X_FRAME_OPTIONS 'ALLOW' YEAR_MONTH_FORMAT
'F Y'

nokemono commented 3 years ago

It works fine for django ver 2.2.17

sklarsa commented 3 years ago

Based on the stack trace, it looks like an issue with MongoDB. See this line:

C:\Users\dxdt\AppData\Local\Programs\Python\Python37\lib\site-packages\djongo\sql2mongo\operators.py, line 279, in evaluate
raise SQLDecodeError …

I'm closing this issue because it's out of scope of this package. After further investigation, if you still believe that this Exception is related to this package, feel free to reopen this issue