IntegrityError at /admin/auth/user/add/ using sqlite

[pat1]

Using sqlite only adding user from django admin web interface

IntegrityError at /admin/auth/user/add/

UNIQUE constraint failed: stations_userprofile.user_id

Request Method: POST
Request URL: http://127.0.0.1:8000/admin/auth/user/add/
Django Version: 1.5.9
Exception Type: IntegrityError
Exception Value:

UNIQUE constraint failed: stations_userprofile.user_id

Exception Location: /usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 362
Python Executable: /usr/bin/python
Python Version: 2.7.5
Python Path:

['/home/pat1/svn/r-map-code/trunk/python',
'/usr/lib/python2.7/site-packages/pysimulavr-1.1dev-py2.7.egg',
'/usr/lib64/python27.zip',
'/usr/lib64/python2.7',
'/usr/lib64/python2.7/plat-linux2',
'/usr/lib64/python2.7/lib-tk',
'/usr/lib64/python2.7/lib-old',
'/usr/lib64/python2.7/lib-dynload',
'/usr/lib64/python2.7/site-packages',
'/usr/lib64/python2.7/site-packages/gst-0.10',
'/usr/lib64/python2.7/site-packages/gtk-2.0',
'/usr/lib64/python2.7/site-packages/wx-2.8-gtk2-unicode',
'/usr/lib/python2.7/site-packages',
'/usr/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info']

Server time: ven, 20 Feb 2015 11:10:04 +0100

Environment:

Request Method: POST
Request URL: http://127.0.0.1:8000/admin/auth/user/add/

Django Version: 1.5.9
Python Version: 2.7.5
Installed Applications:
('django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'registration',
'django.contrib.admin',
'django.contrib.staticfiles',
'rmap.stations',
'rmap.doc',
'django_extensions')
Installed Middleware:
('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')

Traceback:
File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
113. response = callback(request, callback_args, callback_kwargs)
File "/usr/lib/python2.7/site-packages/django/contrib/admin/options.py" in wrapper
390. return self.admin_site.admin_view(view)(_args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
91. response = view_func(request, args, kwargs)
File "/usr/lib/python2.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
89. response = view_func(request, *args, kwargs)
File "/usr/lib/python2.7/site-packages/django/contrib/admin/sites.py" in inner
202. return view(request, args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapper
25. return bound_func(_args, kwargs)
File "/usr/lib/python2.7/site-packages/django/views/decorators/debug.py" in sensitive_post_parameters_wrapper
75. return view(request, args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in bound_func
21. return func(self, _args2, kwargs2)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapper
25. return bound_func(args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
91. response = view_func(request, *args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in bound_func
21. return func(self, args2, kwargs2)
File "/usr/lib/python2.7/site-packages/django/db/transaction.py" in inner
223. return func(_args, kwargs)
File "/usr/lib/python2.7/site-packages/django/contrib/auth/admin.py" in add_view
122. extra_context)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapper
25. return bound_func(args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
91. response = view_func(request, _args, kwargs)
File "/usr/lib/python2.7/site-packages/django/utils/decorators.py" in bound_func
21. return func(self, args2, kwargs2)
File "/usr/lib/python2.7/site-packages/django/db/transaction.py" in inner
223. return func(_args, kwargs)
File "/usr/lib/python2.7/site-packages/django/contrib/admin/options.py" in add_view
1026. self.save_related(request, form, formsets, False)
File "/usr/lib/python2.7/site-packages/django/contrib/admin/options.py" in save_related
782. self.save_formset(request, form, formset, change=change)
File "/usr/lib/python2.7/site-packages/django/contrib/admin/options.py" in save_formset
770. formset.save()
File "/usr/lib/python2.7/site-packages/django/forms/models.py" in save
514. return self.save_existing_objects(commit) + self.save_new_objects(commit)
File "/usr/lib/python2.7/site-packages/django/forms/models.py" in save_new_objects
648. self.new_objects.append(self.save_new(form, commit=commit))
File "/usr/lib/python2.7/site-packages/django/forms/models.py" in save_new
754. obj.save()
File "/usr/lib/python2.7/site-packages/django/db/models/base.py" in save
546. force_update=force_update, update_fields=update_fields)
File "/usr/lib/python2.7/site-packages/django/db/models/base.py" in save_base
650. result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/usr/lib/python2.7/site-packages/django/db/models/manager.py" in _insert
215. return insert_query(self.model, objs, fields, *kwargs)
File "/usr/lib/python2.7/site-packages/django/db/models/query.py" in insert_query
1675. return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
943. cursor.execute(sql, params)
File "/usr/lib/python2.7/site-packages/django/db/backends/util.py" in execute
41. return self.cursor.execute(sql, params)
File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
364. six.reraise(utils.IntegrityError, utils.IntegrityError(tuple(e.args)), sys.exc_info()[2])
File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
362. return Database.Cursor.execute(self, query, params)

Exception Type: IntegrityError at /admin/auth/user/add/
Exception Value: UNIQUE constraint failed: stations_userprofile.user_id

[pat1]

verificare che il problema sia ancora presente / django 1.9

[pat1]

è ancora presente

[pat1]

solved in django 2