You are correct sir. The table has three "reference" fields and their default validators were the unforgiving type. Since this was a special case in which it was OK if the references were missing, I just nuked the validators before doing the "validate_and_insert" by setting the "requires=None" for the three reference fields.
-- Joe On Tuesday, May 9, 2017 at 7:34:15 AM UTC-7, Anthony wrote: > > id fields do not get any validators by default, and if they did, it > certainly would not be an IS_IN_DB validator (if anything, it would be > IS_NOT_IN_DB, as id values must be unique). Can we see your table > definition? > > Is it possible the problem is instead with a reference field, which by > default would have an IS_IN_DB validator and would therefore be required > for an insert? > > Anthony > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.