sqlite-Error with list:reference

13 views

Skip to first unread message

Jörg Schneider

unread,

Aug 12, 2016, 4:37:58 AM8/12/16

to web2py-users

I want to reference a project with a list of auth.users and get 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed:

(self=<pydal.adapters.sqlite.SQLiteAdapter object>, table=<Table project (id, name, project_member)>, fields=[(<pydal.objects.Field object>, 'Beratung'), (<pydal.objects.Field object>, ['4', '6'])])

db.define_table('project',

Field('name'),

Field('project_member','list:reference auth_user')

)

db.project.project_member.requires = IS_IN_DB(db, 'auth_user.id','%(first_name)s', db.auth_user._format, multiple=True)