Your title field was unique in the past, so you changed it to non-unique
in model definition?
If so, the sad news is that SQLite does not support the ALTER TABLE
command for columns, it means once defined, the column attributes cant be
changed.
The only solution I know is to install an app called SQLiteManager then
right click and edit the table properties there, that program does that by
cloning in to a temporary table and do some renaming tricks to get it
working.
or, you can backup/dump your data in some json or csv, delete the
database and create it again, then populate the data back.
--
*Bruno Rocha - @rochacbruno*
http://github.com/rochacbruno
http://rochacbruno.com.br
http://pythonhub.com
On Thursday, September 12, 2013 4:50:17 AM UTC-3, Andreas Wienes wrote:
Hi,
I got a problem with one of my database tables. The field 'title' isn't
set to be unique. But inserting a row using filter_fields() ends with error
title is not unique.
db.define_table('task',
Field('title', unique=False),
Field('description', 'text', notnull=True),
format='%(title)s')
db.define_table('step',
Field('title'),
Field('description', 'text', notnull=True),
format='%(title)s')
db.task.insert(**db.task._filter_fields(step))
class 'sqlite3.IntegrityError' column title is not unique
Any help would be great!
- Andreas
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.