· 6 years ago · Oct 06, 2019, 08:48 AM
1ProgrammingError at /signup1/
2relation "base_tech_usercache" does not exist
3LINE 1: INSERT INTO "base_tech_usercache" ("phone_no") VALUES (98104...
4 ^
5
6
7Request Method: POST
8Request URL: http://my-tech-start.herokuapp.com/signup1/
9Django Version: 2.2.5
10Python Executable: /app/.heroku/python/bin/python
11Python Version: 3.6.9
12Python Path: ['/app/my_tech_start', '/app/.heroku/python/bin', '/app', '/app/.heroku/python/lib/python36.zip', '/app/.heroku/python/lib/python3.6', '/app/.heroku/python/lib/python3.6/lib-dynload', '/app/.heroku/python/lib/python3.6/site-packages']
13Server time: Sat, 5 Oct 2019 15:58:38 +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 'base_tech',
22 'paytm',
23 'rest_framework']
24Installed Middleware:
25('whitenoise.middleware.WhiteNoiseMiddleware',
26 'django.middleware.security.SecurityMiddleware',
27 'whitenoise.middleware.WhiteNoiseMiddleware',
28 'django.contrib.sessions.middleware.SessionMiddleware',
29 'django.middleware.common.CommonMiddleware',
30 'django.contrib.auth.middleware.AuthenticationMiddleware',
31 'django.contrib.messages.middleware.MessageMiddleware',
32 'django.middleware.clickjacking.XFrameOptionsMiddleware',
33 'django.middleware.security.SecurityMiddleware')
34
35
36Traceback:
37
38File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
39 84. return self.cursor.execute(sql, params)
40
41The above exception (relation "base_tech_usercache" does not exist
42LINE 1: INSERT INTO "base_tech_usercache" ("phone_no") VALUES (98104...
43 ^
44) was the direct cause of the following exception:
45
46File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
47 34. response = get_response(request)
48
49File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
50 115. response = self.process_exception_by_middleware(e, request)
51
52File "/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
53 113. response = wrapped_callback(request, *callback_args, **callback_kwargs)
54
55File "/app/.heroku/python/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
56 54. return view_func(*args, **kwargs)
57
58File "/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/base.py" in view
59 71. return self.dispatch(request, *args, **kwargs)
60
61File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
62 505. response = self.handle_exception(exc)
63
64File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
65 465. self.raise_uncaught_exception(exc)
66
67File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in raise_uncaught_exception
68 476. raise exc
69
70File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
71 502. response = handler(request, *args, **kwargs)
72
73File "/app/.heroku/python/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
74 54. return view_func(*args, **kwargs)
75
76File "/app/my_tech_start/base_tech/views.py" in post
77 40. serializer.save()
78
79File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/serializers.py" in save
80 213. self.instance = self.create(validated_data)
81
82File "/app/.heroku/python/lib/python3.6/site-packages/rest_framework/serializers.py" in create
83 932. instance = ModelClass._default_manager.create(**validated_data)
84
85File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method
86 82. return getattr(self.get_queryset(), name)(*args, **kwargs)
87
88File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py" in create
89 422. obj.save(force_insert=True, using=self.db)
90
91File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py" in save
92 741. force_update=force_update, update_fields=update_fields)
93
94File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py" in save_base
95 779. force_update, using, update_fields,
96
97File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py" in _save_table
98 870. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
99
100File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py" in _do_insert
101 908. using=using, raw=raw)
102
103File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method
104 82. return getattr(self.get_queryset(), name)(*args, **kwargs)
105
106File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py" in _insert
107 1186. return query.get_compiler(using=using).execute_sql(return_id)
108
109File "/app/.heroku/python/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
110 1335. cursor.execute(sql, params)
111
112File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
113 99. return super().execute(sql, params)
114
115File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
116 67. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
117
118File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
119 76. return executor(sql, params, many, context)
120
121File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
122 84. return self.cursor.execute(sql, params)
123
124File "/app/.heroku/python/lib/python3.6/site-packages/django/db/utils.py" in __exit__
125 89. raise dj_exc_value.with_traceback(traceback) from exc_value
126
127File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
128 84. return self.cursor.execute(sql, params)
129
130Exception Type: ProgrammingError at /signup1/
131Exception Value: relation "base_tech_usercache" does not exist
132LINE 1: INSERT INTO "base_tech_usercache" ("phone_no") VALUES (98104...
133 ^
134
135Request information:
136USER: AnonymousUser
137
138GET: No GET data
139
140POST:
141phone_no = '9810445'
142
143FILES: No FILES data
144
145COOKIES: No cookie data
146
147META:
148CONTENT_LENGTH = '16'
149CONTENT_TYPE = 'application/x-www-form-urlencoded'
150HTTP_ACCEPT = '*/*'
151HTTP_ACCEPT_ENCODING = 'gzip'
152HTTP_ACCEPT_LANGUAGE = 'en-IN,en-US;q=0.9,en;q=0.8'
153HTTP_CACHE_CONTROL = 'no-cache'
154HTTP_CONNECTION = 'close'
155HTTP_CONNECT_TIME = '0'
156HTTP_HOST = 'my-tech-start.herokuapp.com'
157HTTP_ORIGIN = 'chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop'
158HTTP_POSTMAN_TOKEN = '177ae439-8115-142f-f5db-0aee26253858'
159HTTP_TOTAL_ROUTE_TIME = '0'
160HTTP_USER_AGENT = 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36'
161HTTP_VIA = '1.1 IITRWSA08.iitr.ac.in:80 (Cisco-WSA/11.7.0-407), 1.1 vegur'
162HTTP_X_FORWARDED_FOR = '103.37.200.214'
163HTTP_X_FORWARDED_PORT = '80'
164HTTP_X_FORWARDED_PROTO = 'http'
165HTTP_X_IMFORWARDS = '20'
166HTTP_X_REQUEST_ID = '8e5dad37-94b7-406f-add4-f7c11fbd4dcd'
167HTTP_X_REQUEST_START = '1570291118358'
168PATH_INFO = '/signup1/'
169QUERY_STRING = ''
170RAW_URI = '/signup1/'
171REMOTE_ADDR = '10.123.144.18'
172REMOTE_PORT = '23903'
173REQUEST_METHOD = 'POST'
174SCRIPT_NAME = ''
175SERVER_NAME = '0.0.0.0'
176SERVER_PORT = '8357'
177SERVER_PROTOCOL = 'HTTP/1.1'
178SERVER_SOFTWARE = 'gunicorn/19.9.0'
179gunicorn.socket = <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('172.16.162.18', 8357), raddr=('10.123.144.18', 23903)>
180wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f0eb7417c18>
181wsgi.file_wrapper = ''
182wsgi.input = <gunicorn.http.body.Body object at 0x7f0eb74178d0>
183wsgi.multiprocess = True
184wsgi.multithread = False
185wsgi.run_once = False
186wsgi.url_scheme = 'http'
187wsgi.version = '(1, 0)'
188
189Settings:
190Using settings module my_tech_start.settings
191ABSOLUTE_URL_OVERRIDES = {}
192ADMINS = []
193ALLOWED_HOSTS = ['*']
194APPEND_SLASH = True
195AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
196AUTH_PASSWORD_VALIDATORS = '********************'
197AUTH_USER_MODEL = 'auth.User'
198BASE_DIR = '/app/my_tech_start'
199CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
200CACHE_MIDDLEWARE_ALIAS = 'default'
201CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
202CACHE_MIDDLEWARE_SECONDS = 600
203CSRF_COOKIE_AGE = 31449600
204CSRF_COOKIE_DOMAIN = None
205CSRF_COOKIE_HTTPONLY = False
206CSRF_COOKIE_NAME = 'csrftoken'
207CSRF_COOKIE_PATH = '/'
208CSRF_COOKIE_SAMESITE = 'Lax'
209CSRF_COOKIE_SECURE = False
210CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
211CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
212CSRF_TRUSTED_ORIGINS = []
213CSRF_USE_SESSIONS = False
214DATABASES = {'default': {'NAME': 'd5q733a96ff07j', 'USER': 'lehmomhgeimyck', 'PASSWORD': '********************', 'HOST': 'ec2-54-83-9-169.compute-1.amazonaws.com', 'PORT': 5432, 'CONN_MAX_AGE': 600, 'OPTIONS': {'sslmode': 'require'}, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
215DATABASE_ROUTERS = []
216DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
217DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
218DATETIME_FORMAT = 'N j, Y, P'
219DATETIME_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']
220DATE_FORMAT = 'N j, Y'
221DATE_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']
222DEBUG = True
223DEBUG_PROPAGATE_EXCEPTIONS = False
224DECIMAL_SEPARATOR = '.'
225DEFAULT_CHARSET = 'utf-8'
226DEFAULT_CONTENT_TYPE = 'text/html'
227DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
228DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
229DEFAULT_FROM_EMAIL = 'webmaster@localhost'
230DEFAULT_INDEX_TABLESPACE = ''
231DEFAULT_TABLESPACE = ''
232DISALLOWED_USER_AGENTS = []
233EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
234EMAIL_HOST = 'localhost'
235EMAIL_HOST_PASSWORD = '********************'
236EMAIL_HOST_USER = ''
237EMAIL_PORT = 25
238EMAIL_SSL_CERTFILE = None
239EMAIL_SSL_KEYFILE = '********************'
240EMAIL_SUBJECT_PREFIX = '[Django] '
241EMAIL_TIMEOUT = None
242EMAIL_USE_LOCALTIME = False
243EMAIL_USE_SSL = False
244EMAIL_USE_TLS = False
245FILE_CHARSET = 'utf-8'
246FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
247FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
248FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
249FILE_UPLOAD_PERMISSIONS = None
250FILE_UPLOAD_TEMP_DIR = None
251FIRST_DAY_OF_WEEK = 0
252FIXTURE_DIRS = []
253FORCE_SCRIPT_NAME = None
254FORMAT_MODULE_PATH = None
255FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
256HOST_URL = 'http://hemantyadav.pythonanywhere.com/'
257IGNORABLE_404_URLS = []
258INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'base_tech', 'paytm', 'rest_framework']
259INTERNAL_IPS = []
260LANGUAGES = [('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'), ('hy', 'Armenian'), ('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')]
261LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
262LANGUAGE_CODE = 'en-us'
263LANGUAGE_COOKIE_AGE = None
264LANGUAGE_COOKIE_DOMAIN = None
265LANGUAGE_COOKIE_NAME = 'django_language'
266LANGUAGE_COOKIE_PATH = '/'
267LOCALE_PATHS = []
268LOGGING = {'version': 1, 'disable_existing_loggers': False, 'formatters': {'verbose': {'format': '%(asctime)s [%(process)d] [%(levelname)s] pathname=%(pathname)s lineno=%(lineno)s funcname=%(funcName)s %(message)s', 'datefmt': '%Y-%m-%d %H:%M:%S'}, 'simple': {'format': '%(levelname)s %(message)s'}}, 'handlers': {'null': {'level': 'DEBUG', 'class': 'logging.NullHandler'}, 'console': {'level': 'DEBUG', 'class': 'logging.StreamHandler', 'formatter': 'verbose'}}, 'loggers': {'testlogger': {'handlers': ['console'], 'level': 'INFO'}}}
269LOGGING_CONFIG = 'logging.config.dictConfig'
270LOGIN_REDIRECT_URL = 'index'
271LOGIN_URL = '/accounts/login/'
272LOGOUT_REDIRECT_URL = None
273MANAGERS = []
274MEDIA_ROOT = '/app/my_tech_start/media'
275MEDIA_URL = '/media/'
276MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
277MIDDLEWARE = "('whitenoise.middleware.WhiteNoiseMiddleware', 'django.middleware.security.SecurityMiddleware', 'whitenoise.middleware.WhiteNoiseMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.middleware.security.SecurityMiddleware')"
278MIGRATION_MODULES = {}
279MONTH_DAY_FORMAT = 'F j'
280NUMBER_GROUPING = 0
281PASSWORD_HASHERS = '********************'
282PASSWORD_RESET_TIMEOUT_DAYS = '********************'
283PAYTM_CALLBACK_URL = 'paytm/response/'
284PAYTM_MERCHANT_ID = 'zUPPzR66078013548661'
285PAYTM_MERCHANT_KEY = '********************'
286PAYTM_WEBSITE = 'WEBSTAGING'
287PREPEND_WWW = False
288PROJECT_ROOT = '/app/my_tech_start/my_tech_start'
289ROOT_URLCONF = 'my_tech_start.urls'
290SECRET_KEY = '********************'
291SECURE_BROWSER_XSS_FILTER = False
292SECURE_CONTENT_TYPE_NOSNIFF = False
293SECURE_HSTS_INCLUDE_SUBDOMAINS = False
294SECURE_HSTS_PRELOAD = False
295SECURE_HSTS_SECONDS = 0
296SECURE_PROXY_SSL_HEADER = None
297SECURE_REDIRECT_EXEMPT = []
298SECURE_SSL_HOST = None
299SECURE_SSL_REDIRECT = False
300SERVER_EMAIL = 'root@localhost'
301SESSION_CACHE_ALIAS = 'default'
302SESSION_COOKIE_AGE = 1209600
303SESSION_COOKIE_DOMAIN = None
304SESSION_COOKIE_HTTPONLY = True
305SESSION_COOKIE_NAME = 'sessionid'
306SESSION_COOKIE_PATH = '/'
307SESSION_COOKIE_SAMESITE = 'Lax'
308SESSION_COOKIE_SECURE = False
309SESSION_ENGINE = 'django.contrib.sessions.backends.db'
310SESSION_EXPIRE_AT_BROWSER_CLOSE = False
311SESSION_FILE_PATH = None
312SESSION_SAVE_EVERY_REQUEST = False
313SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
314SETTINGS_MODULE = 'my_tech_start.settings'
315SHORT_DATETIME_FORMAT = 'm/d/Y P'
316SHORT_DATE_FORMAT = 'm/d/Y'
317SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
318SILENCED_SYSTEM_CHECKS = []
319STATICFILES_DIRS = "('/app/my_tech_start/my_tech_start/../static',)"
320STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
321STATICFILES_STORAGE = 'whitenoise.storage.CompressedManifestStaticFilesStorage'
322STATIC_ROOT = '/app/my_tech_start/staticfiles'
323STATIC_URL = '/static/'
324TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/app/my_tech_start/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']}}]
325TEMPLATE_DIR = '/app/my_tech_start/templates'
326TEST_NON_SERIALIZED_APPS = []
327TEST_RUNNER = 'django.test.runner.DiscoverRunner'
328THOUSAND_SEPARATOR = ','
329TIME_FORMAT = 'P'
330TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
331TIME_ZONE = 'UTC'
332USE_I18N = True
333USE_L10N = True
334USE_THOUSAND_SEPARATOR = False
335USE_TZ = True
336USE_X_FORWARDED_HOST = False
337USE_X_FORWARDED_PORT = False
338WSGI_APPLICATION = 'my_tech_start.wsgi.application'
339X_FRAME_OPTIONS = 'SAMEORIGIN'
340YEAR_MONTH_FORMAT = 'F Y'
341
342
343You're seeing this error because you have DEBUG = True in your
344Django settings file. Change that to False, and Django will
345display a standard page generated by the handler for this status code.