if you change the database uri, you NEED to let web2py migration on, at
least for the very first request. Your "migrate_enabled=False" is making
web2py think a table is already created.
On Saturday, October 18, 2014 4:26:11 AM UTC+2, Tony Huang wrote:
>
> Recently, I start to research web2py.
> I type 'python web2py.py' to run web2py application, and create a new
> application name 'myapp'.
> The default database is SQLite, and I can sing up new user successful.
> However, it will crash when I change the database to postgresql.
> The error is: <type 'exceptions.Exception'> Validation error, field:email
> <gluon.validators.IS_NOT_IN_DB object at 0x00000000043BC208>
>
> I only modify the db.py model in myapp:
> #db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all'])
> db = DAL('postgres://postgres:[email protected]/mytestdb',
> pool_size=1,migrate_enabled=False)
>
> Anybody can tell me what's going on and how to fix it?
> Thanks!
>
--
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.
