Because you used sqlite and your made the field "type" as
notnull=True. sqlite does not support ALTER TABLE DROP COLUMN so the
field is still there. I suggest you dump the dump the db, recerate it
and restore the dump or add the field again as invisible (not sure if
this will work, give it a try):
Field('type',default='',writable=False,readable=False)
On Mar 23, 6:16 am, Sven <[email protected]> wrote:
> Hi,
>
> I am new to web2py and really like it so far. I just ran into trouble
> though, and can't find the solution myself.
>
> The error message is:
> "IntegrityError: participant.type may not be NULL"
>
> as a result of calling:
> "db.participant.insert(unique_ref=ref, batch_type=session.batch_type,
> batch_name=session.batch_name)"
>
> I have defined a table 'participants' and 'type' used to be one of its
> fields. However, I changed the definition and the field is now called
> 'batch_type'. Since there is currently no 'participant.type' in my
> code, why does it show up in the error message?
>
> I hope someone has a suggestion.
>
> Thanks .
>
> Sven
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
