Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • beat.web beat.web
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 54
    • Issues 54
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • beatbeat
  • beat.webbeat.web
  • Issues
  • #463
Closed
Open
Issue created Apr 21, 2017 by Jaden DIEFENBAUGH@jdiefenbaughContributor

db IntegrityError when adding user from Django admin with non-default account settings

What

Going to the Django admin page for the Users model and creating a new user always fails if any combination of the four options under "Account Settings # 1" are unchecked.

Configs

  • local development (SQLite backend)
  • Clean ./bin/django install db on master branch

Traceback

Internal Server Error: /admin/auth/user/add/
Traceback (most recent call last):
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/core/handlers/base.py", line 149, in get_response
    response = self.process_exception_by_middleware(e, request)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/core/handlers/base.py", line 147, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/options.py", line 541, in wrapper
    return self.admin_site.admin_view(view)(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 149, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
    response = view_func(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/sites.py", line 244, in inner
    return view(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 67, in _wrapper
    return bound_func(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/views/decorators/debug.py", line 76, in sensitive_post_parameters_wrapper
    return view(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 63, in bound_func
    return func.__get__(self, type(self))(*args2, **kwargs2)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 67, in _wrapper
    return bound_func(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 149, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 63, in bound_func
    return func.__get__(self, type(self))(*args2, **kwargs2)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 184, in inner
    return func(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/auth/admin.py", line 128, in add_view
    extra_context)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/options.py", line 1437, in add_view
    return self.changeform_view(request, None, form_url, extra_context)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 67, in _wrapper
    return bound_func(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 149, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 63, in bound_func
    return func.__get__(self, type(self))(*args2, **kwargs2)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/utils/decorators.py", line 184, in inner
    return func(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/options.py", line 1379, in changeform_view
    self.save_related(request, form, formsets, not add)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/options.py", line 1015, in save_related
    self.save_formset(request, form, formset, change=change)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/contrib/admin/options.py", line 1003, in save_formset
    formset.save()
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/forms/models.py", line 645, in save
    return self.save_existing_objects(commit) + self.save_new_objects(commit)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/forms/models.py", line 775, in save_new_objects
    self.new_objects.append(self.save_new(form, commit=commit))
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/forms/models.py", line 913, in save_new
    obj.save()
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/base.py", line 708, in save
    force_update=force_update, update_fields=update_fields)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/base.py", line 736, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/base.py", line 820, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/base.py", line 859, in _do_insert
    using=using, raw=raw)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 122, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/query.py", line 1039, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1060, in execute_sql
    cursor.execute(sql, params)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/utils.py", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/home/blackcap/Code/beat.env.web/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 323, in execute
    return Database.Cursor.execute(self, query, params)
IntegrityError: UNIQUE constraint failed: accounts_accountsettings.owner_id
[21/Apr/2017 15:39:18] "POST /admin/auth/user/add/ HTTP/1.1" 500 255813

Django error page

IntegrityError_at_admin_auth_user_add_.htm

Assignee
Assign to
Time tracking