· 8 years ago · Jun 04, 2017, 12:48 PM
1[Result]: SUCCESS: OperationalError at /api/invitation/
2(1242, 'Subquery returns more than 1 row')
3
4Request Method: POST
5Request URL: https://trybridge.com/api/invitation/
6Django Version: 1.10.5
7Python Executable: /mnt/env/bin/python3
8Python Version: 3.5.2
9Python Path: ['/mnt/bridge/releases/1496579215', '/mnt/env/bin', '/usr/lib/python35.zip', '/usr/lib/python3.5', '/usr/lib/python3.5/plat-x86_64-linux-gnu', '/usr/lib/python3.5/lib-dynload', '/mnt/env/lib/python3.5/site-packages', '/mnt/bridge/releases/1496579215']
10Server time: Sun, 4 Jun 2017 14:41:57 +0200
11Installed Applications:
12('django.contrib.admin',
13 'django.contrib.auth',
14 'django.contrib.contenttypes',
15 'django.contrib.sessions',
16 'django.contrib.messages',
17 'django.contrib.staticfiles',
18 'rest_framework',
19 'oauth2_provider',
20 'constant',
21 'action',
22 'device',
23 'contactinvitation',
24 'contact',
25 'invitation_category',
26 'invitation',
27 'person',
28 'phone',
29 'receiver',
30 'receiver_group',
31 'report',
32 'topic',
33 'apptext',
34 'country',
35 'error',
36 'feedback',
37 'friendinvite',
38 'invite_request',
39 'message',
40 'chat',
41 'invitation_answer',
42 'invitation_categorization',
43 'invitation_comment',
44 'invitation_image',
45 'invitation_keyword',
46 'interaction',
47 'interaction_total',
48 'transaction',
49 'network',
50 'fcm',
51 'notification',
52 'grouprole',
53 'group',
54 'group_skip',
55 'group_action',
56 'corsheaders',
57 'ai')
58Installed Middleware:
59('django.contrib.sessions.middleware.SessionMiddleware',
60 'corsheaders.middleware.CorsMiddleware',
61 'django.middleware.common.CommonMiddleware',
62 'django.middleware.csrf.CsrfViewMiddleware',
63 'django.contrib.auth.middleware.AuthenticationMiddleware',
64 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
65 'django.contrib.messages.middleware.MessageMiddleware',
66 'django.middleware.clickjacking.XFrameOptionsMiddleware')
67
68
69Traceback:
70
71File "/mnt/env/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
72 64. return self.cursor.execute(sql, params)
73
74File "/mnt/env/lib/python3.5/site-packages/django/db/backends/mysql/base.py" in execute
75 110. return self.cursor.execute(query, args)
76
77File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in execute
78 250. self.errorhandler(self, exc, value)
79
80File "/mnt/env/lib/python3.5/site-packages/MySQLdb/connections.py" in defaulterrorhandler
81 50. raise errorvalue
82
83File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in execute
84 247. res = self._query(query)
85
86File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in _query
87 411. rowcount = self._do_query(q)
88
89File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in _do_query
90 374. db.query(q)
91
92File "/mnt/env/lib/python3.5/site-packages/MySQLdb/connections.py" in query
93 292. _mysql.connection.query(self, query)
94
95
96 The above exception ((1242, 'Subquery returns more than 1 row')) was the direct cause of the following exception:
97
98
99
100File "/mnt/env/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
101 39. response = get_response(request)
102
103File "/mnt/env/lib/python3.5/site-packages/django/core/handlers/base.py" in _legacy_get_response
104 249. response = self._get_response(request)
105
106File "/mnt/env/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
107 187. response = self.process_exception_by_middleware(e, request)
108
109File "/mnt/env/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
110 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
111
112File "/mnt/env/lib/python3.5/site-packages/django/views/decorators/csrf.py" in wrapped_view
113 58. return view_func(*args, **kwargs)
114
115File "/mnt/env/lib/python3.5/site-packages/django/views/generic/base.py" in view
116 68. return self.dispatch(request, *args, **kwargs)
117
118File "/mnt/env/lib/python3.5/site-packages/rest_framework/views.py" in dispatch
119 483. response = self.handle_exception(exc)
120
121File "/mnt/env/lib/python3.5/site-packages/rest_framework/views.py" in handle_exception
122 443. self.raise_uncaught_exception(exc)
123
124File "/mnt/env/lib/python3.5/site-packages/rest_framework/views.py" in dispatch
125 480. response = handler(request, *args, **kwargs)
126
127File "/mnt/bridge/releases/1496579215/invitation/views.py" in post
128 121. return Response(serializer.data)
129
130File "/mnt/env/lib/python3.5/site-packages/rest_framework/serializers.py" in data
131 531. ret = super(Serializer, self).data
132
133File "/mnt/env/lib/python3.5/site-packages/rest_framework/serializers.py" in data
134 262. self._data = self.to_representation(self.instance)
135
136File "/mnt/env/lib/python3.5/site-packages/rest_framework/serializers.py" in to_representation
137 500. ret[field.field_name] = field.to_representation(attribute)
138
139File "/mnt/env/lib/python3.5/site-packages/rest_framework/fields.py" in to_representation
140 1745. return method(value)
141
142File "/mnt/bridge/releases/1496579215/invitation/serializers.py" in get_receivers_groups
143 558. if receivers.count():
144
145File "/mnt/env/lib/python3.5/site-packages/django/db/models/query.py" in count
146 369. return self.query.get_count(using=self.db)
147
148File "/mnt/env/lib/python3.5/site-packages/django/db/models/sql/query.py" in get_count
149 476. number = obj.get_aggregation(using, ['__count'])['__count']
150
151File "/mnt/env/lib/python3.5/site-packages/django/db/models/sql/query.py" in get_aggregation
152 457. result = compiler.execute_sql(SINGLE)
153
154File "/mnt/env/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in execute_sql
155 835. cursor.execute(sql, params)
156
157File "/mnt/env/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
158 79. return super(CursorDebugWrapper, self).execute(sql, params)
159
160File "/mnt/env/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
161 64. return self.cursor.execute(sql, params)
162
163File "/mnt/env/lib/python3.5/site-packages/django/db/utils.py" in __exit__
164 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
165
166File "/mnt/env/lib/python3.5/site-packages/django/utils/six.py" in reraise
167 685. raise value.with_traceback(tb)
168
169File "/mnt/env/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
170 64. return self.cursor.execute(sql, params)
171
172File "/mnt/env/lib/python3.5/site-packages/django/db/backends/mysql/base.py" in execute
173 110. return self.cursor.execute(query, args)
174
175File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in execute
176 250. self.errorhandler(self, exc, value)
177
178File "/mnt/env/lib/python3.5/site-packages/MySQLdb/connections.py" in defaulterrorhandler
179 50. raise errorvalue
180
181File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in execute
182 247. res = self._query(query)
183
184File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in _query
185 411. rowcount = self._do_query(q)
186
187File "/mnt/env/lib/python3.5/site-packages/MySQLdb/cursors.py" in _do_query
188 374. db.query(q)
189
190File "/mnt/env/lib/python3.5/site-packages/MySQLdb/connections.py" in query
191 292. _mysql.connection.query(self, query)
192
193Exception Type: OperationalError at /api/invitation/
194Exception Value: (1242, 'Subquery returns more than 1 row')
195Request information:
196USER: +381063201964
197
198GET: No GET data
199
200POST: No POST data
201
202FILES: No FILES data
203
204COOKIES: No cookie data
205
206META:
207CONTENT_LENGTH = '178'
208CONTENT_TYPE = 'application/x-www-form-urlencoded; charset=utf-8'
209HTTP_ACCEPT = '*/*'
210HTTP_ACCEPT_ENCODING = 'gzip, deflate'
211HTTP_ACCEPT_LANGUAGE = 'sr-cs'
212HTTP_AUTHORIZATION = 'Bearer 1BuxV9CFTeaEy5iVzyGmth3IuyzcOB'
213HTTP_CONNECTION = 'close'
214HTTP_HOST = 'trybridge.com'
215HTTP_USER_AGENT = 'TryBridge/59 CFNetwork/811.4.18 Darwin/16.6.0'
216HTTP_X_FORWARDED_FOR = '178.148.8.195'
217HTTP_X_FORWARDED_PROTO = 'https'
218HTTP_X_REAL_IP = '178.148.8.195'
219PATH_INFO = '/api/invitation/'
220QUERY_STRING = ''
221RAW_URI = '/api/invitation/'
222REMOTE_ADDR = "b''"
223REQUEST_METHOD = 'POST'
224SCRIPT_NAME = ''
225SERVER_NAME = 'trybridge.com'
226SERVER_PORT = '443'
227SERVER_PROTOCOL = 'HTTP/1.0'
228SERVER_SOFTWARE = 'gunicorn/19.6.0'
229gunicorn.socket = <socket.socket fd=11, family=AddressFamily.AF_UNIX, type=SocketKind.SOCK_STREAM, proto=0, laddr=/mnt/bridge/current/grapevine.sock>
230wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7fd4126b92b0>
231wsgi.file_wrapper = ''
232wsgi.input = <gunicorn.http.body.Body object at 0x7fd4126b9828>
233wsgi.multiprocess = False
234wsgi.multithread = False
235wsgi.run_once = False
236wsgi.url_scheme = 'https'
237wsgi.version =
238
239Settings:
240Using settings module grapevine.settings
241ABSOLUTE_URL_OVERRIDES = {}
242ADMINS = []
243ALLOWED_HOSTS = ['trybridge.com']
244APPEND_SLASH = True
245AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
246AUTH_PASSWORD_VALIDATORS = '********************'
247AUTH_USER_MODEL = 'auth.User'
248BASE_DIR = '/mnt/bridge/releases/1496579215'
249BROKER_URL = 'amqp://bridgeapiuser:V6BDGM496C4mJw85@localhost:5672/bridgevhost'
250CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
251CACHE_MIDDLEWARE_ALIAS = 'default'
252CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
253CACHE_MIDDLEWARE_SECONDS = 600
254CELERY_ACCEPT_CONTENT = ['json']
255CELERY_RESULT_SERIALIZER = 'json'
256CELERY_TASK_SERIALIZER = 'json'
257CELERY_TIMEZONE = 'Europe/London'
258CORS_ORIGIN_ALLOW_ALL = True
259CSRF_COOKIE_AGE = 31449600
260CSRF_COOKIE_DOMAIN = None
261CSRF_COOKIE_HTTPONLY = False
262CSRF_COOKIE_NAME = 'csrftoken'
263CSRF_COOKIE_PATH = '/'
264CSRF_COOKIE_SECURE = False
265CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
266CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
267CSRF_TRUSTED_ORIGINS = []
268DATABASES = {'default': {'ATOMIC_REQUESTS': False, 'ENGINE': 'django.db.backends.mysql', 'CONN_MAX_AGE': 0, 'USER': 'bridgeuser', 'NAME': 'bridge', 'TEST': {'COLLATION': None, 'NAME': None, 'CHARSET': None, 'MIRROR': None}, 'AUTOCOMMIT': True, 'PORT': '', 'OPTIONS': {}, 'TIME_ZONE': None, 'HOST': '127.0.0.1', 'PASSWORD': '********************'}}
269DATABASE_ROUTERS = []
270DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
271DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
272DATETIME_FORMAT = 'N j, Y, P'
273DATETIME_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']
274DATE_FORMAT = 'N j, Y'
275DATE_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']
276DEBUG = True
277DEBUG_PROPAGATE_EXCEPTIONS = False
278DECIMAL_SEPARATOR = '.'
279DEFAULT_CHARSET = 'utf-8'
280DEFAULT_CONTENT_TYPE = 'text/html'
281DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
282DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
283DEFAULT_FROM_EMAIL = 'webmaster@localhost'
284DEFAULT_INDEX_TABLESPACE = ''
285DEFAULT_TABLESPACE = ''
286DISALLOWED_USER_AGENTS = []
287DJANGO_LOG_LEVEL = True
288EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
289EMAIL_HOST = 'localhost'
290EMAIL_HOST_PASSWORD = '********************'
291EMAIL_HOST_USER = ''
292EMAIL_PORT = 25
293EMAIL_SSL_CERTFILE = None
294EMAIL_SSL_KEYFILE = '********************'
295EMAIL_SUBJECT_PREFIX = '[Django] '
296EMAIL_TIMEOUT = None
297EMAIL_USE_SSL = False
298EMAIL_USE_TLS = False
299FILE_CHARSET = 'utf-8'
300FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
301FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
302FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
303FILE_UPLOAD_PERMISSIONS = None
304FILE_UPLOAD_TEMP_DIR = None
305FIRST_DAY_OF_WEEK = 0
306FIXTURE_DIRS = []
307FORCE_SCRIPT_NAME = None
308FORMAT_MODULE_PATH = None
309IGNORABLE_404_URLS = []
310INSTALLED_APPS =
311INTERNAL_IPS = []
312LANGUAGES = [('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'), ('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')]
313LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
314LANGUAGE_CODE = 'en-us'
315LANGUAGE_COOKIE_AGE = None
316LANGUAGE_COOKIE_DOMAIN = None
317LANGUAGE_COOKIE_NAME = 'django_language'
318LANGUAGE_COOKIE_PATH = '/'
319LOCALE_PATHS = []
320LOGGING = {}
321LOGGING_CONFIG = 'logging.config.dictConfig'
322LOGIN_REDIRECT_URL = '/accounts/profile/'
323LOGIN_URL = '/'
324LOGOUT_REDIRECT_URL = None
325MANAGERS = []
326MEDIA_ROOT = '/mnt/bridge/media'
327MEDIA_URL = '/media/'
328MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
329MIDDLEWARE = None
330MIDDLEWARE_CLASSES =
331MIGRATION_MODULES = {}
332MONTH_DAY_FORMAT = 'F j'
333NUMBER_GROUPING = 0
334PASSWORD_HASHERS = '********************'
335PASSWORD_RESET_TIMEOUT_DAYS = '********************'
336PREPEND_WWW = False
337PROJECT_PATH = '/mnt/bridge/releases/1496579215/grapevine'
338PROJECT_ROOT = '/mnt/bridge/releases/1496579215'
339PROJECT_ROOT_FOLDER_TWO_UP = '/mnt/bridge'
340PROJECT_ROOT_FOLDER_UP = '/mnt/bridge/releases'
341REST_FRAMEWORK = {'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAuthenticated', 'person.permissions.IsActivatedPerson'), 'DEFAULT_AUTHENTICATION_CLASSES': ('oauth2_provider.ext.rest_framework.OAuth2Authentication',), 'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer',)}
342ROOT_URLCONF = 'grapevine.urls'
343SECRET_KEY = '********************'
344SECURE_BROWSER_XSS_FILTER = False
345SECURE_CONTENT_TYPE_NOSNIFF = False
346SECURE_HSTS_INCLUDE_SUBDOMAINS = False
347SECURE_HSTS_SECONDS = 0
348SECURE_PROXY_SSL_HEADER = None
349SECURE_REDIRECT_EXEMPT = []
350SECURE_SSL_HOST = None
351SECURE_SSL_REDIRECT = False
352SERVER_EMAIL = 'root@localhost'
353SESSION_CACHE_ALIAS = 'default'
354SESSION_COOKIE_AGE = 1209600
355SESSION_COOKIE_DOMAIN = None
356SESSION_COOKIE_HTTPONLY = True
357SESSION_COOKIE_NAME = 'sessionid'
358SESSION_COOKIE_PATH = '/'
359SESSION_COOKIE_SECURE = False
360SESSION_ENGINE = 'django.contrib.sessions.backends.db'
361SESSION_EXPIRE_AT_BROWSER_CLOSE = False
362SESSION_FILE_PATH = None
363SESSION_SAVE_EVERY_REQUEST = False
364SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
365SETTINGS_MODULE = 'grapevine.settings'
366SHORT_DATETIME_FORMAT = 'm/d/Y P'
367SHORT_DATE_FORMAT = 'm/d/Y'
368SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
369SILENCED_SYSTEM_CHECKS = []
370SITE_ROOT = '/mnt/bridge/releases/1496579215/grapevine'
371STATICFILES_DIRS = []
372STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
373STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
374STATIC_MEDIA_URL = 'https://trybridge.com/media/'
375STATIC_ROOT = '/mnt/bridge/static'
376STATIC_URL = '/static/'
377STATIC_WEBSITE_URL = 'https://trybridge.com'
378TEMPLATES = [{'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'], 'loaders': [('django.template.loaders.cached.Loader', ['django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader'])]}, 'DIRS': [], 'BACKEND': 'django.template.backends.django.DjangoTemplates'}]
379TEST_NON_SERIALIZED_APPS = []
380TEST_RUNNER = 'django.test.runner.DiscoverRunner'
381THOUSAND_SEPARATOR = ','
382TIME_FORMAT = 'P'
383TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
384TIME_ZONE = 'Europe/Oslo'
385USE_ETAGS = False
386USE_I18N = True
387USE_L10N = True
388USE_THOUSAND_SEPARATOR = False
389USE_TZ = True
390USE_X_FORWARDED_HOST = False
391USE_X_FORWARDED_PORT = False
392WSGI_APPLICATION = None
393X_FRAME_OPTIONS = 'SAMEORIGIN'
394YEAR_MONTH_FORMAT = 'F Y'
395
396
397You're seeing this error because you have DEBUG = True in your
398Django settings file. Change that to False, and Django will
399display a standard page generated by the handler for this status code.