alfonsodg / demo-web2py

Apache License 2.0
0 stars 0 forks source link

Postgresql: column "origin" specified more than once #169

Closed alfonsodg closed 10 years ago

alfonsodg commented 10 years ago

From gr...@jingojango.net on January 31, 2011 08:03:14

What steps will reproduce the problem? 1. Update to 1564:5a15fcefb69a

  1. Use postgresql database
  2. Attempt to login What is the expected output? What do you see instead? Traceback (most recent call last): File "/Users/grutz/src/web2py-hg/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/Users/grutz/src/web2py-hg/applications/autospa_ng/controllers/default.py", line 325, in File "/Users/grutz/src/web2py-hg/gluon/globals.py", line 95, in self._caller = lambda f: f() File "/Users/grutz/src/web2py-hg/applications/autospa_ng/controllers/default.py", line 14, in user def user(): return dict(form=auth()) File "/Users/grutz/src/web2py-hg/gluon/tools.py", line 1034, in call return self.login() File "/Users/grutz/src/web2py-hg/gluon/tools.py", line 1527, in login self.log_event(log % self.user) File "/Users/grutz/src/web2py-hg/gluon/tools.py", line 1277, in log_event origin=origin, user_id=user_id) File "/Users/grutz/src/web2py-hg/gluon/dal.py", line 3934, in insert return self._db._adapter.insert(self,self._listify(fields)) File "/Users/grutz/src/web2py-hg/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... What version of the product are you using? On what operating system? OS X, Python 2.6.1, web2py hg source 1564:5a15fcefb69a Please provide any additional information below. Looks like the issue may be in _listify as the new_fields are not being detected in the line:
        if not name in new_fields:

Just a guess.

Original issue: http://code.google.com/p/web2py/issues/detail?id=171

alfonsodg commented 10 years ago

From massimo....@gmail.com on January 31, 2011 18:16:31

This should now be fixed.

Status: Fixed