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

Reply via email to