The database is new and completely empty. migrate = true is working because the auth tables are created automatically. I've used in the past Mysql, Postgresql, Firebird, DB/2 and this has never happened. It's as if the validator is not recognizing the existing table auth_user.
On Friday, February 17, 2017 at 2:16:24 PM UTC-7, Dave S wrote: > > > > 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.
