As I continue to develop my old application from last summer I get
more and more problems that I think is related to the upgrading I did.
Now that i try to add a record to att table I get:
Traceback (most recent call last):
File "gluon/restricted.py", line 173, in restricted
exec ccode in environment
File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/
campaign.py", line 57, in <module>
File "gluon/globals.py", line 96, in <lambda>
self._caller = lambda f: f()
File "gluon/tools.py", line 1864, in f
return action(*a, **b)
File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/
campaign.py", line 47, in edit
if form.accepts(request.vars, session):
File "gluon/sqlhtml.py", line 975, in accepts
self.vars.id = self.table.insert(**fields)
File "gluon/sql.py", line 1891, in insert
self._db._execute(query)
File "gluon/sql.py", line 928, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 173, in
execute
self.errorhandler(self, exc, value)
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36,
in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1452, 'Cannot add or update a child row: a foreign
key constraint fails (`copy_kalenterit/campaign`, CONSTRAINT
`campaign_ibfk_3` FOREIGN KEY (`district`) REFERENCES `
To make sure the problem is with the upgrade I took the old
application and upgraded web2py. I get the same foreign key contraint
fails error.
Could the this error maybe related to this error:
http://groups.google.com/group/web2py/browse_thread/thread/b513b6cc917a026f
Both are database related. Old version is 1.65.4 which is working and
new is 1.76.5.
Any idea where to start looking for the problem or has something
changed in web2py which should be changed in my application too.
Kenneth
--
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.
