· 10 years ago · Aug 29, 2015, 10:11 PM
1IntegrityError at /users/me/
2null value in column "is_terms_confirmed" violates not-null constraint
3DETAIL: Failing row contains (1690, pbkdf2_sha256$15000$I4dN65aI45pV$T8nlCmQZS3/j51T/mFaZLsBWVRUgB4o..., 2015-08-26 16:34:17.410652+00, t, Pavel, Ivanov, grammka@gmail.com, t, t, 2015-08-25 20:22:35+00, , upload/15785865185_bd0e18427c_h_gdr4ss8.jpg, null, null, null, 1, 0, , t, , , f, 1, t, f, 64156, 696, , , null, null, null, A, f, Photographer, 2015-08-28 21:33:37.385542+00, enUS, pub, , Europe/Moscow, null).
4
5
6Request Method: PATCH
7Request URL: http://api.justinvarilek.com/users/me/
8Django Version: 1.7.8
9Python Executable: /w/dev/backend/env/bin/uwsgi
10Python Version: 2.7.6
11Python Path: ['.', '', '/w/dev/backend/env/lib/python2.7', '/w/dev/backend/env/lib/python2.7/plat-x86_64-linux-gnu', '/w/dev/backend/env/lib/python2.7/lib-tk', '/w/dev/backend/env/lib/python2.7/lib-old', '/w/dev/backend/env/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/w/dev/backend/env/local/lib/python2.7/site-packages', '/w/dev/backend/website']
12Server time: Сбт, 29 Ðвг 2015 22:12:04 +0000
13Installed Applications:
14('modeltranslation',
15 'grappelli',
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 'django.contrib.sites',
23 'django.contrib.gis',
24 'django_ses',
25 'djcelery',
26 'rest_framework',
27 'rest_framework_swagger',
28 'corsheaders',
29 'social_auth',
30 'haystack',
31 'sorl.thumbnail',
32 'cities_light',
33 'loginas',
34 'authorization',
35 'profiles',
36 'boards',
37 'chat',
38 'options',
39 'feedback',
40 'snapfeed',
41 'ideafeed',
42 'companies',
43 'statistic',
44 'raven.contrib.django.raven_compat')
45Installed Middleware:
46('django.contrib.sessions.middleware.SessionMiddleware',
47 'profiles.middleware.DisableCSRF',
48 'corsheaders.middleware.CorsMiddleware',
49 'django.middleware.common.CommonMiddleware',
50 'django.middleware.locale.LocaleMiddleware',
51 'django.contrib.auth.middleware.AuthenticationMiddleware',
52 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
53 'django.contrib.messages.middleware.MessageMiddleware',
54 'django.middleware.clickjacking.XFrameOptionsMiddleware',
55 'profiles.middleware.TimezoneCookieMiddleware',
56 'profiles.middleware.LanguageMiddleware',
57 'statistic.middleware.VisitorLogMiddleware')
58
59Traceback:
60File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
61 111. response = wrapped_callback(request, *callback_args, **callback_kwargs)
62File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
63 57. return view_func(*args, **kwargs)
64File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/views/generic/base.py" in view
65 69. return self.dispatch(request, *args, **kwargs)
66File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
67 452. response = self.handle_exception(exc)
68File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
69 449. response = handler(request, *args, **kwargs)
70File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/generics.py" in patch
71 260. return self.partial_update(request, *args, **kwargs)
72File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/mixins.py" in partial_update
73 77. return self.update(request, *args, **kwargs)
74File "./profiles/views.py" in update
75 381. self.perform_update(serializer)
76File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/mixins.py" in perform_update
77 73. serializer.save()
78File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/serializers.py" in save
79 160. self.instance = self.update(self.instance, validated_data)
80File "./profiles/serializers.py" in update
81 678. instance = super(OwnProfileSerializer, self).update(instance, validated_data)
82File "/w/dev/backend/env/local/lib/python2.7/site-packages/rest_framework/serializers.py" in update
83 805. instance.save()
84File "./profiles/models.py" in save
85 259. return super(Profile, self).save(*args, **kwargs)
86File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py" in save
87 589. force_update=force_update, update_fields=update_fields)
88File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py" in save_base
89 617. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
90File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py" in _save_table
91 679. forced_update)
92File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py" in _do_update
93 723. return filtered._update(values) > 0
94File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/query.py" in _update
95 600. return query.get_compiler(self.db).execute_sql(CURSOR)
96File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
97 1005. cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
98File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
99 787. cursor.execute(sql, params)
100File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
101 81. return super(CursorDebugWrapper, self).execute(sql, params)
102File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
103 65. return self.cursor.execute(sql, params)
104File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/utils.py" in __exit__
105 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
106File "/w/dev/backend/env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
107 65. return self.cursor.execute(sql, params)
108
109Exception Type: IntegrityError at /users/me/
110Exception Value: null value in column "is_terms_confirmed" violates not-null constraint
111DETAIL: Failing row contains (1690, pbkdf2_sha256$15000$I4dN65aI45pV$T8nlCmQZS3/j51T/mFaZLsBWVRUgB4o..., 2015-08-26 16:34:17.410652+00, t, Pavel, Ivanov, grammka@gmail.com, t, t, 2015-08-25 20:22:35+00, , upload/15785865185_bd0e18427c_h_gdr4ss8.jpg, null, null, null, 1, 0, , t, , , f, 1, t, f, 64156, 696, , , null, null, null, A, f, Photographer, 2015-08-28 21:33:37.385542+00, enUS, pub, , Europe/Moscow, null).
112
113Request information:
114GET: No GET data
115
116POST: No POST data
117
118FILES: No FILES data
119
120COOKIES:
121csrftoken = 'MZxhjBm3BcGdaRINd8CHnyPp3FvanpbZ'
122_language = 'ru'
123mp_4492e7f256e0a2dbe4e6bddcc50e200a_mixpanel = '%7B%22distinct_id%22%3A%201690%2C%22%24initial_referrer%22%3A%20%22%24direct%22%2C%22%24initial_referring_domain%22%3A%20%22%24direct%22%2C%22__mps%22%3A%20%7B%7D%2C%22__mpso%22%3A%20%7B%7D%2C%22__mpa%22%3A%20%7B%7D%2C%22__mpu%22%3A%20%7B%7D%2C%22__mpap%22%3A%20%5B%5D%7D'
124sessionid = 'u2zylt9iimrvt9jdp6op5ajd623gk4kr'
125timezone = 'Europe/Moscow'
126
127META:
128wsgi.multiprocess = False
129HTTP_REFERER = 'http://localhost:5007/settings'
130SCRIPT_NAME = u''
131REQUEST_METHOD = 'PATCH'
132PATH_INFO = u'/users/me/'
133HTTP_ORIGIN = 'http://localhost:5007'
134SERVER_PROTOCOL = 'HTTP/1.1'
135QUERY_STRING = ''
136CONTENT_LENGTH = '29'
137HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.130 Safari/537.36'
138HTTP_CONNECTION = 'keep-alive'
139HTTP_COOKIE = 'csrftoken=MZxhjBm3BcGdaRINd8CHnyPp3FvanpbZ; mp_4492e7f256e0a2dbe4e6bddcc50e200a_mixpanel=%7B%22distinct_id%22%3A%201690%2C%22%24initial_referrer%22%3A%20%22%24direct%22%2C%22%24initial_referring_domain%22%3A%20%22%24direct%22%2C%22__mps%22%3A%20%7B%7D%2C%22__mpso%22%3A%20%7B%7D%2C%22__mpa%22%3A%20%7B%7D%2C%22__mpu%22%3A%20%7B%7D%2C%22__mpap%22%3A%20%5B%5D%7D; _language=ru; timezone="Europe/Moscow"; sessionid=u2zylt9iimrvt9jdp6op5ajd623gk4kr'
140SERVER_NAME = 'api.justinvarilek.com'
141REMOTE_ADDR = '178.140.41.196'
142wsgi.url_scheme = 'http'
143SERVER_PORT = '80'
144uwsgi.node = 'hackpack'
145DOCUMENT_ROOT = '/usr/share/nginx/html'
146HTTP_PRAGMA = 'no-cache'
147HTTP_CONTENT_LENGTH = '29'
148HTTP_X_REQUESTED_WITH = 'XMLHttpRequest'
149wsgi.input = <uwsgi._Input object at 0x7f05f956a048>
150HTTP_HOST = 'api.justinvarilek.com'
151wsgi.multithread = False
152HTTP_CACHE_CONTROL = 'no-cache'
153HTTP_CONTENT_TYPE = 'application/json;charset=UTF-8'
154REQUEST_URI = '/users/me/'
155HTTP_ACCEPT = 'application/json, text/plain, */*'
156wsgi.version =
157wsgi.run_once = False
158wsgi.errors = <open file 'wsgi_errors', mode 'w' at 0x7f05f9faf300>
159REMOTE_PORT = '55189'
160HTTP_ACCEPT_LANGUAGE = 'ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4,bg;q=0.2,nb;q=0.2'
161uwsgi.version = '2.0.10'
162CONTENT_TYPE = 'application/json;charset=UTF-8'
163wsgi.file_wrapper = ''
164CSRF_COOKIE = u'MZxhjBm3BcGdaRINd8CHnyPp3FvanpbZ'
165HTTP_ACCEPT_ENCODING = 'gzip, deflate, sdch'
166
167Settings:
168Using settings module project.settings
169USE_L10N = True
170USE_THOUSAND_SEPARATOR = False
171CSRF_COOKIE_SECURE = False
172CELERY_DEFAULT_QUEUE = 'dev_hackpack'
173LANGUAGE_CODE = 'en-us'
174ROOT_URLCONF = 'project.urls'
175CELERYD_TASK_TIME_LIMIT = 1800
176CITIES_LIGHT_TRANSLATION_LANGUAGES = ['en', 'ru']
177BROKER_URL = 'amqp://guest:guest@localhost:5672/dev'
178BASE_DIR = '/w/dev/backend/website'
179TEST_NON_SERIALIZED_APPS = []
180DEFAULT_CHARSET = 'utf-8'
181SESSION_SERIALIZER = 'django.contrib.sessions.serializers.PickleSerializer'
182STATIC_ROOT = '/w/dev/backend/media/static'
183CELERYBEAT_SCHEDULER = 'djcelery.schedulers.DatabaseScheduler'
184SOCIAL_AUTH_MODELS_MODULE = 'authorization.models'
185ALLOWED_HOSTS = ['*']
186MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
187EMAIL_SUBJECT_PREFIX = '[Django] '
188SEND_BROKEN_LINK_EMAILS = False
189STATICFILES_FINDERS =
190CONN_MAX_AGE = None
191SESSION_COOKIE_DOMAIN = None
192SESSION_COOKIE_NAME = 'sessionid'
193REGISTRATION_EVENT_CODE = 'BieNVeNiDa'
194ADMIN_FOR =
195TIME_INPUT_FORMATS =
196DATABASES = {'default': {'ENGINE': 'django.contrib.gis.db.backends.postgis', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': 'dev_hackpack', 'CONN_MAX_AGE': 0, 'TIME_ZONE': 'UTC', 'PORT': '5432', 'HOST': 'localhost', 'USER': 'hackpack', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'********************', 'OPTIONS': {}}}
197FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
198FILE_UPLOAD_PERMISSIONS = None
199FILE_UPLOAD_HANDLERS =
200TEMPLATE_CONTEXT_PROCESSORS =
201DEFAULT_CONTENT_TYPE = 'text/html'
202ROOT = '/w/dev/backend'
203WEBSOCKET_URL = '/websocket'
204APPEND_SLASH = True
205FIRST_DAY_OF_WEEK = 0
206DATABASE_ROUTERS = []
207DEFAULT_TABLESPACE = ''
208YEAR_MONTH_FORMAT = 'F Y'
209STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
210CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
211USER_MODEL = 'profiles.models.Profile'
212SERVER_EMAIL = 'root@localhost'
213SESSION_COOKIE_PATH = '/'
214UNICODE_JSON = True
215SILENCED_SYSTEM_CHECKS = []
216MIDDLEWARE_CLASSES =
217USE_I18N = True
218THOUSAND_SEPARATOR = ','
219SECRET_KEY = u'********************'
220LANGUAGE_COOKIE_NAME = 'django_language'
221FILE_UPLOAD_TEMP_DIR = None
222CELERYD_CONCURRENCY = 50
223TRANSACTIONS_MANAGED = False
224LOGGING_CONFIG = 'logging.config.dictConfig'
225TEMPLATE_LOADERS =
226WSGI_APPLICATION = 'project.wsgi.application'
227TEMPLATE_DEBUG = True
228X_FRAME_OPTIONS = 'SAMEORIGIN'
229CSRF_COOKIE_NAME = 'csrftoken'
230HAYSTACK_CONNECTIONS = {'default': {'ENGINE': 'options.custom_elasticsearch.ConfigurableElasticSearchEngine', 'URL': 'http://127.0.0.1:9200/', 'INDEX_NAME': 'dev', 'INCLUDE_SPELLING': True}}
231FORCE_SCRIPT_NAME = None
232USE_X_FORWARDED_HOST = False
233CORS_ALLOW_CREDENTIALS = True
234AWS_SES_REGION_NAME = 'eu-west-1'
235SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
236SESSION_COOKIE_SECURE = False
237CSRF_COOKIE_DOMAIN = None
238FILE_CHARSET = 'utf-8'
239DEBUG = True
240LANGUAGE_COOKIE_DOMAIN = None
241AWS_ACCESS_KEY_ID = u'********************'
242DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
243INSTALLED_APPS =
244LANGUAGES_BIDI =
245COMMENTS_ALLOW_PROFANITIES = False
246STATICFILES_DIRS = '/w/dev/backend/website/static'
247PREPEND_WWW = False
248SECURE_PROXY_SSL_HEADER = None
249API_PREFIX = u'********************'
250LANGUAGE_COOKIE_AGE = None
251SESSION_COOKIE_HTTPONLY = True
252AWS_SECRET_ACCESS_KEY = u'********************'
253FACEBOOK_APP_ID = '676641815779298'
254DEBUG_PROPAGATE_EXCEPTIONS = False
255CSRF_COOKIE_AGE = 31449600
256MONTH_DAY_FORMAT = 'F j'
257LOGIN_URL = '/admin/login'
258SESSION_EXPIRE_AT_BROWSER_CLOSE = False
259CITIES_LIGHT_APP_NAME = 'options'
260CELERYD_TASK_SOFT_TIME_LIMIT = 1200
261TIME_FORMAT = 'P'
262AUTH_USER_MODEL = 'profiles.Profile'
263DATE_INPUT_FORMATS =
264AUTHENTICATION_BACKENDS =
265EMAIL_HOST_PASSWORD = u'********************'
266AWS_SES_REGION_ENDPOINT = 'email.eu-west-1.amazonaws.com'
267PASSWORD_RESET_TIMEOUT_DAYS = u'********************'
268SESSION_FILE_PATH = None
269CACHE_MIDDLEWARE_ALIAS = 'default'
270SESSION_SAVE_EVERY_REQUEST = False
271NUMBER_GROUPING = 0
272TWITTER_CONSUMER_SECRET = u'********************'
273SESSION_ENGINE = 'django.contrib.sessions.backends.db'
274CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
275CSRF_COOKIE_PATH = '/'
276LOGIN_REDIRECT_URL = '/auth/done/'
277SOCIAL_AUTH_PIPELINE =
278RAVEN_CONFIG = {'register_signals': True}
279DECIMAL_SEPARATOR = '.'
280IGNORABLE_404_URLS =
281LOCALE_PATHS = '/w/dev/backend/website/templates/locale'
282TEMPLATE_STRING_IF_INVALID = ''
283LOGOUT_URL = '/accounts/logout/'
284EMAIL_USE_TLS = False
285ADMIN_MAILING_LIST =
286FIXTURE_DIRS =
287EMAIL_HOST = 'smtp.yandex.ru'
288DATE_FORMAT = 'N j, Y'
289FACEBOOK_API_SECRET = u'********************'
290MEDIA_ROOT = '/w/dev/backend/media'
291DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
292ADMINS = ('Alexander', '4eckbox@gmail.com')
293FORMAT_MODULE_PATH = None
294DEFAULT_FROM_EMAIL = 'webmaster@localhost'
295REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.BasicAuthentication', 'rest_framework.authentication.SessionAuthentication'), 'DATE_INPUT_FORMATS': ('%d.%m.%Y', 'iso-8601'), 'DEFAULT_FILTER_BACKENDS': ('rest_framework.filters.DjangoFilterBackend',), 'EXCEPTION_HANDLER': 'authorization.exceptions.exception_handler'}
296MEDIA_URL = '/media/'
297DATETIME_FORMAT = 'N j, Y, P'
298TEMPLATE_DIRS = '/w/dev/backend/website/templates'
299TWITTER_CONSUMER_KEY = u'********************'
300SOCIAL_AUTH_LOGIN_REDIRECT_URL = ''
301SITE_ID = 1
302DISALLOWED_USER_AGENTS =
303ALLOWED_INCLUDE_ROOTS =
304WEBSOCKET_PORT = None
305CELERY_TIMEZONE = 'UTC'
306LOGGING = {'loggers': {'SocialAuth': {'handlers': ['file'], 'propagate': True, 'level': 'DEBUG'}}, 'version': 1, 'disable_existing_loggers': False, 'handlers': {'file': {'level': 'DEBUG', 'class': 'logging.FileHandler', 'filename': '/w/dev/backend/logs/social_auth.log'}}}
307SHORT_DATE_FORMAT = 'm/d/Y'
308CELERY_DONT_SEND_EMAILS = False
309TEST_RUNNER = 'django.test.runner.DiscoverRunner'
310CACHE_MIDDLEWARE_KEY_PREFIX = u'********************'
311TIME_ZONE = 'UTC'
312CORS_ORIGIN_ALLOW_ALL = True
313FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
314MANAGERS =
315SESSION_CACHE_ALIAS = 'default'
316EMAIL_BACKEND = 'django_ses.SESBackend'
317NO_REPLY_EMAIL = 'noreply@hackpack.press'
318EMAIL_USE_SSL = True
319MODELTRANSLATION_AUTO_POPULATE = True
320MIGRATION_MODULES = {}
321SESSION_COOKIE_AGE = 1209600
322SETTINGS_MODULE = 'project.settings'
323USE_ETAGS = False
324LANGUAGES =
325HAYSTACK_SIGNAL_PROCESSOR = 'haystack.signals.RealtimeSignalProcessor'
326SOCIAL_AUTH_PROTECTED_USER_FIELDS = ['email']
327DEFAULT_INDEX_TABLESPACE = ''
328INTERNAL_IPS =
329STATIC_URL = '/static/'
330EMAIL_PORT = 465
331USE_TZ = True
332SHORT_DATETIME_FORMAT = 'm/d/Y P'
333CELERY_RESULT_BACKEND = 'djcelery.backends.database:DatabaseBackend'
334PASSWORD_HASHERS = u'********************'
335ABSOLUTE_URL_OVERRIDES = {}
336LANGUAGE_COOKIE_PATH = '/'
337CELERYBEAT_SCHEDULE = {'notify_snapfeed': {'task': 'snapfeed.tasks.notify_users', 'schedule': <crontab: 0 * * * * (m/h/d/dM/MY)>}}
338CACHE_MIDDLEWARE_SECONDS = 600
339CSRF_COOKIE_HTTPONLY = False
340DATETIME_INPUT_FORMATS =
341EMAIL_HOST_USER = 'noreply@hackpack.press'
342PROFANITIES_LIST = u'********************'
343
344You're seeing this error because you have DEBUG = True in your
345Django settings file. Change that to False, and Django will
346display a standard 500 page.