· 6 years ago · Jan 29, 2019, 08:48 PM
1ProgrammingError at /candidate/anchors_hook/
2column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
3LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
4 ^
5
6
7Request Method: POST
8Request URL: http://localhost:8000/candidate/anchors_hook/
9Django Version: 2.1.3
10Python Executable: /usr/local/bin/python
11Python Version: 3.6.8
12Python Path: ['/app', '/usr/local/lib/python36.zip', '/usr/local/lib/python3.6', '/usr/local/lib/python3.6/lib-dynload', '/usr/local/lib/python3.6/site-packages']
13Server time: Tue, 29 Jan 2019 20:42:32 +0000
14Installed Applications:
15['django.contrib.admin',
16 'django.contrib.auth',
17 'django.contrib.contenttypes',
18 'django.contrib.sessions',
19 'django.contrib.messages',
20 'django.contrib.staticfiles',
21 'user',
22 'client',
23 'candidate',
24 'recruitment',
25 'rest_framework',
26 'rest_framework.authtoken',
27 'corsheaders']
28Installed Middleware:
29['django.middleware.security.SecurityMiddleware',
30 'django.contrib.sessions.middleware.SessionMiddleware',
31 'corsheaders.middleware.CorsMiddleware',
32 'django.middleware.common.CommonMiddleware',
33 'django.middleware.csrf.CsrfViewMiddleware',
34 'django.contrib.auth.middleware.AuthenticationMiddleware',
35 'django.contrib.messages.middleware.MessageMiddleware',
36 'django.middleware.clickjacking.XFrameOptionsMiddleware']
37
38
39Traceback:
40
41File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
42 85. return self.cursor.execute(sql, params)
43
44The above exception (column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
45LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
46 ^
47) was the direct cause of the following exception:
48
49File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
50 34. response = get_response(request)
51
52File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
53 126. response = self.process_exception_by_middleware(e, request)
54
55File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
56 124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
57
58File "/usr/local/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
59 54. return view_func(*args, **kwargs)
60
61File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py" in view
62 68. return self.dispatch(request, *args, **kwargs)
63
64File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
65 495. response = self.handle_exception(exc)
66
67File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
68 455. self.raise_uncaught_exception(exc)
69
70File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
71 492. response = handler(request, *args, **kwargs)
72
73File "/app/candidate/views.py" in post
74 28. candidate_anchors_result.save()
75
76File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py" in save
77 718. force_update=force_update, update_fields=update_fields)
78
79File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py" in save_base
80 748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
81
82File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py" in _save_table
83 831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
84
85File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py" in _do_insert
86 869. using=using, raw=raw)
87
88File "/usr/local/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method
89 82. return getattr(self.get_queryset(), name)(*args, **kwargs)
90
91File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in _insert
92 1136. return query.get_compiler(using=using).execute_sql(return_id)
93
94File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
95 1289. cursor.execute(sql, params)
96
97File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
98 100. return super().execute(sql, params)
99
100File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
101 68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
102
103File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
104 77. return executor(sql, params, many, context)
105
106File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
107 85. return self.cursor.execute(sql, params)
108
109File "/usr/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
110 89. raise dj_exc_value.with_traceback(traceback) from exc_value
111
112File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
113 85. return self.cursor.execute(sql, params)
114
115Exception Type: ProgrammingError at /candidate/anchors_hook/
116Exception Value: column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
117LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
118 ^
119
120Request information:
121USER: AnonymousUser
122
123GET: No GET data
124
125POST: No POST data
126
127FILES: No FILES data
128
129COOKIES: No cookie data
130
131META:
132CONTENT_LENGTH = '26849'
133CONTENT_TYPE = 'application/json'
134DJANGO_SETTINGS_MODULE = 'makemymind.settings.local'
135GATEWAY_INTERFACE = 'CGI/1.1'
136GPG_KEY = '0D96DF4D4110E5C43FBFB17F2D347EA6AA65421D'
137HOME = '/root'
138HOSTNAME = 'b58cd16b67b0'
139HTTP_ACCEPT = '*/*'
140HTTP_ACCEPT_ENCODING = 'gzip, deflate'
141HTTP_CACHE_CONTROL = 'no-cache'
142HTTP_CONNECTION = 'keep-alive'
143HTTP_HOST = 'localhost:8000'
144HTTP_POSTMAN_TOKEN = '928a0feb-fa5e-4c67-8628-824c6807ae9c'
145HTTP_USER_AGENT = 'PostmanRuntime/7.6.0'
146LANG = 'C.UTF-8'
147PATH = '/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
148PATH_INFO = '/candidate/anchors_hook/'
149PYTHONUNBUFFERED = '1'
150PYTHON_PIP_VERSION = '18.1'
151PYTHON_VERSION = '3.6.8'
152QUERY_STRING = ''
153REMOTE_ADDR = '172.18.0.1'
154REMOTE_HOST = ''
155REQUEST_METHOD = 'POST'
156RUN_MAIN = 'true'
157SCRIPT_NAME = ''
158SERVER_NAME = 'b58cd16b67b0'
159SERVER_PORT = '8000'
160SERVER_PROTOCOL = 'HTTP/1.1'
161SERVER_SOFTWARE = 'WSGIServer/0.2'
162TERM = 'xterm'
163TZ = 'UTC'
164wsgi.errors = <_io.TextIOWrapper name='<stderr>' mode='w' encoding='UTF-8'>
165wsgi.file_wrapper = ''
166wsgi.input = <_io.BufferedReader name=6>
167wsgi.multiprocess = False
168wsgi.multithread = True
169wsgi.run_once = False
170wsgi.url_scheme = 'http'
171wsgi.version = '(1, 0)'
172
173Settings:
174Using settings module makemymind.settings.local
175ABSOLUTE_URL_OVERRIDES = {}
176ADMINS = []
177ALLOWED_HOSTS = []
178APPEND_SLASH = True
179AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
180AUTH_PASSWORD_VALIDATORS = '********************'
181AUTH_USER_MODEL = 'user.User'
182BASE_DIR = '/app/makemymind'
183CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
184CACHE_MIDDLEWARE_ALIAS = 'default'
185CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
186CACHE_MIDDLEWARE_SECONDS = 600
187CORS_ORIGIN_WHITELIST = ['app.makemymind.com', 'www.makemymind.com']
188CSRF_COOKIE_AGE = 31449600
189CSRF_COOKIE_DOMAIN = None
190CSRF_COOKIE_HTTPONLY = False
191CSRF_COOKIE_NAME = 'csrftoken'
192CSRF_COOKIE_PATH = '/'
193CSRF_COOKIE_SAMESITE = 'Lax'
194CSRF_COOKIE_SECURE = False
195CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
196CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
197CSRF_TRUSTED_ORIGINS = []
198CSRF_USE_SESSIONS = False
199DATABASES = {'default': {'ENGINE': 'django.contrib.gis.db.backends.postgis', 'NAME': 'mmm', 'USER': 'mmm', 'HOST': 'db', 'PORT': 5432, 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'PASSWORD': '********************', 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
200DATABASE_ROUTERS = []
201DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
202DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
203DATETIME_FORMAT = 'N j, Y, P'
204DATETIME_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']
205DATE_FORMAT = 'N j, Y'
206DATE_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']
207DEBUG = True
208DEBUG_PROPAGATE_EXCEPTIONS = False
209DECIMAL_SEPARATOR = '.'
210DEFAULT_CHARSET = 'utf-8'
211DEFAULT_CONTENT_TYPE = 'text/html'
212DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
213DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
214DEFAULT_FROM_EMAIL = 'webmaster@localhost'
215DEFAULT_INDEX_TABLESPACE = ''
216DEFAULT_TABLESPACE = ''
217DISALLOWED_USER_AGENTS = []
218EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
219EMAIL_HOST = 'localhost'
220EMAIL_HOST_PASSWORD = '********************'
221EMAIL_HOST_USER = ''
222EMAIL_PORT = 25
223EMAIL_SSL_CERTFILE = None
224EMAIL_SSL_KEYFILE = '********************'
225EMAIL_SUBJECT_PREFIX = '[Django] '
226EMAIL_TIMEOUT = None
227EMAIL_USE_LOCALTIME = False
228EMAIL_USE_SSL = False
229EMAIL_USE_TLS = False
230FILE_CHARSET = 'utf-8'
231FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
232FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
233FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
234FILE_UPLOAD_PERMISSIONS = None
235FILE_UPLOAD_TEMP_DIR = None
236FIRST_DAY_OF_WEEK = 0
237FIXTURE_DIRS = []
238FORCE_SCRIPT_NAME = None
239FORMAT_MODULE_PATH = None
240FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
241IGNORABLE_404_URLS = []
242INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'user', 'client', 'candidate', 'recruitment', 'rest_framework', 'rest_framework.authtoken', 'corsheaders']
243INTERNAL_IPS = []
244LANGUAGES = [('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')]
245LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
246LANGUAGE_CODE = 'en-us'
247LANGUAGE_COOKIE_AGE = None
248LANGUAGE_COOKIE_DOMAIN = None
249LANGUAGE_COOKIE_NAME = 'django_language'
250LANGUAGE_COOKIE_PATH = '/'
251LOCALE_PATHS = []
252LOGGING = {}
253LOGGING_CONFIG = 'logging.config.dictConfig'
254LOGIN_REDIRECT_URL = '/accounts/profile/'
255LOGIN_URL = '/accounts/login/'
256LOGOUT_REDIRECT_URL = None
257MANAGERS = []
258MEDIA_ROOT = ''
259MEDIA_URL = ''
260MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
261MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware']
262MIGRATION_MODULES = {}
263MONTH_DAY_FORMAT = 'F j'
264NUMBER_GROUPING = 0
265PASSWORD_HASHERS = '********************'
266PASSWORD_RESET_TIMEOUT_DAYS = '********************'
267PREPEND_WWW = False
268REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication',)}
269ROOT_URLCONF = 'makemymind.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 = 'makemymind.settings.local'
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 = '../static_root'
303STATIC_URL = '/static/'
304TEMPLATES = [{'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']}}]
305TEST_NON_SERIALIZED_APPS = []
306TEST_RUNNER = 'django.test.runner.DiscoverRunner'
307THOUSAND_SEPARATOR = ','
308TIME_FORMAT = 'P'
309TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
310TIME_ZONE = 'UTC'
311USE_I18N = True
312USE_L10N = True
313USE_THOUSAND_SEPARATOR = False
314USE_TZ = True
315USE_X_FORWARDED_HOST = False
316USE_X_FORWARDED_PORT = False
317WSGI_APPLICATION = 'makemymind.wsgi.application'
318X_FRAME_OPTIONS = 'SAMEORIGIN'
319YEAR_MONTH_FORMAT = 'F Y'
320
321
322You're seeing this error because you have DEBUG = True in your
323Django settings file. Change that to False, and Django will
324display a standard page generated by the handler for this status code.