Can we see the controller? the problem is probably related to using string widget for a reference field.
On Thursday, 4 February 2016 11:26:54 UTC-6, Pierre wrote: > > hi everyone > > this doesn't work > > db.define_table('person', > Field('name', unique=True, requires=IS_NOT_IN_DB(db,' > person.name')), > Field('country'), > Field('age','integer'), > format='%(name)s') > > db.define_table('thing', > Field('name'), > Field('persona', 'reference person'), > Field('personb', 'reference person')) > > db.thing.persona.widget = SQLFORM.widgets.string.widget > db.thing.personb.widget = SQLFORM.widgets.string.widget > > > <type 'exceptions.Exception'> Validation error, field:persona > <gluon.validators.IS_IN_DB object at 0x7f835f7828d0> Version > web2py™ Version 2.12.3-stable+timestamp.2015.08.19.00.18.03 Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > > Traceback (most recent call last): > File "/opt/web2py/gluon/restricted.py", line 227, in restricted > exec ccode in environment > File "/opt/web2py/applications/welcome/controllers/appadmin.py" > <http://127.0.0.1:8000/admin/default/edit/welcome/controllers/appadmin.py>, > line 703, in <module> > File "/opt/web2py/gluon/globals.py", line 412, in <lambda> > self._caller = lambda f: f() > File "/opt/web2py/applications/welcome/controllers/appadmin.py" > <http://127.0.0.1:8000/admin/default/edit/welcome/controllers/appadmin.py>, > line 151, in insert > if form.accepts(request.vars, session): > File "/opt/web2py/gluon/sqlhtml.py", line 1495, in accepts > **kwargs > File "/opt/web2py/gluon/html.py", line 2119, in accepts > status = self._traverse(status, hideerror) > File "/opt/web2py/gluon/html.py", line 885, in _traverse > newstatus = c._traverse(status, hideerror) and newstatus > File "/opt/web2py/gluon/html.py", line 885, in _traverse > newstatus = c._traverse(status, hideerror) and newstatus > File "/opt/web2py/gluon/html.py", line 885, in _traverse > newstatus = c._traverse(status, hideerror) and newstatus > File "/opt/web2py/gluon/html.py", line 885, in _traverse > newstatus = c._traverse(status, hideerror) and newstatus > File "/opt/web2py/gluon/html.py", line 892, in _traverse > newstatus = self._validate() > File "/opt/web2py/gluon/html.py", line 1860, in _validate > raise Exception(msg) > Exception: Validation error, field:persona <gluon.validators.IS_IN_DB object > at 0x7f835f7828d0> > > > -- 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.