Referencing user results in syntax-error?

[Alec Taylor]

I checked the documentation to make sure, and either one of the commented out lines works, but I keep getting this:

<class 'sqlite3.OperationalError'> near ".": syntax error

It one (well both) of the commented out lines that give this error, because commenting them out makes the error go away.

db.define_table(
    'rsvp_list',
    Field('rsvp', notnull=True, requires=IS_IN_SET('Yes', 'Maybe', 'No')),
    Field('event_id', 'reference db.event', notnull=True, requires=IS_IN_DB(db, db.event, '%(event_name)s [%(id)%]')),
    #Field("person", db.auth_user, default=auth.user if auth.user else None)
    #Field('person', db.auth_user, notnull=True, default=auth.user_id)
)

How can I get this working?

Thanks for all suggestions,

Alec Taylor

[Massimo Di Pierro]

Person cannot be not null and default to auth.user_id which likely is null.

It also cannot defaul to auth.user.

Use the second line and remove notnull

[Alec Taylor]

Thanks, but that gave me the same error.

Full ticket: http://jsfiddle.net/FG4pC/show/light/ 

[Niphlod]

Massimo is right, but you're having the error for another reason.

it's plain and clear (Variables section). You are also lucky that in all of this statement there is only one dot.

('ALTER TABLE rsvp_list ADD event_id INTEGER REFERENCES db.event (id) ON DELETE CASCADE;',)

you have

Field('event_id', 'reference db.event'

that needs to be

Field('event_id', 'reference event'

[Alec Taylor]

Thanks, that did the trick.

--