Now, there is a programming error in nightly build (source version) [pgsql]:
Traceback (most recent call last): File "/home/szimszon_nfs/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/szimszon_nfs/web2py/applications/raktar/controllers/ default.py", line 77, in <module> File "/home/szimszon_nfs/web2py/gluon/globals.py", line 95, in <lambda> self._caller = lambda f: f() File "/home/szimszon_nfs/web2py/applications/raktar/controllers/ default.py", line 52, in user return dict( form = auth() ) File "/home/szimszon_nfs/web2py/gluon/tools.py", line 1034, in __call__ return self.login() File "/home/szimszon_nfs/web2py/gluon/tools.py", line 1527, in login self.log_event(log % self.user) File "/home/szimszon_nfs/web2py/gluon/tools.py", line 1277, in log_event origin=origin, user_id=user_id) File "/home/szimszon_nfs/web2py/gluon/dal.py", line 3934, in insert return self._db._adapter.insert(self,self._listify(fields)) File "/home/szimszon_nfs/web2py/gluon/dal.py", line 707, in insert raise e ProgrammingError: column "origin" specified more than once LINE 1: ...t(origin,user_id,description,time_stamp,client_ip,origin,des... ^ Error snapshot help <class 'psycopg2.ProgrammingError'>(column "origin" specified more than once LINE 1: ...t(origin,user_id,description,time_stamp,client_ip,origin,des... ^ ) On jan. 30, 16:08, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > This should be fixed in trunk (and nightly build).Please give it a try > and confirm. > > Massimo > > On Jan 30, 7:46 am, szimszon <szims...@gmail.com> wrote: > > > > > > > > > I wonder if somebody could help me. > > > Here is my Field: > > > Field( 'updated_by', db.auth_user, > > writable = False ) > > > CRUD rendered it in form "None" but the record has a value 1 and I > > have user in auth_user.id=1 > > > If I modify the Field to: > > > Field( 'updated_by', db.auth_user, > > writable = False , > > requires = IS_EMPTY_OR( IS_IN_DB( > > db, db.auth_user.id, '% > > (first_name)s' ) ) ) > > > The result is "1" and not the first_name value. > > > If I modify the Field to: > > > Field( 'updated_by', db.auth_user) > > > The result is a list with all the auth_user rows :-o > > > With the Field like this: > > > Field( 'updated_by', db.auth_user, > > requires = IS_EMPTY_OR( IS_IN_DB( > > db, db.auth_user.id, '% > > (first_name)s' ) ) ) > > > There is a result list with all the first_name values... > > > Version 1.91.6 (2011-01-03 17:55:14)