· 6 years ago · May 12, 2019, 11:40 AM
1ProgrammingError at /api/v1/tournaments/450023
2column tournaments_flight.capacity does not exist
3LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
4 ^
5
6
7Request Method: GET
8Request URL: http://st.footgolflounge.com/api/v1/tournaments/450023
9Django Version: 2.1.2
10Python Executable: /usr/local/bin/python
11Python Version: 3.7.1
12Python Path: ['.', '/usr/local/bin', '/usr/local/lib/python37.zip', '/usr/local/lib/python3.7', '/usr/local/lib/python3.7/lib-dynload', '/usr/local/lib/python3.7/site-packages']
13Server time: Sun, 12 May 2019 11:35:14 +0000
14Installed Applications:
15['django.contrib.auth',
16 'django.contrib.contenttypes',
17 'django.contrib.sessions',
18 'django.contrib.messages',
19 'django.contrib.staticfiles',
20 'django.contrib.postgres',
21 'admin_interface',
22 'colorfield',
23 'common.apps.MyAdminConfig',
24 'drf_yasg',
25 'rest_framework',
26 'rest_framework_swagger',
27 'django_admin_json_editor',
28 'corsheaders',
29 'channels',
30 'health_check',
31 'health_check.db',
32 'health_check.cache',
33 'fcm_django',
34 'accounts.apps.AccountsConfig',
35 'dictionaries.apps.DictionariesConfig',
36 'events.apps.EventsConfig',
37 'feed.apps.FeedConfig',
38 'organizations.apps.OrganizationsConfig',
39 'payments.apps.PaymentsConfig',
40 'stats.apps.StatsConfig',
41 'tournaments.apps.TournamentsConfig']
42Installed Middleware:
43['corsheaders.middleware.CorsMiddleware',
44 'django.middleware.common.CommonMiddleware',
45 'django.middleware.security.SecurityMiddleware',
46 'django.contrib.sessions.middleware.SessionMiddleware',
47 'django.middleware.locale.LocaleMiddleware',
48 'django.middleware.common.CommonMiddleware',
49 'django.middleware.csrf.CsrfViewMiddleware',
50 'django.contrib.auth.middleware.AuthenticationMiddleware',
51 'django.contrib.messages.middleware.MessageMiddleware',
52 'django.middleware.clickjacking.XFrameOptionsMiddleware']
53
54
55Traceback:
56
57File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
58 85. return self.cursor.execute(sql, params)
59
60The above exception (column tournaments_flight.capacity does not exist
61LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
62 ^
63) was the direct cause of the following exception:
64
65File "/usr/local/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
66 34. response = get_response(request)
67
68File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
69 126. response = self.process_exception_by_middleware(e, request)
70
71File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
72 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
73
74File "/usr/local/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
75 54. return view_func(*args, **kwargs)
76
77File "/usr/local/lib/python3.7/site-packages/django/views/generic/base.py" in view
78 68. return self.dispatch(request, *args, **kwargs)
79
80File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
81 483. response = self.handle_exception(exc)
82
83File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
84 443. self.raise_uncaught_exception(exc)
85
86File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
87 480. response = handler(request, *args, **kwargs)
88
89File "./tournaments/views.py" in get
90 63. 'participates_in_flights': flights_serializer.data,
91
92File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
93 765. ret = super(ListSerializer, self).data
94
95File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
96 262. self._data = self.to_representation(self.instance)
97
98File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in to_representation
99 683. self.child.to_representation(item) for item in iterable
100
101File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
102 268. self._fetch_all()
103
104File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in _fetch_all
105 1186. self._result_cache = list(self._iterable_class(self))
106
107File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
108 54. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
109
110File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
111 1065. cursor.execute(sql, params)
112
113File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
114 100. return super().execute(sql, params)
115
116File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
117 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
118
119File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
120 77. return executor(sql, params, many, context)
121
122File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
123 85. return self.cursor.execute(sql, params)
124
125File "/usr/local/lib/python3.7/site-packages/django/db/utils.py" in __exit__
126 89. raise dj_exc_value.with_traceback(traceback) from exc_value
127
128File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
129 85. return self.cursor.execute(sql, params)
130
131Exception Type: ProgrammingError at /api/v1/tournaments/450023
132Exception Value: column tournaments_flight.capacity does not exist
133LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
134 ^
135
136Request information:
137USER: Jacana Blue
138
139GET: No GET data
140
141POST: No POST data
142
143FILES: No FILES data
144
145COOKIES:
146__cfduid = 'd89ebf05760abc8c3a2c84ff84182a9a81556526873'
147
148META:
149HTTP_ACCEPT = '*/*'
150HTTP_ACCEPT_ENCODING = 'gzip'
151HTTP_ACCEPT_LANGUAGE = 'en'
152HTTP_AUTHORIZATION = 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiZXhwIjoxNTU3NzQ2OTU3LCJqdGkiOiIzMzcxMjM3ZmZkYTQ0M2YzOGY0N2YzNDQzZTcyMmJjYyIsInVzZXJfaWQiOiIyNTM1M2ZiNi0xMjA2LTRjNGEtOWEyZi0xOGQ1YTUxYzdkZTAifQ.eXkWGEm6RrEtDxnsM1h6nbmZVmqaql6W3y6f_Poy8Nc'
153HTTP_CACHE_CONTROL = 'no-cache'
154HTTP_CDN_LOOP = 'cloudflare'
155HTTP_CF_CONNECTING_IP = '109.173.147.142'
156HTTP_CF_IPCOUNTRY = 'PL'
157HTTP_CF_RAY = '4d5c16889ffbcc97-WAW'
158HTTP_CF_VISITOR = '{"scheme":"https"}'
159HTTP_CONNECTION = 'Keep-Alive'
160HTTP_COOKIE = '__cfduid=d89ebf05760abc8c3a2c84ff84182a9a81556526873'
161HTTP_HOST = 'st.footgolflounge.com'
162HTTP_POSTMAN_TOKEN = 'c370f1e2-2fb7-46a1-985d-0ade1b197d03'
163HTTP_REFERER = 'http://st.footgolflounge.com/api/v1/tournaments/450023'
164HTTP_USER_AGENT = 'PostmanRuntime/7.11.0'
165HTTP_VIA = '1.1 google'
166HTTP_X_APP_VERSION = '1.06'
167HTTP_X_CLOUD_TRACE_CONTEXT = 'e58b32bb43523a646c9c187292a1905e/10858150930701708475'
168HTTP_X_FORWARDED_FOR = '109.173.147.142, 162.158.103.126, 34.96.75.41'
169HTTP_X_FORWARDED_PROTO = 'http'
170PATH_INFO = '/api/v1/tournaments/450023'
171QUERY_STRING = ''
172REMOTE_ADDR = '10.156.0.50'
173REMOTE_HOST = '10.156.0.50'
174REMOTE_PORT = 58399
175REQUEST_METHOD = 'GET'
176SCRIPT_NAME = ''
177SERVER_NAME = '10.56.2.10'
178SERVER_PORT = '8080'
179wsgi.multiprocess = True
180wsgi.multithread = True
181
182Settings:
183Using settings module config.settings.base
184ABSOLUTE_URL_OVERRIDES = {}
185ADMINS = []
186ALLOWED_HOSTS = ['*']
187APPEND_SLASH = True
188ASGI_APPLICATION = 'tournaments.routing.application'
189ASSOCIATION_APP = 'https://asfeca.footgolflounge.com/'
190AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
191AUTH_PASSWORD_VALIDATORS = '********************'
192AUTH_USER_MODEL = 'accounts.User'
193AZURE_ACCOUNT_KEY = '********************'
194AZURE_ACCOUNT_NAME = 'footgolfstorage'
195AZURE_CONTAINER = 'footgolf'
196BASE_DIR = '/code/src/config'
197BRAINTREE_MERCHANT_ID = 'm47rxx8xpfh96vnq'
198BRAINTREE_PRIVATE_KEY = '********************'
199BRAINTREE_PUBLIC_KEY = '********************'
200CACHES = {'default': {'BACKEND': 'django_redis.cache.RedisCache', 'LOCATION': 'redis://redis.staging.svc.cluster.local:6379/5', 'OPTIONS': {'CLIENT_CLASS': 'django_redis.client.DefaultClient'}, 'KEY_PREFIX': '********************'}}
201CACHE_MIDDLEWARE_ALIAS = 'default'
202CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
203CACHE_MIDDLEWARE_SECONDS = 600
204CACHE_TTL = 60
205CHANNEL_LAYERS = {'default': {'BACKEND': 'channels_redis.core.RedisChannelLayer', 'CONFIG': {'hosts': ['redis://redis.staging.svc.cluster.local:6379/5']}}}
206CORS_ALLOW_HEADERS = "('accept', 'accept-encoding', 'authorization', 'content-type', 'dnt', 'origin', 'user-agent', 'x-csrftoken', 'x-requested-with', 'x-source')"
207CORS_ORIGIN_ALLOW_ALL = True
208CSRF_COOKIE_AGE = 31449600
209CSRF_COOKIE_DOMAIN = None
210CSRF_COOKIE_HTTPONLY = False
211CSRF_COOKIE_NAME = 'csrftoken'
212CSRF_COOKIE_PATH = '/'
213CSRF_COOKIE_SAMESITE = 'Lax'
214CSRF_COOKIE_SECURE = False
215CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
216CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
217CSRF_TRUSTED_ORIGINS = []
218CSRF_USE_SESSIONS = False
219DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'footgolf_staging', 'USER': 'footgolf_staging', 'PASSWORD': '********************', 'HOST': '127.0.0.1', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
220DATABASE_ROUTERS = []
221DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
222DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
223DATETIME_FORMAT = 'N j, Y, P'
224DATETIME_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']
225DATE_FORMAT = 'N j, Y'
226DATE_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']
227DEBUG = True
228DEBUG_PROPAGATE_EXCEPTIONS = False
229DECIMAL_SEPARATOR = '.'
230DEFAULT_CHARSET = 'utf-8'
231DEFAULT_CONTENT_TYPE = 'text/html'
232DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
233DEFAULT_FILE_STORAGE = 'storages.backends.azure_storage.AzureStorage'
234DEFAULT_FROM_EMAIL = 'noreply@footgolflounge.com'
235DEFAULT_INDEX_TABLESPACE = ''
236DEFAULT_TABLESPACE = ''
237DISALLOWED_USER_AGENTS = []
238EMAIL_BACKEND = 'sparkpost.django.email_backend.SparkPostEmailBackend'
239EMAIL_HOST = 'localhost'
240EMAIL_HOST_PASSWORD = '********************'
241EMAIL_HOST_USER = ''
242EMAIL_PORT = 25
243EMAIL_SSL_CERTFILE = None
244EMAIL_SSL_KEYFILE = '********************'
245EMAIL_SUBJECT_PREFIX = '[Django] '
246EMAIL_TIMEOUT = None
247EMAIL_USE_LOCALTIME = False
248EMAIL_USE_SSL = False
249EMAIL_USE_TLS = False
250FCM_DJANGO_SETTINGS = {'FCM_SERVER_KEY': '********************', 'ONE_DEVICE_PER_USER': False, 'DELETE_INACTIVE_DEVICES': True, 'FCM_SERVER': 'https://fcm.googleapis.com/fcm/send', 'USER_MODEL': 'accounts.User', 'ERRORS': {'invalid_registration': 'InvalidRegistration', 'missing_registration': 'MissingRegistration', 'not_registered': 'NotRegistered', 'invalid_package_name': 'InvalidPackageName'}}
251FILE_CHARSET = 'utf-8'
252FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
253FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
254FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
255FILE_UPLOAD_PERMISSIONS = None
256FILE_UPLOAD_TEMP_DIR = None
257FIRST_DAY_OF_WEEK = 0
258FIXTURE_DIRS = []
259FORCE_SCRIPT_NAME = None
260FORMAT_MODULE_PATH = None
261FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
262FRONT_HOSTNAME = 'https://feca.footgolflounge.com/'
263HOSTNAME = 'https://st.footgolflounge.com/'
264IGNORABLE_404_URLS = []
265INSTAGRAM_API = '********************'
266INSTALLED_APPS = ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.postgres', 'admin_interface', 'colorfield', 'common.apps.MyAdminConfig', 'drf_yasg', 'rest_framework', 'rest_framework_swagger', 'django_admin_json_editor', 'corsheaders', 'channels', 'health_check', 'health_check.db', 'health_check.cache', 'fcm_django', 'accounts.apps.AccountsConfig', 'dictionaries.apps.DictionariesConfig', 'events.apps.EventsConfig', 'feed.apps.FeedConfig', 'organizations.apps.OrganizationsConfig', 'payments.apps.PaymentsConfig', 'stats.apps.StatsConfig', 'tournaments.apps.TournamentsConfig']
267INTERNAL_IPS = []
268JWT_AUTH = {'JWT_AUTH_HEADER_PREFIX': 'Bearer'}
269LANGUAGES = [('en', 'English'), ('pl', 'Polish'), ('es', 'Spanish')]
270LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
271LANGUAGE_CODE = 'en'
272LANGUAGE_COOKIE_AGE = None
273LANGUAGE_COOKIE_DOMAIN = None
274LANGUAGE_COOKIE_NAME = 'django_language'
275LANGUAGE_COOKIE_PATH = '/'
276LOCALE_PATHS = []
277LOGGING = {'version': 1, 'disable_existing_loggers': False, 'handlers': {'console': {'class': 'logging.StreamHandler'}}, 'loggers': {}}
278LOGGING_CONFIG = 'logging.config.dictConfig'
279LOGIN_REDIRECT_URL = '/accounts/profile/'
280LOGIN_URL = 'accounts:login'
281LOGOUT_REDIRECT_URL = None
282LOGOUT_URL = 'accounts:logout'
283MANAGERS = []
284MEDIA_ROOT = '/code/src/config/media'
285MEDIA_URL = '/media/'
286MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
287MIDDLEWARE = ['corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware']
288MIGRATION_MODULES = {}
289MONTH_DAY_FORMAT = 'F j'
290NUMBER_GROUPING = 0
291PASSWORD_HASHERS = '********************'
292PASSWORD_RESET_TIMEOUT_DAYS = '********************'
293PREPEND_WWW = False
294REDIS_CONNECTION = 'redis://redis.staging.svc.cluster.local:6379/5'
295REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework_simplejwt.authentication.JWTAuthentication',), 'DEFAULT_PERMISSION_CLASSES': ('common.mixins.IsAuthenticatedUser',), 'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.LimitOffsetPagination', 'PAGE_SIZE': 10, 'EXCEPTION_HANDLER': 'common.exceptions.custom_exception_handler'}
296ROOT_URLCONF = 'config.urls'
297SECRET_KEY = '********************'
298SECURE_BROWSER_XSS_FILTER = False
299SECURE_CONTENT_TYPE_NOSNIFF = False
300SECURE_HSTS_INCLUDE_SUBDOMAINS = False
301SECURE_HSTS_PRELOAD = False
302SECURE_HSTS_SECONDS = 0
303SECURE_PROXY_SSL_HEADER = None
304SECURE_REDIRECT_EXEMPT = []
305SECURE_SSL_HOST = None
306SECURE_SSL_REDIRECT = False
307SERVER_EMAIL = 'root@localhost'
308SESSION_CACHE_ALIAS = 'default'
309SESSION_COOKIE_AGE = 1209600
310SESSION_COOKIE_DOMAIN = None
311SESSION_COOKIE_HTTPONLY = True
312SESSION_COOKIE_NAME = 'sessionid'
313SESSION_COOKIE_PATH = '/'
314SESSION_COOKIE_SAMESITE = 'Lax'
315SESSION_COOKIE_SECURE = False
316SESSION_ENGINE = 'django.contrib.sessions.backends.db'
317SESSION_EXPIRE_AT_BROWSER_CLOSE = False
318SESSION_FILE_PATH = None
319SESSION_SAVE_EVERY_REQUEST = False
320SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
321SETTINGS_MODULE = 'config.settings.base'
322SHORT_DATETIME_FORMAT = 'm/d/Y P'
323SHORT_DATE_FORMAT = 'm/d/Y'
324SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
325SILENCED_SYSTEM_CHECKS = []
326SIMPLE_JWT = {'ACCESS_TOKEN_LIFETIME': '********************', 'REFRESH_TOKEN_LIFETIME': '********************', 'ROTATE_REFRESH_TOKENS': '********************', 'USER_ID_FIELD': 'jwt_secret'}
327SPARKPOST_API_KEY = '********************'
328STATICFILES_DIRS = "('/code/src/config/static',)"
329STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
330STATICFILES_STORAGE = 'custom_storage.custom_azure.PublicAzureStorage'
331STATIC_ROOT = None
332STATIC_URL = '/static/'
333STRIPE_ENDPOINT_SECRET = '********************'
334SWAGGER_SETTINGS = {'OPERATIONS_SORTER': 'method', 'JSON_EDITOR': True, 'LOGIN_URL': '/admin/login/', 'LOGOUT_URL': '/admin/logout/', 'SECURITY_DEFINITIONS': {'basic': {'type': 'basic'}}, 'EXCLUDED_MEDIA_TYPES': {'html', 'json'}, 'DOC_EXPANSION': 'none', 'DISPLAY_OPERATION_ID': False}
335TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/code/src/config/templates'], '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']}}]
336TEST_NON_SERIALIZED_APPS = []
337TEST_RUNNER = 'django.test.runner.DiscoverRunner'
338THOUSAND_SEPARATOR = ','
339TIME_FORMAT = 'P'
340TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
341TIME_ZONE = 'UTC'
342TOKEN_LIFETIME = '********************'
343TWITTER_API = '********************'
344USE_I18N = True
345USE_L10N = True
346USE_THOUSAND_SEPARATOR = False
347USE_TZ = True
348USE_X_FORWARDED_HOST = False
349USE_X_FORWARDED_PORT = False
350WSGI_APPLICATION = 'config.wsgi.application'
351X_FRAME_OPTIONS = 'SAMEORIGIN'
352YEAR_MONTH_FORMAT = 'F Y'
353
354
355You're seeing this error because you have DEBUG = True in your
356Django settings file. Change that to False, and Django will
357display a standard page generated by the handler for this status code.