Hi guys, i need help, i'm pulling my hairs out over here, i have a website where when i'm trying to record an entry i get an error: <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed
I have been able to create 2 forms but other attempts to create more forms fail!! These are my tables; db.define_table('government', Field('govName', requires=IS_NOT_EMPTY()), Field('tel', requires=IS_NOT_EMPTY()), Field('email', requires=IS_NOT_EMPTY()), format='%(govName)s', migrate=False,fake_migrate=True) db.define_table('governmenttForm', Field('formImage', 'upload'), Field('filledformImage', 'upload'), Field('formName',requires=IS_NOT_EMPTY()), Field('governmentName', 'reference government'), format='%(formName)s',migrate=False,fake_migrate=True) db.define_table('governmetFormPages', Field('formImage', 'upload'), Field('formTitle',requires=IS_NOT_EMPTY()), Field('formName', 'reference govmntForm'),migrate=False,fake_migrate=True) I am able to create a form for the governmentForm table but when i try to load up the pages for governmentFormPages table i get the error <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed Below is the stack Error ticket for "formulator" Ticket ID 127.0.0.1.2017-07-02.10-06-22.18c363e3-13c2-47f7-ace4-3692239493c4 <class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed Version web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. Traceback (most recent call last): File "/home/mostwanted/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/home/mostwanted/web2py/applications/formulator/controllers/appadmin.py" <http://127.0.0.1:8000/admin/default/edit/formulator/controllers/appadmin.py>, line 703, in <module> File "/home/mostwanted/web2py/gluon/globals.py", line 417, in <lambda> self._caller = lambda f: f() File "/home/mostwanted/web2py/applications/formulator/controllers/appadmin.py" <http://127.0.0.1:8000/admin/default/edit/formulator/controllers/appadmin.py>, line 151, in insert if form.accepts(request.vars, session): File "/home/mostwanted/web2py/gluon/sqlhtml.py", line 1746, in accepts self.vars.id = self.table.insert(**fields) File "/home/mostwanted/web2py/gluon/packages/dal/pydal/objects.py", line 726, in insert ret = self._db._adapter.insert(self, self._listify(fields)) File "/home/mostwanted/web2py/gluon/packages/dal/pydal/adapters/base.py", line 746, in insert raise e IntegrityError: FOREIGN KEY constraint failed Please help me, i dont know what to do, i have tried to look for solutions online but i just dont understand them, may someone please give me light on what i'm doing wrong. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.