Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- HTTP/1.1 500 Internal Server Error
- Server: openresty/1.9.15.1
- Date: Wed, 16 Jan 2019 13:17:03 GMT
- Content-Type: text/plain; charset=utf-8
- Content-Length: 16224
- Connection: keep-alive
- X-Frame-Options: SAMEORIGIN
- InterfaceError at /api/v1/get_dialogs/
- Error binding parameter 0 - probably unsupported type.
- Request Method: GET
- Request URL: http://apiextra.pythonanywhere.com/api/v1/get_dialogs/
- Django Version: 2.1.3
- Python Executable: /usr/local/bin/uwsgi
- Python Version: 3.7.0
- Python Path: ['/home/apiextra/Extra', '/var/www', '.', '', '/var/www', '/usr/lib/python37.zip', '/usr/lib/python3.7', '/usr/lib/python3.7/lib-dynload', '/home/apiextra/env/lib/python3.7/site-packages']
- Server time: Wed, 16 Jan 2019 13:17:03 +0000
- Installed Applications:
- ['rest_framework_swagger',
- 'django.contrib.admin',
- 'django.contrib.auth',
- 'django.contrib.contenttypes',
- 'django.contrib.sessions',
- 'django.contrib.messages',
- 'django.contrib.staticfiles',
- 'rest_framework',
- 'rest_framework.authtoken',
- 'rest_framework_jwt',
- 'djoser',
- 'api',
- 'rest_framework_raml']
- Installed 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']
- Traceback:
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute
- 296. return Database.Cursor.execute(self, query, params)
- The above exception (Error binding parameter 0 - probably unsupported type.) was the direct cause of the following exception:
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
- 100. return super().execute(sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
- 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
- 77. return executor(sql, params, many, context)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/utils.py" in __exit__
- 89. raise dj_exc_value.with_traceback(traceback) from exc_value
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute
- 296. return Database.Cursor.execute(self, query, params)
- During handling of the above exception (Error binding parameter 0 - probably unsupported type.), another exception occurred:
- File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
- 34. response = get_response(request)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
- 126. response = self.process_exception_by_middleware(e, request)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
- 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
- 54. return view_func(*args, **kwargs)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/views/generic/base.py" in view
- 68. return self.dispatch(request, *args, **kwargs)
- File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
- 495. response = self.handle_exception(exc)
- File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
- 455. self.raise_uncaught_exception(exc)
- File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
- 492. response = handler(request, *args, **kwargs)
- File "/home/apiextra/Extra/api/views.py" in get
- 223. for dialog in dialogs.all():
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
- 268. self._fetch_all()
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in _fetch_all
- 1186. self._result_cache = list(self._iterable_class(self))
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
- 54. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
- 1065. cursor.execute(sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
- 104. sql = self.db.ops.last_executed_query(self.cursor, sql, params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/operations.py" in last_executed_query
- 142. params = self._quote_params_for_last_executed_query(params)
- File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/operations.py" in _quote_params_for_last_executed_query
- 131. return cursor.execute(sql, params).fetchone()
- Exception Type: InterfaceError at /api/v1/get_dialogs/
- Exception Value: Error binding parameter 0 - probably unsupported type.
- Request information:
- USER: 817026713349
- GET: No GET data
- POST: No POST data
- FILES: No FILES data
- COOKIES: No cookie data
- META:
- CONTENT_LENGTH = ''
- CONTENT_TYPE = ''
- DOCUMENT_ROOT = '/usr/local/openresty/nginx/html'
- HTTP_ACCEPT = 'application/json'
- HTTP_ACCEPT_ENCODING = 'gzip,deflate'
- HTTP_AUTHORIZATION = 'Token 712dce72f30bd26439bf401125ddc51a1dcabb74'
- HTTP_CONNECTION = 'close'
- HTTP_HOST = 'apiextra.pythonanywhere.com'
- HTTP_USER_AGENT = 'Apache-HttpClient/4.5.6 (Java/1.8.0_152-release)'
- HTTP_X_FORWARDED_FOR = '223.218.48.5'
- HTTP_X_REAL_IP = '223.218.48.5'
- PATH_INFO = '/api/v1/get_dialogs/'
- QUERY_STRING = ''
- REMOTE_ADDR = '10.0.0.53'
- REMOTE_PORT = '49808'
- REQUEST_METHOD = 'GET'
- REQUEST_URI = '/api/v1/get_dialogs/'
- SCRIPT_NAME = ''
- SERVER_NAME = 'apiextra.pythonanywhere.com'
- SERVER_PORT = '80'
- SERVER_PROTOCOL = 'HTTP/1.1'
- uwsgi.node = b'giles-liveweb6'
- uwsgi.version = b'2.0.17.1'
- wsgi.errors = <uwsgi_file__bin_user_wsgi_wrapper.ErrorLogFile object at 0x7f7831e0b978>
- wsgi.file_wrapper = ''
- wsgi.input = <uwsgi._Input object at 0x7f782b9a3438>
- wsgi.multiprocess = False
- wsgi.multithread = False
- wsgi.run_once = False
- wsgi.url_scheme = 'http'
- wsgi.version = '(1, 0)'
- Settings:
- Using settings module Extra.settings
- ABSOLUTE_URL_OVERRIDES = {}
- ADMINS = []
- ALLOWED_HOSTS = ['apiextra.pythonanywhere.com', '*']
- APPEND_SLASH = True
- AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
- AUTH_PASSWORD_VALIDATORS = '********************'
- AUTH_USER_MODEL = 'auth.User'
- BASE_DIR = '/home/apiextra/Extra'
- 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': {'ENGINE': 'django.db.backends.sqlite3', 'NAME': '/home/apiextra/Extra/db.sqlite3', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'USER': '', 'PASSWORD': '********************', 'HOST': '', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
- 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 = ['rest_framework_swagger', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'rest_framework.authtoken', 'rest_framework_jwt', 'djoser', 'api', 'rest_framework_raml']
- INTERNAL_IPS = []
- LANGUAGES = [('af', 'Afrikaans'), ('ar', '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'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('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'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')]
- LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
- LANGUAGE_CODE = 'en-US'
- LANGUAGE_COOKIE_AGE = None
- LANGUAGE_COOKIE_DOMAIN = None
- LANGUAGE_COOKIE_NAME = 'django_language'
- LANGUAGE_COOKIE_PATH = '/'
- LOCALE_PATHS = []
- LOGGING = {}
- LOGGING_CONFIG = 'logging.config.dictConfig'
- LOGIN_REDIRECT_URL = '/accounts/profile/'
- LOGIN_URL = 'rest_framework:login'
- LOGOUT_REDIRECT_URL = None
- LOGOUT_URL = 'rest_framework:logout'
- MANAGERS = []
- MEDIA_ROOT = '/home/apiextra/Extra/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
- ONE_SIGNAL_API_URL = '********************'
- ONE_SIGNAL_APP_ID = '3f553466-3626-4a08-9b21-e1a506564913'
- ONE_SIGNAL_TOKEN = '********************'
- PASSWORD_HASHERS = '********************'
- PASSWORD_RESET_TIMEOUT_DAYS = '********************'
- PREPEND_WWW = False
- REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication', 'rest_framework.authentication.SessionAuthentication'), 'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAdminUser',), 'DEFAULT_METADATA_CLASS': 'rest_framework.metadata.SimpleMetadata'}
- ROOT_URLCONF = 'Extra.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 = 'Extra.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 = []
- STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
- STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
- STATIC_ROOT = '/home/apiextra/Extra/static'
- STATIC_URL = '/static/'
- SWAGGER_SETTINGS = {'SECURITY_DEFINITIONS': {'api_Key': '********************'}}
- SWAGGER_YAML_FILE = '/home/apiextra/Extra/api.yaml'
- TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, '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 = 'Extra.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.
- Response code: 500 (Internal Server Error); Time: 838ms; Content length: 16223 bytes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement