· 7 years ago · Jan 16, 2019, 01:22 PM
1HTTP/1.1 500 Internal Server Error
2Server: openresty/1.9.15.1
3Date: Wed, 16 Jan 2019 13:17:03 GMT
4Content-Type: text/plain; charset=utf-8
5Content-Length: 16224
6Connection: keep-alive
7X-Frame-Options: SAMEORIGIN
8
9InterfaceError at /api/v1/get_dialogs/
10Error binding parameter 0 - probably unsupported type.
11
12Request Method: GET
13Request URL: http://apiextra.pythonanywhere.com/api/v1/get_dialogs/
14Django Version: 2.1.3
15Python Executable: /usr/local/bin/uwsgi
16Python Version: 3.7.0
17Python 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']
18Server time: Wed, 16 Jan 2019 13:17:03 +0000
19Installed Applications:
20['rest_framework_swagger',
21 'django.contrib.admin',
22 'django.contrib.auth',
23 'django.contrib.contenttypes',
24 'django.contrib.sessions',
25 'django.contrib.messages',
26 'django.contrib.staticfiles',
27 'rest_framework',
28 'rest_framework.authtoken',
29 'rest_framework_jwt',
30 'djoser',
31 'api',
32 'rest_framework_raml']
33Installed Middleware:
34['django.middleware.security.SecurityMiddleware',
35 'django.contrib.sessions.middleware.SessionMiddleware',
36 'django.middleware.common.CommonMiddleware',
37 'django.middleware.csrf.CsrfViewMiddleware',
38 'django.contrib.auth.middleware.AuthenticationMiddleware',
39 'django.contrib.messages.middleware.MessageMiddleware',
40 'django.middleware.clickjacking.XFrameOptionsMiddleware']
41
42
43Traceback:
44
45File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
46 85. return self.cursor.execute(sql, params)
47
48File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute
49 296. return Database.Cursor.execute(self, query, params)
50
51The above exception (Error binding parameter 0 - probably unsupported type.) was the direct cause of the following exception:
52
53File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
54 100. return super().execute(sql, params)
55
56File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
57 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
58
59File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
60 77. return executor(sql, params, many, context)
61
62File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
63 85. return self.cursor.execute(sql, params)
64
65File "/home/apiextra/env/lib/python3.7/site-packages/django/db/utils.py" in __exit__
66 89. raise dj_exc_value.with_traceback(traceback) from exc_value
67
68File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
69 85. return self.cursor.execute(sql, params)
70
71File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" in execute
72 296. return Database.Cursor.execute(self, query, params)
73
74During handling of the above exception (Error binding parameter 0 - probably unsupported type.), another exception occurred:
75
76File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
77 34. response = get_response(request)
78
79File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
80 126. response = self.process_exception_by_middleware(e, request)
81
82File "/home/apiextra/env/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
83 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
84
85File "/home/apiextra/env/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
86 54. return view_func(*args, **kwargs)
87
88File "/home/apiextra/env/lib/python3.7/site-packages/django/views/generic/base.py" in view
89 68. return self.dispatch(request, *args, **kwargs)
90
91File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
92 495. response = self.handle_exception(exc)
93
94File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
95 455. self.raise_uncaught_exception(exc)
96
97File "/home/apiextra/env/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
98 492. response = handler(request, *args, **kwargs)
99
100File "/home/apiextra/Extra/api/views.py" in get
101 223. for dialog in dialogs.all():
102
103File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
104 268. self._fetch_all()
105
106File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in _fetch_all
107 1186. self._result_cache = list(self._iterable_class(self))
108
109File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
110 54. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
111
112File "/home/apiextra/env/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
113 1065. cursor.execute(sql, params)
114
115File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
116 104. sql = self.db.ops.last_executed_query(self.cursor, sql, params)
117
118File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/operations.py" in last_executed_query
119 142. params = self._quote_params_for_last_executed_query(params)
120
121File "/home/apiextra/env/lib/python3.7/site-packages/django/db/backends/sqlite3/operations.py" in _quote_params_for_last_executed_query
122 131. return cursor.execute(sql, params).fetchone()
123
124Exception Type: InterfaceError at /api/v1/get_dialogs/
125Exception Value: Error binding parameter 0 - probably unsupported type.
126Request information:
127USER: 817026713349
128
129GET: No GET data
130
131POST: No POST data
132
133FILES: No FILES data
134
135COOKIES: No cookie data
136
137META:
138CONTENT_LENGTH = ''
139CONTENT_TYPE = ''
140DOCUMENT_ROOT = '/usr/local/openresty/nginx/html'
141HTTP_ACCEPT = 'application/json'
142HTTP_ACCEPT_ENCODING = 'gzip,deflate'
143HTTP_AUTHORIZATION = 'Token 712dce72f30bd26439bf401125ddc51a1dcabb74'
144HTTP_CONNECTION = 'close'
145HTTP_HOST = 'apiextra.pythonanywhere.com'
146HTTP_USER_AGENT = 'Apache-HttpClient/4.5.6 (Java/1.8.0_152-release)'
147HTTP_X_FORWARDED_FOR = '223.218.48.5'
148HTTP_X_REAL_IP = '223.218.48.5'
149PATH_INFO = '/api/v1/get_dialogs/'
150QUERY_STRING = ''
151REMOTE_ADDR = '10.0.0.53'
152REMOTE_PORT = '49808'
153REQUEST_METHOD = 'GET'
154REQUEST_URI = '/api/v1/get_dialogs/'
155SCRIPT_NAME = ''
156SERVER_NAME = 'apiextra.pythonanywhere.com'
157SERVER_PORT = '80'
158SERVER_PROTOCOL = 'HTTP/1.1'
159uwsgi.node = b'giles-liveweb6'
160uwsgi.version = b'2.0.17.1'
161wsgi.errors = <uwsgi_file__bin_user_wsgi_wrapper.ErrorLogFile object at 0x7f7831e0b978>
162wsgi.file_wrapper = ''
163wsgi.input = <uwsgi._Input object at 0x7f782b9a3438>
164wsgi.multiprocess = False
165wsgi.multithread = False
166wsgi.run_once = False
167wsgi.url_scheme = 'http'
168wsgi.version = '(1, 0)'
169
170Settings:
171Using settings module Extra.settings
172ABSOLUTE_URL_OVERRIDES = {}
173ADMINS = []
174ALLOWED_HOSTS = ['apiextra.pythonanywhere.com', '*']
175APPEND_SLASH = True
176AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
177AUTH_PASSWORD_VALIDATORS = '********************'
178AUTH_USER_MODEL = 'auth.User'
179BASE_DIR = '/home/apiextra/Extra'
180CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
181CACHE_MIDDLEWARE_ALIAS = 'default'
182CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
183CACHE_MIDDLEWARE_SECONDS = 600
184CSRF_COOKIE_AGE = 31449600
185CSRF_COOKIE_DOMAIN = None
186CSRF_COOKIE_HTTPONLY = False
187CSRF_COOKIE_NAME = 'csrftoken'
188CSRF_COOKIE_PATH = '/'
189CSRF_COOKIE_SAMESITE = 'Lax'
190CSRF_COOKIE_SECURE = False
191CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
192CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
193CSRF_TRUSTED_ORIGINS = []
194CSRF_USE_SESSIONS = False
195DATABASES = {'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}}}
196DATABASE_ROUTERS = []
197DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
198DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
199DATETIME_FORMAT = 'N j, Y, P'
200DATETIME_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']
201DATE_FORMAT = 'N j, Y'
202DATE_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']
203DEBUG = True
204DEBUG_PROPAGATE_EXCEPTIONS = False
205DECIMAL_SEPARATOR = '.'
206DEFAULT_CHARSET = 'utf-8'
207DEFAULT_CONTENT_TYPE = 'text/html'
208DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
209DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
210DEFAULT_FROM_EMAIL = 'webmaster@localhost'
211DEFAULT_INDEX_TABLESPACE = ''
212DEFAULT_TABLESPACE = ''
213DISALLOWED_USER_AGENTS = []
214EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
215EMAIL_HOST = 'localhost'
216EMAIL_HOST_PASSWORD = '********************'
217EMAIL_HOST_USER = ''
218EMAIL_PORT = 25
219EMAIL_SSL_CERTFILE = None
220EMAIL_SSL_KEYFILE = '********************'
221EMAIL_SUBJECT_PREFIX = '[Django] '
222EMAIL_TIMEOUT = None
223EMAIL_USE_LOCALTIME = False
224EMAIL_USE_SSL = False
225EMAIL_USE_TLS = False
226FILE_CHARSET = 'utf-8'
227FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
228FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
229FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
230FILE_UPLOAD_PERMISSIONS = None
231FILE_UPLOAD_TEMP_DIR = None
232FIRST_DAY_OF_WEEK = 0
233FIXTURE_DIRS = []
234FORCE_SCRIPT_NAME = None
235FORMAT_MODULE_PATH = None
236FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
237IGNORABLE_404_URLS = []
238INSTALLED_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']
239INTERNAL_IPS = []
240LANGUAGES = [('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')]
241LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
242LANGUAGE_CODE = 'en-US'
243LANGUAGE_COOKIE_AGE = None
244LANGUAGE_COOKIE_DOMAIN = None
245LANGUAGE_COOKIE_NAME = 'django_language'
246LANGUAGE_COOKIE_PATH = '/'
247LOCALE_PATHS = []
248LOGGING = {}
249LOGGING_CONFIG = 'logging.config.dictConfig'
250LOGIN_REDIRECT_URL = '/accounts/profile/'
251LOGIN_URL = 'rest_framework:login'
252LOGOUT_REDIRECT_URL = None
253LOGOUT_URL = 'rest_framework:logout'
254MANAGERS = []
255MEDIA_ROOT = '/home/apiextra/Extra/media'
256MEDIA_URL = '/media/'
257MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
258MIDDLEWARE = ['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']
259MIGRATION_MODULES = {}
260MONTH_DAY_FORMAT = 'F j'
261NUMBER_GROUPING = 0
262ONE_SIGNAL_API_URL = '********************'
263ONE_SIGNAL_APP_ID = '3f553466-3626-4a08-9b21-e1a506564913'
264ONE_SIGNAL_TOKEN = '********************'
265PASSWORD_HASHERS = '********************'
266PASSWORD_RESET_TIMEOUT_DAYS = '********************'
267PREPEND_WWW = False
268REST_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'}
269ROOT_URLCONF = 'Extra.urls'
270SECRET_KEY = '********************'
271SECURE_BROWSER_XSS_FILTER = False
272SECURE_CONTENT_TYPE_NOSNIFF = False
273SECURE_HSTS_INCLUDE_SUBDOMAINS = False
274SECURE_HSTS_PRELOAD = False
275SECURE_HSTS_SECONDS = 0
276SECURE_PROXY_SSL_HEADER = None
277SECURE_REDIRECT_EXEMPT = []
278SECURE_SSL_HOST = None
279SECURE_SSL_REDIRECT = False
280SERVER_EMAIL = 'root@localhost'
281SESSION_CACHE_ALIAS = 'default'
282SESSION_COOKIE_AGE = 1209600
283SESSION_COOKIE_DOMAIN = None
284SESSION_COOKIE_HTTPONLY = True
285SESSION_COOKIE_NAME = 'sessionid'
286SESSION_COOKIE_PATH = '/'
287SESSION_COOKIE_SAMESITE = 'Lax'
288SESSION_COOKIE_SECURE = False
289SESSION_ENGINE = 'django.contrib.sessions.backends.db'
290SESSION_EXPIRE_AT_BROWSER_CLOSE = False
291SESSION_FILE_PATH = None
292SESSION_SAVE_EVERY_REQUEST = False
293SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
294SETTINGS_MODULE = 'Extra.settings'
295SHORT_DATETIME_FORMAT = 'm/d/Y P'
296SHORT_DATE_FORMAT = 'm/d/Y'
297SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
298SILENCED_SYSTEM_CHECKS = []
299STATICFILES_DIRS = []
300STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
301STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
302STATIC_ROOT = '/home/apiextra/Extra/static'
303STATIC_URL = '/static/'
304SWAGGER_SETTINGS = {'SECURITY_DEFINITIONS': {'api_Key': '********************'}}
305SWAGGER_YAML_FILE = '/home/apiextra/Extra/api.yaml'
306TEMPLATES = [{'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']}}]
307TEST_NON_SERIALIZED_APPS = []
308TEST_RUNNER = 'django.test.runner.DiscoverRunner'
309THOUSAND_SEPARATOR = ','
310TIME_FORMAT = 'P'
311TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
312TIME_ZONE = 'UTC'
313USE_I18N = True
314USE_L10N = True
315USE_THOUSAND_SEPARATOR = False
316USE_TZ = True
317USE_X_FORWARDED_HOST = False
318USE_X_FORWARDED_PORT = False
319WSGI_APPLICATION = 'Extra.wsgi.application'
320X_FRAME_OPTIONS = 'SAMEORIGIN'
321YEAR_MONTH_FORMAT = 'F Y'
322
323
324You're seeing this error because you have DEBUG = True in your
325Django settings file. Change that to False, and Django will
326display a standard page generated by the handler for this status code.
327
328
329
330Response code: 500 (Internal Server Error); Time: 838ms; Content length: 16223 bytes