On 08/02/13 14:08, Andre Terra wrote:
Please post traceback, settings.py, etc.
On Fri, Feb 8, 2013 at 5:18 AM, Some Developer
<someukdevelo...@gmail.com <mailto:someukdevelo...@gmail.com>> wrote:
I have a model for a Tag object with simply has two fields. A title
(which has the unique constraint) and a description. I also have a
FormView based view class which handles the creation of Tag objects.
When I try and save the object in the form_valid() method I always
get an IntegrityError stating that the title column is not unique.
This is somewhat puzzling as I have deleted the SQLite database file
and recreated it using syncdb / migrate so it is completely empty.
I'm completely baffled by this error.
I've been using Django for years and have never had this problem before.
Hopefully someone will be able to shed some light on it as it is rather
annoying.
The only thing I am doing now that I haven't done in the past is using
class based views.
Settings:
The settings are just the default pretty much. The database section is
below though.
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(DIRNAME, 'data/data.db'),
'USER': '',
'PASSWORD': '',
'HOST': '',
'PORT': '',
}
}
Traceback:
Environment:
Request Method: POST
Request URL: http://localhost:8000/blog/tag/create/
Django Version: 1.4.3
Python Version: 2.7.3
Installed Applications:
('django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles',
'debug_toolbar',
'debug_toolbar_htmltidy',
'inspector_panel',
'debug_toolbar_user_panel',
'compressor',
'registration',
'djcelery',
'south',
'blog',
'controlpanel',
'docs',
'legal',
'support',
'bugs',
'general')
Installed Middleware:
('django.middleware.locale.LocaleMiddleware',
'django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'django.middleware.gzip.GZipMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
'django.middleware.transaction.TransactionMiddleware')
Traceback:
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/core/handlers/base.py"
in get_response
111. response = callback(request,
*callback_args, **callback_kwargs)
File
"/home/somedeveloper/Documents/Development/Python/djangostormcloud/djangostormcloud/decorators/superuser.py"
in decorator
17. return f(request, *args, **kwargs)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/views/generic/base.py"
in view
48. return self.dispatch(request, *args, **kwargs)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/views/generic/base.py"
in dispatch
69. return handler(request, *args, **kwargs)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/views/generic/edit.py"
in post
138. return self.form_valid(form)
File
"/home/somedeveloper/Documents/Development/Python/djangostormcloud/blog/views.py"
in form_valid
134. tag.save()
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/models/base.py"
in save
463. self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/models/base.py"
in save_base
551. result = manager._insert([self], fields=fields,
return_id=update_pk, using=using, raw=raw)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/models/manager.py"
in _insert
203. return insert_query(self.model, objs, fields, **kwargs)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/models/query.py"
in insert_query
1593. return query.get_compiler(using=using).execute_sql(return_id)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/models/sql/compiler.py"
in execute_sql
912. cursor.execute(sql, params)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/backends/util.py"
in execute
40. return self.cursor.execute(sql, params)
File
"/home/somedeveloper/Documents/Development/PythonEnvironments/dsc-env/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py"
in execute
344. return Database.Cursor.execute(self, query, params)
Exception Type: IntegrityError at /blog/tag/create/
Exception Value: column title is not unique
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
