On Friday, February 17, 2017 at 12:36:01 PM UTC-8, Raul Monares wrote: > > I'm trying to use SQL Express for a project. When I try to sign up using > the demo app, I get this error > Validation error, field:email <gluon.validators.IS_NOT_IN_DB object at > 0x00000000049114E0> > All auth tables are created in the database. I tried migrate = false, > migrate = true. Same result. > > The connection string is mssql4://tarkus:rushrush@localhost/DNC_TRAINING. > I'm using IIS7, SQL Server Express 13.0.4001.0, db_codec = > 'SQL_Latin1_General_CP1_CI_AS' >
Validation errors don't usually involve the connection string. In this case, you either have an existing entry with the same email field as you're trying to use, or perhaps you haven't supplied a value for this field and the validator is considering the NULL to match a NULL entry (not all the validators would do that, though). Is this a demo database, or a database you've created? Can you use a non-web2py tool to connect to the database and examine what's in the fields? Such as a console app or a portal site? Dave /dps -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
