[web2py] IntegrityError('FOREIGN KEY constraint failed',)

[mostwanted]

*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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.