Hi,
In web2py 1.72.3,
when I change db.py from:
db.define_table('report_segment' ,
Field
('acgh_sg_id',db.acgh_segment,ondelete='CASCADE'),
Field
('acgh_report_id',db.acgh_report,ondelete='CASCADE')
)
to:
db.define_table('report_segment' ,
Field('acgh_sg_id',db.acgh_segment,ondelete='SET
NULL'),
Field
('acgh_report_id',db.acgh_report,ondelete='CASCADE')
)
I get an error:
Traceback (most recent call last):
File "/home/maciek/workspace/imid2py/gluon/restricted.py", line 184,
in restricted
exec ccode in environment
File "/home/maciek/workspace/imid2py/applications/welcome/models/
db.py", line 285, in <module>
Field('acgh_report_id',db.acgh_report,ondelete='CASCADE')
File "/home/maciek/workspace/imid2py/gluon/sql.py", line 1205, in
define_table
query = t._create(migrate=migrate, fake_migrate=fake_migrate)
File "/home/maciek/workspace/imid2py/gluon/sql.py", line 1647, in
_create
fake_migrate=fake_migrate)
File "/home/maciek/workspace/imid2py/gluon/sql.py", line 1701, in
_migrate
self._db._execute(sub_query)
File "/home/maciek/workspace/imid2py/gluon/sql.py", line 879, in
<lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35,
in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1061, "Duplicate key name 'acgh_sg_id__idx'")
(what's interesting the error is reported in db.py in the line
following the actual change)
I observed similar errors when adding unique=True to a table
definition.
Any clues?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
