[web2py] Re: Beginner question: foreign key constraint failed (?)

2014-03-28 Thread Krzysztof Socha
Just an update. It appears to be an issue with SQLITE. The actual problem was related to the fact that I have redefined AUTH_USER table (by company table - not all of it quated in my post). I had a missing field used in the default NavBar - first_name. When I switched from SQLITE to MYSQL, the

[web2py] Re: Beginner question: foreign key constraint failed (?)

2014-03-28 Thread Krzysztof Socha
On Thursday, March 27, 2014 5:21:34 PM UTC+1, Niphlod wrote: > > did you try with a fresh database ? > > After some investigation, it seems that the problem is not related to what I wrote above (!) I tried to change the DB - to MySQL - and the error reported changed to something like 'attribute

[web2py] Re: Beginner question: foreign key constraint failed (?)

2014-03-27 Thread Niphlod
did you try with a fresh database ? On Thursday, March 27, 2014 3:18:07 PM UTC+1, Krzysztof Socha wrote: > > I created a simple table that uses another table as a list of possible > values for a field: > > db.define_table('country', > Field('name','string',length=DEFAULT_STRING_LENGTH)) > > db.de