do you have a custom auth_user table? How does it look like?
On Jan 30, 11:29 am, szimszon <szims...@gmail.com> wrote: > 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)
