Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ProgrammingError at /api/v1/tournaments/450023
- column tournaments_flight.capacity does not exist
- LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
- ^
- Request Method: GET
- Request URL: http://st.footgolflounge.com/api/v1/tournaments/450023
- Django Version: 2.1.2
- Python Executable: /usr/local/bin/python
- Python Version: 3.7.1
- Python 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']
- Server time: Sun, 12 May 2019 11:35:14 +0000
- Installed Applications:
- ['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']
- Installed Middleware:
- ['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']
- Traceback:
- File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- The above exception (column tournaments_flight.capacity does not exist
- LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
- ^
- ) was the direct cause of the following exception:
- File "/usr/local/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
- 34. response = get_response(request)
- File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
- 126. response = self.process_exception_by_middleware(e, request)
- File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
- 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
- File "/usr/local/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
- 54. return view_func(*args, **kwargs)
- File "/usr/local/lib/python3.7/site-packages/django/views/generic/base.py" in view
- 68. return self.dispatch(request, *args, **kwargs)
- File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
- 483. response = self.handle_exception(exc)
- File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
- 443. self.raise_uncaught_exception(exc)
- File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
- 480. response = handler(request, *args, **kwargs)
- File "./tournaments/views.py" in get
- 63. 'participates_in_flights': flights_serializer.data,
- File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
- 765. ret = super(ListSerializer, self).data
- File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
- 262. self._data = self.to_representation(self.instance)
- File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in to_representation
- 683. self.child.to_representation(item) for item in iterable
- File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
- 268. self._fetch_all()
- File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in _fetch_all
- 1186. self._result_cache = list(self._iterable_class(self))
- File "/usr/local/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 "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
- 1065. cursor.execute(sql, params)
- File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
- 100. return super().execute(sql, params)
- File "/usr/local/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 "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
- 77. return executor(sql, params, many, context)
- File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- File "/usr/local/lib/python3.7/site-packages/django/db/utils.py" in __exit__
- 89. raise dj_exc_value.with_traceback(traceback) from exc_value
- File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
- 85. return self.cursor.execute(sql, params)
- Exception Type: ProgrammingError at /api/v1/tournaments/450023
- Exception Value: column tournaments_flight.capacity does not exist
- LINE 1: ...s_flight"."status", "tournaments_flight"."label", "tournamen...
- ^
- Request information:
- USER: Jacana Blue
- GET: No GET data
- POST: No POST data
- FILES: No FILES data
- COOKIES:
- __cfduid = 'd89ebf05760abc8c3a2c84ff84182a9a81556526873'
- META:
- HTTP_ACCEPT = '*/*'
- HTTP_ACCEPT_ENCODING = 'gzip'
- HTTP_ACCEPT_LANGUAGE = 'en'
- HTTP_AUTHORIZATION = 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiZXhwIjoxNTU3NzQ2OTU3LCJqdGkiOiIzMzcxMjM3ZmZkYTQ0M2YzOGY0N2YzNDQzZTcyMmJjYyIsInVzZXJfaWQiOiIyNTM1M2ZiNi0xMjA2LTRjNGEtOWEyZi0xOGQ1YTUxYzdkZTAifQ.eXkWGEm6RrEtDxnsM1h6nbmZVmqaql6W3y6f_Poy8Nc'
- HTTP_CACHE_CONTROL = 'no-cache'
- HTTP_CDN_LOOP = 'cloudflare'
- HTTP_CF_CONNECTING_IP = '109.173.147.142'
- HTTP_CF_IPCOUNTRY = 'PL'
- HTTP_CF_RAY = '4d5c16889ffbcc97-WAW'
- HTTP_CF_VISITOR = '{"scheme":"https"}'
- HTTP_CONNECTION = 'Keep-Alive'
- HTTP_COOKIE = '__cfduid=d89ebf05760abc8c3a2c84ff84182a9a81556526873'
- HTTP_HOST = 'st.footgolflounge.com'
- HTTP_POSTMAN_TOKEN = 'c370f1e2-2fb7-46a1-985d-0ade1b197d03'
- HTTP_REFERER = 'http://st.footgolflounge.com/api/v1/tournaments/450023'
- HTTP_USER_AGENT = 'PostmanRuntime/7.11.0'
- HTTP_VIA = '1.1 google'
- HTTP_X_APP_VERSION = '1.06'
- HTTP_X_CLOUD_TRACE_CONTEXT = 'e58b32bb43523a646c9c187292a1905e/10858150930701708475'
- HTTP_X_FORWARDED_FOR = '109.173.147.142, 162.158.103.126, 34.96.75.41'
- HTTP_X_FORWARDED_PROTO = 'http'
- PATH_INFO = '/api/v1/tournaments/450023'
- QUERY_STRING = ''
- REMOTE_ADDR = '10.156.0.50'
- REMOTE_HOST = '10.156.0.50'
- REMOTE_PORT = 58399
- REQUEST_METHOD = 'GET'
- SCRIPT_NAME = ''
- SERVER_NAME = '10.56.2.10'
- SERVER_PORT = '8080'
- wsgi.multiprocess = True
- wsgi.multithread = True
- Settings:
- Using settings module config.settings.base
- ABSOLUTE_URL_OVERRIDES = {}
- ADMINS = []
- ALLOWED_HOSTS = ['*']
- APPEND_SLASH = True
- ASGI_APPLICATION = 'tournaments.routing.application'
- ASSOCIATION_APP = 'https://asfeca.footgolflounge.com/'
- AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
- AUTH_PASSWORD_VALIDATORS = '********************'
- AUTH_USER_MODEL = 'accounts.User'
- AZURE_ACCOUNT_KEY = '********************'
- AZURE_ACCOUNT_NAME = 'footgolfstorage'
- AZURE_CONTAINER = 'footgolf'
- BASE_DIR = '/code/src/config'
- BRAINTREE_MERCHANT_ID = 'm47rxx8xpfh96vnq'
- BRAINTREE_PRIVATE_KEY = '********************'
- BRAINTREE_PUBLIC_KEY = '********************'
- CACHES = {'default': {'BACKEND': 'django_redis.cache.RedisCache', 'LOCATION': 'redis://redis.staging.svc.cluster.local:6379/5', 'OPTIONS': {'CLIENT_CLASS': 'django_redis.client.DefaultClient'}, 'KEY_PREFIX': '********************'}}
- CACHE_MIDDLEWARE_ALIAS = 'default'
- CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
- CACHE_MIDDLEWARE_SECONDS = 600
- CACHE_TTL = 60
- CHANNEL_LAYERS = {'default': {'BACKEND': 'channels_redis.core.RedisChannelLayer', 'CONFIG': {'hosts': ['redis://redis.staging.svc.cluster.local:6379/5']}}}
- CORS_ALLOW_HEADERS = "('accept', 'accept-encoding', 'authorization', 'content-type', 'dnt', 'origin', 'user-agent', 'x-csrftoken', 'x-requested-with', 'x-source')"
- CORS_ORIGIN_ALLOW_ALL = True
- 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.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}}}
- 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 = 'storages.backends.azure_storage.AzureStorage'
- DEFAULT_FROM_EMAIL = 'noreply@footgolflounge.com'
- DEFAULT_INDEX_TABLESPACE = ''
- DEFAULT_TABLESPACE = ''
- DISALLOWED_USER_AGENTS = []
- EMAIL_BACKEND = 'sparkpost.django.email_backend.SparkPostEmailBackend'
- 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
- FCM_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'}}
- 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'
- FRONT_HOSTNAME = 'https://feca.footgolflounge.com/'
- HOSTNAME = 'https://st.footgolflounge.com/'
- IGNORABLE_404_URLS = []
- INSTAGRAM_API = '********************'
- INSTALLED_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']
- INTERNAL_IPS = []
- JWT_AUTH = {'JWT_AUTH_HEADER_PREFIX': 'Bearer'}
- LANGUAGES = [('en', 'English'), ('pl', 'Polish'), ('es', 'Spanish')]
- LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
- LANGUAGE_CODE = 'en'
- LANGUAGE_COOKIE_AGE = None
- LANGUAGE_COOKIE_DOMAIN = None
- LANGUAGE_COOKIE_NAME = 'django_language'
- LANGUAGE_COOKIE_PATH = '/'
- LOCALE_PATHS = []
- LOGGING = {'version': 1, 'disable_existing_loggers': False, 'handlers': {'console': {'class': 'logging.StreamHandler'}}, 'loggers': {}}
- LOGGING_CONFIG = 'logging.config.dictConfig'
- LOGIN_REDIRECT_URL = '/accounts/profile/'
- LOGIN_URL = 'accounts:login'
- LOGOUT_REDIRECT_URL = None
- LOGOUT_URL = 'accounts:logout'
- MANAGERS = []
- MEDIA_ROOT = '/code/src/config/media'
- MEDIA_URL = '/media/'
- MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
- MIDDLEWARE = ['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']
- MIGRATION_MODULES = {}
- MONTH_DAY_FORMAT = 'F j'
- NUMBER_GROUPING = 0
- PASSWORD_HASHERS = '********************'
- PASSWORD_RESET_TIMEOUT_DAYS = '********************'
- PREPEND_WWW = False
- REDIS_CONNECTION = 'redis://redis.staging.svc.cluster.local:6379/5'
- REST_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'}
- ROOT_URLCONF = 'config.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 = 'config.settings.base'
- SHORT_DATETIME_FORMAT = 'm/d/Y P'
- SHORT_DATE_FORMAT = 'm/d/Y'
- SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
- SILENCED_SYSTEM_CHECKS = []
- SIMPLE_JWT = {'ACCESS_TOKEN_LIFETIME': '********************', 'REFRESH_TOKEN_LIFETIME': '********************', 'ROTATE_REFRESH_TOKENS': '********************', 'USER_ID_FIELD': 'jwt_secret'}
- SPARKPOST_API_KEY = '********************'
- STATICFILES_DIRS = "('/code/src/config/static',)"
- STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
- STATICFILES_STORAGE = 'custom_storage.custom_azure.PublicAzureStorage'
- STATIC_ROOT = None
- STATIC_URL = '/static/'
- STRIPE_ENDPOINT_SECRET = '********************'
- SWAGGER_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}
- TEMPLATES = [{'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']}}]
- 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'
- TOKEN_LIFETIME = '********************'
- TWITTER_API = '********************'
- 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 = 'config.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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement