Hola tengo un problema, cada vez que introduzco los registros en el
formulario de la tabla proyecto sale el error class
'sqlite3.integrityerror' foreign key constraint failed
no se que hacer... por favor agradecería su ayuda
este es el modelo:
db.define_table("ente",
Field("ente", "string", default=None))
db.define_table("modelo",
Field("nommodelo", "string", default=None),
Field("etapac", "string", default=None))
db.define_table("proyecto",
Field("codigop", "integer", default=None),
Field("ente", 'reference ente'),
Field("nommodelo", 'reference modelo'),
Field("nombrep", "string", default=None),
Field("tipo", "string", default=None),
Field("estatus", "string", default=None),
Field("fechai", "date", default=None),
Field("fechaf", "date", default=None),
Field("meta", "integer", default=None),
Field("nomrep", "string", default=None),
Field("aperep", "string", default=None),
Field("telefono", default=None),
Field("email", "string", default=None),
Field("estado", "string", default=None),
Field("municipio", "string", default=None),
Field("parroquia", "string", default=None))
""" Relations between tables (remove fields you don't need from
requires) """
db.proyecto.ente.requires=IS_IN_DB( db, 'ente.id', ' %(ente)s')
db.proyecto.nommodelo.requires=IS_IN_DB( db, 'modelo.id', '
%(nommodelo)s')
*Error ticket for "PROGRAMA"*
*Ticket ID*
127.0.0.1.2015-04-27.12-55-08.a4f7ea63-a2dc-40ca-9885-d63027a5b13e
*<class 'sqlite3.IntegrityError'> foreign key constraint failed*
*Versión*
*web2py™*
Version 2.9.12-stable+timestamp.2015.02.15.23.04.25
*Python*
Python 2.7.9: C:\Users\RUTMARYS\Documents\mi pasantia\web2py\web2py.exe
(prefix: C:\Python27)
*Rastreo*
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
Traceback *(*most recent call last
*): *File "C:\Users\RUTMARYS\Documents\mi
pasantia\web2py\gluon\restricted.py"*, *line 224*, **in *restricted
*exec *ccode *in *environment
File "C:/Users/RUTMARYS/Documents/mi
pasantia/web2py/applications/PROGRAMA/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/PROGRAMA/controllers/appadmin.py>*,
*line 654*, **in **<*module
*> *File "C:\Users\RUTMARYS\Documents\mi pasantia\web2py\gluon\globals.py"*,
*line 393*, **in **<**lambda*
*> **self**.*_caller *= **lambda *f*: *f
*() *File "C:/Users/RUTMARYS/Documents/mi
pasantia/web2py/applications/PROGRAMA/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/PROGRAMA/controllers/appadmin.py>*,
*line 152*, **in *insert
*if *form*.*accepts*(*request*.*vars*, *session
*): *File "C:\Users\RUTMARYS\Documents\mi
pasantia\web2py\gluon\sqlhtml.py"*, *line 1677*, **in *accepts
*self**.*vars*.*id *= **self**.*table*.*insert*(***fields
*) *File "C:\Users\RUTMARYS\Documents\mi
pasantia\web2py\gluon\packages\dal\pydal\objects.py"*, *line 737*, **in *
insert
ret *= **self**.*_db*.*_adapter*.*insert*(**self**, **self**.*_listify
*(*fields
*)) *File "C:\Users\RUTMARYS\Documents\mi
pasantia\web2py\gluon\packages\dal\pydal\adapters\base.py"*, *line 719*, **in
*insert
*raise *e
IntegrityError*: *foreign key constraint failed
*Error snapshot* *[image: help]*
<http://127.0.0.1:8000/admin/default/ticket/PROGRAMA/127.0.0.1.2015-04-27.12-55-08.a4f7ea63-a2dc-40ca-9885-d63027a5b13e>
<class 'sqlite3.IntegrityError'>(foreign key constraint failed)
--
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.
