API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 29th, 2019
167
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.71 KB | None | 0 0
raw download clone embed print report
  1. ProgrammingError at /candidate/anchors_hook/
  2. column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
  3. LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
  4. ^
  5.  
  6.  
  7. Request Method: POST
  8. Request URL: http://localhost:8000/candidate/anchors_hook/
  9. Django Version: 2.1.3
  10. Python Executable: /usr/local/bin/python
  11. Python Version: 3.6.8
  12. Python 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']
  13. Server time: Tue, 29 Jan 2019 20:42:32 +0000
  14. Installed 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']
  28. Installed 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.  
  39. Traceback:
  40.  
  41. File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
  42. 85. return self.cursor.execute(sql, params)
  43.  
  44. The above exception (column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
  45. LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
  46. ^
  47. ) was the direct cause of the following exception:
  48.  
  49. File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
  50. 34. response = get_response(request)
  51.  
  52. File "/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.  
  55. File "/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.  
  58. File "/usr/local/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
  59. 54. return view_func(*args, **kwargs)
  60.  
  61. File "/usr/local/lib/python3.6/site-packages/django/views/generic/base.py" in view
  62. 68. return self.dispatch(request, *args, **kwargs)
  63.  
  64. File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
  65. 495. response = self.handle_exception(exc)
  66.  
  67. File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
  68. 455. self.raise_uncaught_exception(exc)
  69.  
  70. File "/usr/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
  71. 492. response = handler(request, *args, **kwargs)
  72.  
  73. File "/app/candidate/views.py" in post
  74. 28. candidate_anchors_result.save()
  75.  
  76. File "/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.  
  79. File "/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.  
  82. File "/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.  
  85. File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py" in _do_insert
  86. 869. using=using, raw=raw)
  87.  
  88. File "/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.  
  91. File "/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.  
  94. File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
  95. 1289. cursor.execute(sql, params)
  96.  
  97. File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
  98. 100. return super().execute(sql, params)
  99.  
  100. File "/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.  
  103. File "/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.  
  106. File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
  107. 85. return self.cursor.execute(sql, params)
  108.  
  109. File "/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.  
  112. File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
  113. 85. return self.cursor.execute(sql, params)
  114.  
  115. Exception Type: ProgrammingError at /candidate/anchors_hook/
  116. Exception Value: column "technical_functional" of relation "candidate_candidateanchorsresult" does not exist
  117. LINE 1: ...ndidate_candidateanchorsresult" ("name", "email", "technical...
  118. ^
  119.  
  120. Request information:
  121. USER: AnonymousUser
  122.  
  123. GET: No GET data
  124.  
  125. POST: No POST data
  126.  
  127. FILES: No FILES data
  128.  
  129. COOKIES: No cookie data
  130.  
  131. META:
  132. CONTENT_LENGTH = '26849'
  133. CONTENT_TYPE = 'application/json'
  134. DJANGO_SETTINGS_MODULE = 'makemymind.settings.local'
  135. GATEWAY_INTERFACE = 'CGI/1.1'
  136. GPG_KEY = '0D96DF4D4110E5C43FBFB17F2D347EA6AA65421D'
  137. HOME = '/root'
  138. HOSTNAME = 'b58cd16b67b0'
  139. HTTP_ACCEPT = '*/*'
  140. HTTP_ACCEPT_ENCODING = 'gzip, deflate'
  141. HTTP_CACHE_CONTROL = 'no-cache'
  142. HTTP_CONNECTION = 'keep-alive'
  143. HTTP_HOST = 'localhost:8000'
  144. HTTP_POSTMAN_TOKEN = '928a0feb-fa5e-4c67-8628-824c6807ae9c'
  145. HTTP_USER_AGENT = 'PostmanRuntime/7.6.0'
  146. LANG = 'C.UTF-8'
  147. PATH = '/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
  148. PATH_INFO = '/candidate/anchors_hook/'
  149. PYTHONUNBUFFERED = '1'
  150. PYTHON_PIP_VERSION = '18.1'
  151. PYTHON_VERSION = '3.6.8'
  152. QUERY_STRING = ''
  153. REMOTE_ADDR = '172.18.0.1'
  154. REMOTE_HOST = ''
  155. REQUEST_METHOD = 'POST'
  156. RUN_MAIN = 'true'
  157. SCRIPT_NAME = ''
  158. SERVER_NAME = 'b58cd16b67b0'
  159. SERVER_PORT = '8000'
  160. SERVER_PROTOCOL = 'HTTP/1.1'
  161. SERVER_SOFTWARE = 'WSGIServer/0.2'
  162. TERM = 'xterm'
  163. TZ = 'UTC'
  164. wsgi.errors = <_io.TextIOWrapper name='<stderr>' mode='w' encoding='UTF-8'>
  165. wsgi.file_wrapper = ''
  166. wsgi.input = <_io.BufferedReader name=6>
  167. wsgi.multiprocess = False
  168. wsgi.multithread = True
  169. wsgi.run_once = False
  170. wsgi.url_scheme = 'http'
  171. wsgi.version = '(1, 0)'
  172.  
  173. Settings:
  174. Using settings module makemymind.settings.local
  175. ABSOLUTE_URL_OVERRIDES = {}
  176. ADMINS = []
  177. ALLOWED_HOSTS = []
  178. APPEND_SLASH = True
  179. AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
  180. AUTH_PASSWORD_VALIDATORS = '********************'
  181. AUTH_USER_MODEL = 'user.User'
  182. BASE_DIR = '/app/makemymind'
  183. CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
  184. CACHE_MIDDLEWARE_ALIAS = 'default'
  185. CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
  186. CACHE_MIDDLEWARE_SECONDS = 600
  187. CORS_ORIGIN_WHITELIST = ['app.makemymind.com', 'www.makemymind.com']
  188. CSRF_COOKIE_AGE = 31449600
  189. CSRF_COOKIE_DOMAIN = None
  190. CSRF_COOKIE_HTTPONLY = False
  191. CSRF_COOKIE_NAME = 'csrftoken'
  192. CSRF_COOKIE_PATH = '/'
  193. CSRF_COOKIE_SAMESITE = 'Lax'
  194. CSRF_COOKIE_SECURE = False
  195. CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
  196. CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
  197. CSRF_TRUSTED_ORIGINS = []
  198. CSRF_USE_SESSIONS = False
  199. DATABASES = {'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}}}
  200. DATABASE_ROUTERS = []
  201. DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
  202. DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
  203. DATETIME_FORMAT = 'N j, Y, P'
  204. 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']
  205. DATE_FORMAT = 'N j, Y'
  206. 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']
  207. DEBUG = True
  208. DEBUG_PROPAGATE_EXCEPTIONS = False
  209. DECIMAL_SEPARATOR = '.'
  210. DEFAULT_CHARSET = 'utf-8'
  211. DEFAULT_CONTENT_TYPE = 'text/html'
  212. DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
  213. DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
  214. DEFAULT_FROM_EMAIL = 'webmaster@localhost'
  215. DEFAULT_INDEX_TABLESPACE = ''
  216. DEFAULT_TABLESPACE = ''
  217. DISALLOWED_USER_AGENTS = []
  218. EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
  219. EMAIL_HOST = 'localhost'
  220. EMAIL_HOST_PASSWORD = '********************'
  221. EMAIL_HOST_USER = ''
  222. EMAIL_PORT = 25
  223. EMAIL_SSL_CERTFILE = None
  224. EMAIL_SSL_KEYFILE = '********************'
  225. EMAIL_SUBJECT_PREFIX = '[Django] '
  226. EMAIL_TIMEOUT = None
  227. EMAIL_USE_LOCALTIME = False
  228. EMAIL_USE_SSL = False
  229. EMAIL_USE_TLS = False
  230. FILE_CHARSET = 'utf-8'
  231. FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
  232. FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
  233. FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
  234. FILE_UPLOAD_PERMISSIONS = None
  235. FILE_UPLOAD_TEMP_DIR = None
  236. FIRST_DAY_OF_WEEK = 0
  237. FIXTURE_DIRS = []
  238. FORCE_SCRIPT_NAME = None
  239. FORMAT_MODULE_PATH = None
  240. FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
  241. IGNORABLE_404_URLS = []
  242. INSTALLED_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']
  243. INTERNAL_IPS = []
  244. LANGUAGES = [('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')]
  245. LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
  246. LANGUAGE_CODE = 'en-us'
  247. LANGUAGE_COOKIE_AGE = None
  248. LANGUAGE_COOKIE_DOMAIN = None
  249. LANGUAGE_COOKIE_NAME = 'django_language'
  250. LANGUAGE_COOKIE_PATH = '/'
  251. LOCALE_PATHS = []
  252. LOGGING = {}
  253. LOGGING_CONFIG = 'logging.config.dictConfig'
  254. LOGIN_REDIRECT_URL = '/accounts/profile/'
  255. LOGIN_URL = '/accounts/login/'
  256. LOGOUT_REDIRECT_URL = None
  257. MANAGERS = []
  258. MEDIA_ROOT = ''
  259. MEDIA_URL = ''
  260. MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
  261. MIDDLEWARE = ['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']
  262. MIGRATION_MODULES = {}
  263. MONTH_DAY_FORMAT = 'F j'
  264. NUMBER_GROUPING = 0
  265. PASSWORD_HASHERS = '********************'
  266. PASSWORD_RESET_TIMEOUT_DAYS = '********************'
  267. PREPEND_WWW = False
  268. REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication',)}
  269. ROOT_URLCONF = 'makemymind.urls'
  270. SECRET_KEY = '********************'
  271. SECURE_BROWSER_XSS_FILTER = False
  272. SECURE_CONTENT_TYPE_NOSNIFF = False
  273. SECURE_HSTS_INCLUDE_SUBDOMAINS = False
  274. SECURE_HSTS_PRELOAD = False
  275. SECURE_HSTS_SECONDS = 0
  276. SECURE_PROXY_SSL_HEADER = None
  277. SECURE_REDIRECT_EXEMPT = []
  278. SECURE_SSL_HOST = None
  279. SECURE_SSL_REDIRECT = False
  280. SERVER_EMAIL = 'root@localhost'
  281. SESSION_CACHE_ALIAS = 'default'
  282. SESSION_COOKIE_AGE = 1209600
  283. SESSION_COOKIE_DOMAIN = None
  284. SESSION_COOKIE_HTTPONLY = True
  285. SESSION_COOKIE_NAME = 'sessionid'
  286. SESSION_COOKIE_PATH = '/'
  287. SESSION_COOKIE_SAMESITE = 'Lax'
  288. SESSION_COOKIE_SECURE = False
  289. SESSION_ENGINE = 'django.contrib.sessions.backends.db'
  290. SESSION_EXPIRE_AT_BROWSER_CLOSE = False
  291. SESSION_FILE_PATH = None
  292. SESSION_SAVE_EVERY_REQUEST = False
  293. SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
  294. SETTINGS_MODULE = 'makemymind.settings.local'
  295. SHORT_DATETIME_FORMAT = 'm/d/Y P'
  296. SHORT_DATE_FORMAT = 'm/d/Y'
  297. SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
  298. SILENCED_SYSTEM_CHECKS = []
  299. STATICFILES_DIRS = []
  300. STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
  301. STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
  302. STATIC_ROOT = '../static_root'
  303. STATIC_URL = '/static/'
  304. TEMPLATES = [{'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']}}]
  305. TEST_NON_SERIALIZED_APPS = []
  306. TEST_RUNNER = 'django.test.runner.DiscoverRunner'
  307. THOUSAND_SEPARATOR = ','
  308. TIME_FORMAT = 'P'
  309. TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
  310. TIME_ZONE = 'UTC'
  311. USE_I18N = True
  312. USE_L10N = True
  313. USE_THOUSAND_SEPARATOR = False
  314. USE_TZ = True
  315. USE_X_FORWARDED_HOST = False
  316. USE_X_FORWARDED_PORT = False
  317. WSGI_APPLICATION = 'makemymind.wsgi.application'
  318. X_FRAME_OPTIONS = 'SAMEORIGIN'
  319. YEAR_MONTH_FORMAT = 'F Y'
  320.  
  321.  
  322. You're seeing this error because you have DEBUG = True in your
  323. Django settings file. Change that to False, and Django will
  324. display a standard page generated by the handler for this status code.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!