· 5 years ago · Jun 04, 2020, 02:08 PM
1ProgrammingError at /api/core/product/10706/
2column core_offer.rvi_price does not exist
3LINE 1: ..._planned_from", "core_offer"."dc_eta_planned_to", "core_offe...
4 ^
5
6
7Request Method: GET
8Request URL: http://localhost:8000/api/core/product/10706/
9Django Version: 2.2.10
10Python Executable: /usr/local/bin/python
11Python Version: 3.7.7
12Python Path: ['/usr/src/app', '/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: Чт, 4 Июн 2020 14:03:22 +0000
14Installed Applications:
15['django_object_actions',
16 'django.contrib.admin',
17 'django.contrib.auth',
18 'django.contrib.contenttypes',
19 'django.contrib.sessions',
20 'django.contrib.messages',
21 'django.contrib.staticfiles',
22 'mptt',
23 'rest_framework',
24 'widget_tweaks',
25 'drf_yasg',
26 'corsheaders',
27 'core',
28 'users']
29Installed Middleware:
30['corsheaders.middleware.CorsMiddleware',
31 'django.middleware.security.SecurityMiddleware',
32 'django.contrib.sessions.middleware.SessionMiddleware',
33 'django.middleware.locale.LocaleMiddleware',
34 'django.middleware.common.CommonMiddleware',
35 'django.middleware.csrf.CsrfViewMiddleware',
36 'django.contrib.auth.middleware.AuthenticationMiddleware',
37 'django.contrib.messages.middleware.MessageMiddleware',
38 'django.middleware.clickjacking.XFrameOptionsMiddleware']
39
40
41Traceback:
42
43File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
44 84. return self.cursor.execute(sql, params)
45
46The above exception (column core_offer.rvi_price does not exist
47LINE 1: ..._planned_from", "core_offer"."dc_eta_planned_to", "core_offe...
48 ^
49) was the direct cause of the following exception:
50
51File "/usr/local/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
52 34. response = get_response(request)
53
54File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
55 115. response = self.process_exception_by_middleware(e, request)
56
57File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
58 113. response = wrapped_callback(request, *callback_args, **callback_kwargs)
59
60File "/usr/local/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
61 54. return view_func(*args, **kwargs)
62
63File "/usr/local/lib/python3.7/site-packages/django/views/generic/base.py" in view
64 71. return self.dispatch(request, *args, **kwargs)
65
66File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
67 505. response = self.handle_exception(exc)
68
69File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
70 465. self.raise_uncaught_exception(exc)
71
72File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in raise_uncaught_exception
73 476. raise exc
74
75File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
76 502. response = handler(request, *args, **kwargs)
77
78File "/usr/src/app/core/views/product.py" in get
79 66. many=True
80
81File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
82 760. ret = super().data
83
84File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in data
85 260. self._data = self.to_representation(self.instance)
86
87File "/usr/local/lib/python3.7/site-packages/rest_framework/serializers.py" in to_representation
88 678. self.child.to_representation(item) for item in iterable
89
90File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
91 274. self._fetch_all()
92
93File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in _fetch_all
94 1242. self._result_cache = list(self._iterable_class(self))
95
96File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in __iter__
97 55. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
98
99File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
100 1133. cursor.execute(sql, params)
101
102File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
103 99. return super().execute(sql, params)
104
105File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
106 67. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
107
108File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
109 76. return executor(sql, params, many, context)
110
111File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
112 84. return self.cursor.execute(sql, params)
113
114File "/usr/local/lib/python3.7/site-packages/django/db/utils.py" in __exit__
115 89. raise dj_exc_value.with_traceback(traceback) from exc_value
116
117File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
118 84. return self.cursor.execute(sql, params)
119
120Exception Type: ProgrammingError at /api/core/product/10706/
121Exception Value: column core_offer.rvi_price does not exist
122LINE 1: ..._planned_from", "core_offer"."dc_eta_planned_to", "core_offe...
123 ^
124
125Request information:
126USER: supplier@supplier.ru
127
128GET: No GET data
129
130POST: No POST data
131
132FILES: No FILES data
133
134COOKIES: No cookie data
135
136META:
137CONTENT_LENGTH = ''
138CONTENT_TYPE = 'text/plain'
139DATABASE_URL = 'psql://admin_import:a43b44c45@db:5432/import'
140DEBUG = '1'
141DJANGO_ALLOWED_HOSTS = 'localhost 127.0.0.1 [::1]'
142DJANGO_SETTINGS_MODULE = 'import.settings'
143GATEWAY_INTERFACE = 'CGI/1.1'
144GPG_KEY = '0D96DF4D4110E5C43FBFB17F2D347EA6AA65421D'
145HOME = '/root'
146HOSTNAME = '044ed8dc152b'
147HTTP_ACCEPT = 'application/json, text/plain, */*'
148HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
149HTTP_ACCEPT_LANGUAGE = 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7'
150HTTP_AUTHORIZATION = 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoyLCJ1c2VybmFtZSI6InN1cHBsaWVyQHN1cHBsaWVyLnJ1IiwiZXhwIjoxNTkxMjgyMzY3LCJlbWFpbCI6InN1cHBsaWVyQHN1cHBsaWVyLnJ1In0.-Y7jM6NcNc9EkAbpb7noebBflcMEEWE9j1J4E8WW8KU'
151HTTP_CONNECTION = 'keep-alive'
152HTTP_DNT = '1'
153HTTP_HOST = 'localhost:8000'
154HTTP_ORIGIN = 'http://localhost:3000'
155HTTP_REFERER = 'http://localhost:3000/supplier/trade/10706'
156HTTP_SEC_FETCH_DEST = 'empty'
157HTTP_SEC_FETCH_MODE = 'cors'
158HTTP_SEC_FETCH_SITE = 'same-site'
159HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36'
160LANG = 'C.UTF-8'
161PATH = '/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
162PATH_INFO = '/api/core/product/10706/'
163PWD = '/usr/src/app'
164PYTHONDONTWRITEBYTECODE = '1'
165PYTHONUNBUFFERED = '1'
166PYTHON_GET_PIP_SHA256 = '421ac1d44c0cf9730a088e337867d974b91bdce4ea2636099275071878cc189e'
167PYTHON_GET_PIP_URL = 'https://github.com/pypa/get-pip/raw/d59197a3c169cef378a22428a3fa99d33e080a5d/get-pip.py'
168PYTHON_PIP_VERSION = '20.0.2'
169PYTHON_VERSION = '3.7.7'
170QUERY_STRING = ''
171REMOTE_ADDR = '172.21.0.1'
172REMOTE_HOST = ''
173REQUEST_METHOD = 'GET'
174RUN_MAIN = 'true'
175SCRIPT_NAME = ''
176SECRET_KEY = '6xjhf1z%y0hnfw7mb*p2eq_z7g!i%8f^b6v(=3=_&0h4ak5!#$'
177SERVER_NAME = '044ed8dc152b'
178SERVER_PORT = '8000'
179SERVER_PROTOCOL = 'HTTP/1.1'
180SERVER_SOFTWARE = 'WSGIServer/0.2'
181SHLVL = '1'
182TZ = 'UTC'
183wsgi.errors = <_io.TextIOWrapper name='<stderr>' mode='w' encoding='UTF-8'>
184wsgi.file_wrapper = ''
185wsgi.input = <django.core.handlers.wsgi.LimitedStream object at 0x7fc92f86d050>
186wsgi.multiprocess = False
187wsgi.multithread = True
188wsgi.run_once = False
189wsgi.url_scheme = 'http'
190wsgi.version = '(1, 0)'
191
192Settings:
193Using settings module import.settings
194ABSOLUTE_URL_OVERRIDES = {}
195ADMINS = []
196ALLOWED_FILE_WITH_PRODUCTS_EXTENSIONS = ['.xlsx', '.xlsm', '.xltx', '.xltm', '.xls']
197ALLOWED_HOSTS = ['*']
198ANYMAIL = {'SENDGRID_API_KEY': '********************'}
199APPEND_SLASH = True
200AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
201AUTH_PASSWORD_VALIDATORS = '********************'
202AUTH_USER_MODEL = 'users.User'
203BASE_DIR = '/usr/src/app'
204CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
205CACHE_MIDDLEWARE_ALIAS = 'default'
206CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
207CACHE_MIDDLEWARE_SECONDS = 600
208CORS_ORIGIN_ALLOW_ALL = True
209CSRF_COOKIE_AGE = 31449600
210CSRF_COOKIE_DOMAIN = None
211CSRF_COOKIE_HTTPONLY = False
212CSRF_COOKIE_NAME = 'csrftoken'
213CSRF_COOKIE_PATH = '/'
214CSRF_COOKIE_SAMESITE = 'Lax'
215CSRF_COOKIE_SECURE = False
216CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
217CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
218CSRF_TRUSTED_ORIGINS = []
219CSRF_USE_SESSIONS = False
220DATABASES = {'default': {'NAME': 'import', 'USER': 'admin_import', 'PASSWORD': '********************', 'HOST': 'db', 'PORT': 5432, 'ENGINE': 'django.db.backends.postgresql', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
221DATABASE_ROUTERS = []
222DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
223DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
224DATETIME_FORMAT = 'N j, Y, P'
225DATETIME_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']
226DATE_FORMAT = 'N j, Y'
227DATE_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']
228DEBUG = True
229DEBUG_PROPAGATE_EXCEPTIONS = False
230DECIMAL_SEPARATOR = '.'
231DEFAULT_CHARSET = 'utf-8'
232DEFAULT_CONTENT_TYPE = 'text/html'
233DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
234DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
235DEFAULT_FROM_EMAIL = 'webmaster@localhost'
236DEFAULT_INDEX_TABLESPACE = ''
237DEFAULT_TABLESPACE = ''
238DISALLOWED_USER_AGENTS = []
239EMAIL_BACKEND = 'anymail.backends.sendgrid.EmailBackend'
240EMAIL_HOST = 'localhost'
241EMAIL_HOST_PASSWORD = '********************'
242EMAIL_HOST_USER = ''
243EMAIL_PORT = 25
244EMAIL_SSL_CERTFILE = None
245EMAIL_SSL_KEYFILE = '********************'
246EMAIL_SUBJECT_PREFIX = '[Django] '
247EMAIL_TIMEOUT = None
248EMAIL_USE_LOCALTIME = False
249EMAIL_USE_SSL = False
250EMAIL_USE_TLS = False
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'
262IGNORABLE_404_URLS = []
263INSTALLED_APPS = ['django_object_actions', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'mptt', 'rest_framework', 'widget_tweaks', 'drf_yasg', 'corsheaders', 'core', 'users']
264INTERNAL_IPS = []
265JWT_AUTH = {'JWT_ENCODE_HANDLER': 'rest_framework_jwt.utils.jwt_encode_handler', 'JWT_DECODE_HANDLER': 'rest_framework_jwt.utils.jwt_decode_handler', 'JWT_PAYLOAD_HANDLER': 'rest_framework_jwt.utils.jwt_payload_handler', 'JWT_PAYLOAD_GET_USER_ID_HANDLER': 'rest_framework_jwt.utils.jwt_get_user_id_from_payload_handler', 'JWT_RESPONSE_PAYLOAD_HANDLER': 'rest_framework_jwt.utils.jwt_response_payload_handler', 'JWT_VERIFY': True, 'JWT_VERIFY_EXPIRATION': True, 'JWT_EXPIRATION_DELTA': datetime.timedelta(seconds=3000), 'JWT_AUTH_HEADER_PREFIX': 'Bearer'}
266LANGUAGES = "(('en', 'Английский'), ('ru-ru', 'Русский'))"
267LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
268LANGUAGE_CODE = 'ru-ru'
269LANGUAGE_COOKIE_AGE = None
270LANGUAGE_COOKIE_DOMAIN = None
271LANGUAGE_COOKIE_NAME = 'django_language'
272LANGUAGE_COOKIE_PATH = '/'
273LOCALE_PATHS = ['/usr/src/app/locale']
274LOGGING = {}
275LOGGING_CONFIG = 'logging.config.dictConfig'
276LOGIN_REDIRECT_URL = '/admin'
277LOGIN_URL = '/'
278LOGOUT_REDIRECT_URL = '/'
279MANAGERS = []
280MAX_FILE_WITH_PRODUCTS_SIZE = 5242880
281MEDIA_ROOT = ''
282MEDIA_URL = ''
283MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
284MIDDLEWARE = ['corsheaders.middleware.CorsMiddleware', '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']
285MIGRATION_MODULES = {}
286MONTH_DAY_FORMAT = 'F j'
287NUMBER_GROUPING = 0
288PASSWORD_HASHERS = '********************'
289PASSWORD_RESET_TIMEOUT_DAYS = '********************'
290PREPEND_WWW = False
291REST_FRAMEWORK = {'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAuthenticated', 'rest_framework.permissions.IsAdminUser'), 'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework_jwt.authentication.JSONWebTokenAuthentication', 'rest_framework.authentication.SessionAuthentication', 'rest_framework.authentication.BasicAuthentication')}
292ROOT_URLCONF = 'import.urls'
293SECRET_KEY = '********************'
294SECURE_BROWSER_XSS_FILTER = False
295SECURE_CONTENT_TYPE_NOSNIFF = False
296SECURE_HSTS_INCLUDE_SUBDOMAINS = False
297SECURE_HSTS_PRELOAD = False
298SECURE_HSTS_SECONDS = 0
299SECURE_PROXY_SSL_HEADER = None
300SECURE_REDIRECT_EXEMPT = []
301SECURE_SSL_HOST = None
302SECURE_SSL_REDIRECT = False
303SERVER_EMAIL = 'root@localhost'
304SESSION_CACHE_ALIAS = 'default'
305SESSION_COOKIE_AGE = 1209600
306SESSION_COOKIE_DOMAIN = None
307SESSION_COOKIE_HTTPONLY = True
308SESSION_COOKIE_NAME = 'sessionid'
309SESSION_COOKIE_PATH = '/'
310SESSION_COOKIE_SAMESITE = 'Lax'
311SESSION_COOKIE_SECURE = False
312SESSION_ENGINE = 'django.contrib.sessions.backends.db'
313SESSION_EXPIRE_AT_BROWSER_CLOSE = False
314SESSION_FILE_PATH = None
315SESSION_SAVE_EVERY_REQUEST = False
316SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
317SETTINGS_MODULE = 'import.settings'
318SHORT_DATETIME_FORMAT = 'm/d/Y P'
319SHORT_DATE_FORMAT = 'm/d/Y'
320SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
321SILENCED_SYSTEM_CHECKS = []
322STATICFILES_DIRS = "('/usr/src/app/static',)"
323STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
324STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
325STATIC_ROOT = '/usr/src/app/staticfiles'
326STATIC_URL = '/static/'
327TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/usr/src/app/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']}}]
328TEST_NON_SERIALIZED_APPS = []
329TEST_RUNNER = 'django.test.runner.DiscoverRunner'
330THOUSAND_SEPARATOR = ','
331TIME_FORMAT = 'P'
332TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
333TIME_ZONE = 'UTC'
334USE_I18N = True
335USE_L10N = True
336USE_THOUSAND_SEPARATOR = False
337USE_TZ = True
338USE_X_FORWARDED_HOST = False
339USE_X_FORWARDED_PORT = False
340WSGI_APPLICATION = 'import.wsgi.application'
341X_FRAME_OPTIONS = 'SAMEORIGIN'
342YEAR_MONTH_FORMAT = 'F Y'
343
344
345You're seeing this error because you have DEBUG = True in your
346Django settings file. Change that to False, and Django will
347display a standard page generated by the handler for this status code.