Getting below error while inserting a records through form.
When i insert same values in mysql console it works.i have found that it
looks like FK constraint,but schema looks fine.
Can you please help on this,
Traceback (most recent call last):
File "/var/www/web2py/gluon/restricted.py", line 188, in restricted
exec ccode in environment
File "/var/www/web2py/applications/new/controllers/default.py", line 54,
in <module>
File "/var/www/web2py/gluon/globals.py", line 95, in <lambda>
self._caller = lambda f: f()
File "/var/www/web2py/applications/new/controllers/default.py", line 13,
in index
if form.accepts(request):
File "/var/www/web2py/gluon/sqlhtml.py", line 1159, in accepts
self.vars.id = self.table.insert(**fields)
File "/var/www/web2py/gluon/dal.py", line 3751, in insert
return self._db._adapter.insert(self,self._listify(fields))
File "/var/www/web2py/gluon/dal.py", line 701, in insert
raise e
IntegrityError: (1452, u'Cannot add or update a child row: a foreign key
constraint fails (`master`.`logistics`, CONSTRAINT `logistics_ibfk_1`
FOREIGN KEY (`vendor`) REFERENCES `name_config` (`company`))')
Thanks
sushanth