the JSON object must be str, bytes or bytearray, not NoneType
Request Method: | GET |
---|---|
Request URL: | https://zrdp.data-geo.ru/dxl?zrdp=zr |
Django Version: | 2.1 |
Exception Type: | TypeError |
Exception Value: | the JSON object must be str, bytes or bytearray, not NoneType |
Exception Location: | /usr/lib/python3.8/json/__init__.py in loads, line 341 |
Python Executable: | /var/www/domains/zrdp/back/project_zrdp/bin/python3 |
Python Version: | 3.8.10 |
Python Path: | ['/var/www/domains/zrdp/back/project_zrdp/project_zrdp', '/var/www/domains/zrdp/back/project_zrdp/bin', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/var/www/domains/zrdp/back/project_zrdp/lib/python3.8/site-packages'] |
Server time: | Чт, 28 Мар 2024 19:45:24 +0300 |
/var/www/domains/zrdp/back/project_zrdp/lib/python3.8/site-packages/django/core/handlers/exception.py
in inner
This decorator is automatically applied to all middleware to ensure that
no middleware leaks an exception and that the next middleware in the stack
can rely on getting a response instead of an exception.
"""
@wraps(get_response)
def inner(request):
try:
response = get_response(request)...
except Exception as exc:
response = response_for_exception(request, exc)
return response
return inner
Variable | Value |
---|---|
exc | TypeError('the JSON object must be str, bytes or bytearray, not NoneType') |
get_response | <bound method BaseHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7fca10f11f70>> |
request | <WSGIRequest: GET '/dxl?zrdp=zr'> |
/var/www/domains/zrdp/back/project_zrdp/lib/python3.8/site-packages/django/core/handlers/base.py
in _get_response
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)
except Exception as e:
response = self.process_exception_by_middleware(e, request)...
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
view_name = callback.__name__
else: # CBV
Variable | Value |
---|---|
callback | <function download_excel_data at 0x7fca0cf99c10> |
callback_args | () |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fca0e545a30>> |
request | <WSGIRequest: GET '/dxl?zrdp=zr'> |
resolver | <URLResolver 'project_zrdp.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=app_main.views.download_excel_data, args=(), kwargs={}, url_name=download_excel_data, app_names=[], namespaces=[]) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fca10f11f70> |
wrapped_callback | <function download_excel_data at 0x7fca0cf99c10> |
/var/www/domains/zrdp/back/project_zrdp/lib/python3.8/site-packages/django/core/handlers/base.py
in _get_response
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)...
except Exception as e:
response = self.process_exception_by_middleware(e, request)
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
Variable | Value |
---|---|
callback | <function download_excel_data at 0x7fca0cf99c10> |
callback_args | () |
callback_kwargs | {} |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7fca0e545a30>> |
request | <WSGIRequest: GET '/dxl?zrdp=zr'> |
resolver | <URLResolver 'project_zrdp.urls' (None:None) '^/'> |
resolver_match | ResolverMatch(func=app_main.views.download_excel_data, args=(), kwargs={}, url_name=download_excel_data, app_names=[], namespaces=[]) |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fca10f11f70> |
wrapped_callback | <function download_excel_data at 0x7fca0cf99c10> |
/var/www/domains/zrdp/back/project_zrdp/project_zrdp/app_main/views.py
in download_excel_data
column_widths = {'A': 70, 'B': 70, 'C': 80, 'D': 95, 'E': 85, 'F': 150, 'G': 200, 'H': 75, 'I': 70, 'J': 65, 'K': 80, 'L': 100, 'M': 65, 'N': 160, 'O': 65}
else:
ws_title = 'Мировая статистика. Добыча, производство'
titles = dp_titles['full']
column_widths = {'A': 70, 'B': 80, 'C': 95, 'D': 150, 'E': 100, 'F': 75, 'G': 70, 'H': 65, 'I': 80, 'J': 100, 'K': 65, 'L': 160, 'M': 65}
qparams = request.GET.get('queryParams', None)
params = json.loads(qparams)...
wb = Workbook()
ws = wb.active
ws.append([ws_title])
Variable | Value |
---|---|
column_widths | {'A': 70, 'B': 70, 'C': 80, 'D': 95, 'E': 85, 'F': 150, 'G': 200, 'H': 75, 'I': 70, 'J': 65, 'K': 80, 'L': 100, 'M': 65, 'N': 160, 'O': 65} |
qparams | None |
request | <WSGIRequest: GET '/dxl?zrdp=zr'> |
titles | ['Год составления', 'Год актуальности данных', 'Регион', 'Страна', 'Страна прочая', 'Код страны', 'Группа', 'ПИ', 'Ед. изм.', 'Характеристика', 'Категория', 'Тип значения', 'Значение', 'Для расчетов', 'Для статистики', 'Доля в мире', 'Проверено', 'Примечание', 'Источник', 'Тип источника', 'Наименование материалов', 'Ссылка на web-страницу в интернете', 'Дата обращения/дата выхода материалов (день)', 'Дата обращения/дата выхода материалов (месяц)', 'Дата обращения/дата выхода материалов (год)', 'Страница', 'Источник в БД', 'Источник (2)', 'Тип источника (2)', 'Наименование материалов (2)', 'Ссылка на web-страницу в интернете (2)', 'Дата обращения/дата выхода материалов (день) (2)', 'Дата обращения/дата выхода материалов (месяц) (2)', 'Дата обращения/дата выхода материалов (год) (2)', 'Страница (2)', 'Источник в БД (2)'] |
ws_title | 'Мировая статистика. Запасы и ресурсы' |
zrdp | 'zr' |
/usr/lib/python3.8/json/__init__.py
in loads
"""
if isinstance(s, str):
if s.startswith('\ufeff'):
raise JSONDecodeError("Unexpected UTF-8 BOM (decode using utf-8-sig)",
s, 0)
else:
if not isinstance(s, (bytes, bytearray)):
raise TypeError(f'the JSON object must be str, bytes or bytearray, '...
f'not {s.__class__.__name__}')
s = s.decode(detect_encoding(s), 'surrogatepass')
if "encoding" in kw:
import warnings
warnings.warn(
Variable | Value |
---|---|
cls | None |
kw | {} |
object_hook | None |
object_pairs_hook | None |
parse_constant | None |
parse_float | None |
parse_int | None |
s | None |
AnonymousUser
Variable | Value |
---|---|
zrdp | 'zr' |
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
HTTP_ACCEPT | '*/*' |
HTTP_CONNECTION | 'close' |
HTTP_HOST | 'zrdp.data-geo.ru' |
HTTP_USER_AGENT | 'claudebot' |
HTTP_X_FORWARDED_FOR | '3.239.119.159' |
HTTP_X_FORWARDED_PROTO | 'https' |
HTTP_X_REAL_IP | '3.239.119.159' |
PATH_INFO | '/dxl' |
QUERY_STRING | 'zrdp=zr' |
RAW_URI | '/dxl?zrdp=zr' |
REMOTE_ADDR | '' |
REQUEST_METHOD | 'GET' |
SCRIPT_NAME | '' |
SERVER_NAME | 'zrdp.data-geo.ru' |
SERVER_PORT | '443' |
SERVER_PROTOCOL | 'HTTP/1.0' |
SERVER_SOFTWARE | 'gunicorn/19.9.0' |
gunicorn.socket | <socket.socket fd=3, family=AddressFamily.AF_UNIX, type=SocketKind.SOCK_STREAM, proto=0, laddr=/var/www/domains/zrdp/back/project_zrdp/project_zrdp/project.sock> |
wsgi.errors | <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7fca095024c0> |
wsgi.file_wrapper | '' |
wsgi.input | <gunicorn.http.body.Body object at 0x7fca09502490> |
wsgi.multiprocess | True |
wsgi.multithread | False |
wsgi.run_once | False |
wsgi.url_scheme | 'https' |
wsgi.version | (1, 0) |
project_zrdp.settings
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ADMINS | [] |
ALLOWED_HOSTS | ['zrdp.data-geo.ru', 'localhost'] |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
AUTH_PASSWORD_VALIDATORS | '********************' |
AUTH_USER_MODEL | 'auth.User' |
BASE_DIR | PosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp') |
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 | False |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql', 'HOST': 'localhost', 'NAME': 'zrdp', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'geodjango'}} |
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', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y'] |
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_CHARSET | 'utf-8' |
DEFAULT_CONTENT_TYPE | 'text/html' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
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_CHARSET | 'utf-8' |
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 | None |
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 | ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'app_main', 'app_reference', 'rest_framework', 'django_filters'] |
INTERNAL_IPS | ['127.0.0.1', '81.177.139.98', '10.100.18.198'] |
LANGUAGES | [('en', 'English'), ('ru', 'Russian')] |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
LANGUAGE_CODE | 'ru-RU' |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_COOKIE_DOMAIN | None |
LANGUAGE_COOKIE_NAME | 'django_language' |
LANGUAGE_COOKIE_PATH | '/' |
LOCALE_PATHS | [] |
LOGGING | {'disable_existing_loggers': False, 'formatters': {'simple': {'format': '{levelname} {message}', 'style': '{'}, 'verbose': {'format': '{levelname} {asctime} {message}', 'style': '{'}}, 'handlers': {'console': {'class': 'logging.StreamHandler', 'level': 'DEBUG'}, 'file_db': {'class': 'logging.FileHandler', 'filename': PurePosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp/log_db.log'), 'formatter': 'verbose', 'level': 'DEBUG'}, 'file_debug': {'class': 'logging.FileHandler', 'filename': PurePosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp/log_info.log'), 'formatter': 'verbose', 'level': 'INFO'}, 'file_error': {'class': 'logging.FileHandler', 'filename': PurePosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp/log_error.log'), 'formatter': 'verbose', 'level': 'ERROR'}, 'file_warn': {'class': 'logging.FileHandler', 'filename': PurePosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp/log_warn.log'), 'formatter': 'verbose', 'level': 'WARNING'}}, 'loggers': {'': {'handlers': ['file_warn'], 'level': 'WARNING', 'propagate': True}}, 'version': 1} |
LOGGING_CONFIG | 'logging.config.dictConfig' |
LOGIN_REDIRECT_URL | '/accounts/profile/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_REDIRECT_URL | None |
MANAGERS | [] |
MEDIA_ROOT | PurePosixPath('/var/www/domains/zrdp/back/project_zrdp/project_zrdp/media') |
MEDIA_URL | 'media/' |
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_DAYS | '********************' |
PREPEND_WWW | False |
ROOT_URLCONF | 'project_zrdp.urls' |
SECRET_KEY | '********************' |
SECURE_BROWSER_XSS_FILTER | False |
SECURE_CONTENT_TYPE_NOSNIFF | False |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
SECURE_HSTS_PRELOAD | False |
SECURE_HSTS_SECONDS | 0 |
SECURE_PROXY_SSL_HEADER | None |
SECURE_REDIRECT_EXEMPT | [] |
SECURE_SSL_HOST | None |
SECURE_SSL_REDIRECT | False |
SERVER_EMAIL | 'root@localhost' |
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 | 'project_zrdp.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SILENCED_SYSTEM_CHECKS | [] |
STATICFILES_DIRS | ['/var/www/domains/zrdp/back/project_zrdp/project_zrdp/project_zrdp/static'] |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '/var/www/domains/zrdp/back/project_zrdp/project_zrdp/static/' |
STATIC_URL | '/static/' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], '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 | 'Europe/Moscow' |
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 | 'project_zrdp.wsgi.application' |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
YEAR_MONTH_FORMAT | 'F Y' |
You're seeing this error because you have DEBUG = True
in your
Django settings file. Change that to False
, and Django will
display a standard page generated by the handler for this status code.