*WHEN I TRY ENTERING A STUDENT'S DETAILS AND SELECTING THEIR GUARDIAN AS
FROM THE DROP DOWN MENU AS REFERNCED I GET A FOREIGN CONSTRAINT FAILED
ERROR MESSAGEMY TABLES*
db.define_table('guardian',
Field('surname', requires=IS_NOT_EMPTY()),
Field('name', requires=IS_NOT_EMPTY()),
Field('contact_number'),
format='%(surname)s')
db.define_table('student',
Field('surname', requires=IS_NOT_EMPTY()),
Field('name', requires=IS_NOT_EMPTY()),
Field('photo', 'upload', requires=IS_NOT_EMPTY()),
Field('guardian', 'reference guardian'),
Field('class_name', 'reference student_class'),
Field('dob', 'date', requires=IS_NOT_EMPTY()),
format='%(surname)s')
*MY CONTROLLER*
def show_students():
show_students=db(db.student).select(db.student.ALL)
return locals()
*MY VIEW*<div id="container">
<h2>SELECT A STUDENT TO VIEW THEIR PROFILE</h2>
<table>
<tr>
<th>SURNAME</th>
<th>NAME</th>
<th>CLASS</th>
<th>GUARDIAN</th>
</tr>
{{for students in show_students:}}
<tr>
<td>{{=A('VIEW', _class="glyphicon glyphicon-user",
_href=URL('student_profile', args=students.id))}} |
{{=students.surname}}</td>
<td>{{=students.name}}</td>
<td>{{=students.class_name.class_name}}</td>
<td>{{=students.guardian.guardian}}</td>
</tr>
{{pass}}
</table>
</div>
*MY TRACEBACK ERROR*
<class 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed
Traceback (most recent call last):
File "/home/mostwanted/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
File "/home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/SRMS/controllers/appadmin.py>, line
696, in <module>
File "/home/mostwanted/web2py/gluon/globals.py", line 409, in <lambda>
self._caller = lambda f: f()
File "/home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/SRMS/controllers/appadmin.py>, line
147, in insert
if form.accepts(request.vars, session):
File "/home/mostwanted/web2py/gluon/sqlhtml.py", line 1862, in accepts
self.vars.id = self.table.insert(**fields)
File "/home/mostwanted/web2py/gluon/packages/dal/pydal/objects.py", line 734,
in insert
ret = self._db._adapter.insert(self, row.op_values())
File "/home/mostwanted/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 486, in insert
raise e
IntegrityError: FOREIGN KEY constraint failed
Error snapshot [image: help]
<http://127.0.0.1:8000/admin/default/ticket/SRMS/127.0.0.1.2017-10-25.09-37-00.f00cf3b9-52ee-46d9-867a-5dae7b823f93#>
<class 'sqlite3.IntegrityError'>(FOREIGN KEY constraint failed)
inspect attributes
Frames
-
*File /home/mostwanted/web2py/gluon/restricted.py in restricted at line
219* code arguments variables
-
*File /home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py
in <module> at line 696* code arguments variables
-
*File /home/mostwanted/web2py/gluon/globals.py in <lambda> at line 409*
code arguments variables
-
*File /home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py
in insert at line 147* code arguments variables
-
*File /home/mostwanted/web2py/gluon/sqlhtml.py in accepts at line 1862*
code arguments variables
-
*File /home/mostwanted/web2py/gluon/packages/dal/pydal/objects.py in
insert at line 734* code arguments variables
-
*File /home/mostwanted/web2py/gluon/packages/dal/pydal/adapters/base.py
in insert at line 486* code arguments variables
Function argument list
(self=<pydal.adapters.sqlite.SQLite object>, table=<Table student (id,
surname, name, photo, guardian, class_name, dob)>,
fields=[(<pydal.objects.Field object>, 'Leburu'), (<pydal.objects.Field
object>, 'Percy'), (<pydal.objects.Field object>, '2010-10-05'),
(<pydal.objects.Field object>, 5), (<pydal.objects.Field object>, 21),
(<pydal.objects.Field object>,
'student.photo.a21f46af61cba907.706963322e6a7067.jpg')])
Code listing
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
self.execute(query)
except:
e = sys.exc_info()[1]
if hasattr(table, '_on_insert_error'):
return table._on_insert_error(table, fields, e)
raise e
if hasattr(table, '_primarykey'):
pkdict = dict([
(k[0].name, k[1]) for k in fields
if k[0].name in table._primarykey])
Variables
e IntegrityError('FOREIGN KEY constraint failed',)
Context
locals request session response
In file: /home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py
1.
<code object <module> at 0xb6e606e0, file
"/home/mostwanted/web2py/applications/SRMS/controllers/appadmin.py", line 7>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
