openerp-india team mailing list archive

["Jignesh Rathod\(OpenERP\)" <1061503@xxxxxxxxxxxxxxxxxx>]

Hello W. Martin Borgert ,

I have tried it at my end with following code but i did not face any problem 
like yours.So would you please elaborate more regarding this issue.

CODE :

import xmlrpclib

user = "demo"
pw = "demo"
db = "tr_mmm"
server = "localhost:8069"

sock_common = xmlrpclib.ServerProxy('http://'+server+'/xmlrpc/common')
uid = sock_common.login(db, user, pw)
sock = xmlrpclib.ServerProxy('http://'+server+'/xmlrpc/object')
ids = sock.execute(db, uid, pw, 'res.users', "search", [('login', '=', user)])
assert len(ids) == 1

Thanks and waiting for your reply.


** Changed in: openobject-server
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1061503

Title:
  xmlrpclib.Fault in latest nightly build

Status in OpenERP Server:
  Incomplete

Bug description:
  OpenERP 6.2dev-20120930-230101-1 on Debian 6.0.5

  Firefox 15.0.1 on Debian 6.0.5

  The following script does not work anymore:

  #!/usr/bin/python

  import xmlrpclib

  user = "theuser"
  pw = "apassword"
  db = "openerp"
  server = "myserver"

  sock_common = xmlrpclib.ServerProxy('https://' + server + '/xmlrpc/common')
  uid = sock_common.login(db, user, pw)
  sock = xmlrpclib.ServerProxy('https://' + server + '/xmlrpc/object')
  ids = sock.execute(db, uid, pw, 'res.users', "search", [('login', '=', user)])
  assert len(ids) == 1

  It leads to the following exception:

  Traceback (most recent call last):
    File "/tmp/test.py", line 14, in <module>
      ids = sock.execute(db, uid, pw, 'res.users', "search", [('login', '=', user)])
    File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
      return self.__send(self.__name, args)
    File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
      verbose=self.__verbose
    File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
      return self._parse_response(h.getfile(), sock)
    File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
      return u.close()
    File "/usr/lib/python2.6/xmlrpclib.py", line 838, in close
      raise Fault(**self._stack[0])
  xmlrpclib.Fault: <Fault column a.active does not exist
  LINE 1: ...E m.model = E'res.users'    AND gu.uid = 5    AND a.active I...
                                                               ^
  : 'Traceback (most recent call last):\n  File "/usr/lib/pymodules/python2.6/openerp/service/wsgi_server.py", line 82, in xmlrpc_return\n    result = openerp.netsvc.dispatch_rpc(service, method, params)\n  File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 362, in dispatch_rpc\n    result = ExportService.getService(service_name).dispatch(method, params)\n  File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 585, in dispatch\n    res = fn(db, uid, *params)\n  File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 121, in wrapper\n    return f(self, dbname, *args, **kwargs)\n  File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 176, in execute\n    res = self.execute_cr(cr, uid, obj, method, *args, **kw)\n  File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 164, in execute_cr\n    return getattr(object, method)(cr, uid, *args, **kw)\n  File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 2277, in search\n    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)\n  File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 4672, in _search\n    self.check_access_rights(cr, access_rights_uid or user, \'read\')\n  File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3753, in check_access_rights\n    return self.pool.get(\'ir.model.access\').check(cr, uid, self._name, operation, raise_exception)\n  File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 18, in lookup\n    r = self.lookup(self2, cr, *args)\n  File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 46, in lookup\n    value = d[args] = self.method(self2, cr, *args)\n  File "/usr/lib/pymodules/python2.6/openerp/addons/base/ir/ir_model.py", line 571, in check\n    , (model_name, uid,)\n  File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 152, in wrapper\n    return f(self, *args, **kwargs)\n  File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 212, in execute\n    res = self._obj.execute(query, params)\nProgrammingError: column a.active does not exist\nLINE 1: ...E m.model = E\'res.users\'    AND gu.uid = 5    AND a.active I...\n                                                             ^\n\n'>

  This used to work in the version two days before
  (6.2dev-20120928-230101-1), but does not work since.

  Workaround: Downgrade to 6.2dev-20120928-230101-1.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1061503/+subscriptions