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