[web2py] FOREIGN KEY constraint failed

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: FOREIGN KEY constraint failed I have been able to create 2 forms but other attempts to create more forms fail!! These are my tables;

[web2py] Foreign key constraint failed

Good day, I was following the video tutorial of Massimo, just as other users here. But when I want to submit a post I get the error >IntegrityError: foreign key constraint failed< ---My db.py:--- db.define_table('category',

[web2py] FOREIGN KEY constraint failed error when "Click to delete" user account

Dear fellow w2p users, First, thank you so much for providing this great app Web2Py for *free*. Recently I updated my app to allow user to delete account themselves. auth.settings.allow_delete_accounts= True Today, I received feedback from user that that function is broken on my site. Then

[web2py] Foreign key constraint failed (and other woes) in table with two different table references.

Hi friends, first off, thanks to every contributor here - the web2py project is a godsend. So basically, I'm getting two different problems in two separate table insertions, which occurs in the controller. When I manually insert into the db (sqlite atm), I get an IntegrityError. - My

[web2py] foreign key constraint failed occurring custom table insertion, or foreign key is set to "None"

First off, I want to say thank you to the contributors of this group and of the codebase, web2py is a godsend! Now to my problem. Like the title implies, I'm getting two separate issues depending on how I set up my controller logic. This first one produces an IntegrityError. My controller:

[web2py] foreign key constraint failed

hello i have this table db.define_table('pedidos', Field('amostra',db.amostras), Field('destino'), Field('estante','integer'), Field('x','integer'), Field('y','integer'), Field('estante1',compute =lambda r:_E_+str(r['estante'])+str(r['x'])+str(r['y'])),

[web2py] Foreign Key Constraint Failed in dbadmin

Hi guys! Been looking for this in the mail list but i can't understand why this is happening. Here is the model. Very simple, just learning and practicing. Its a version with a few changes of the image blog :) db.define_table('uploads', Field('up_name','string',requires=IS_NOT_EMPTY()),

[web2py] foreign key constraint failed ???

I can't resolve this ticket in mhy app. I try to insert from appadmin but i've always this error: class 'sqlite3.IntegrityError' foreign key constraint failed This is my model: db.define_table('Nominativi', Field('nome',notnull=True, represent=lambda nome:nome.title()),