I was able o solve the problem, when i was creating the tables i copied and
pasted a code for the '*governmetFormPages' *table but to correct the error
i had to delete the table and type its code word for word, that solved my
problem. thanks for the input guys. Santiago Cartasegna was right.
On Sunday, July 2, 2017 at 10:37:22 AM UTC+2, mostwanted wrote:
>
> 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.
