openerp-india team mailing list archive

["W. Martin Borgert" <1061503@xxxxxxxxxxxxxxxxxx>]

OK, now I begin to understand. In nigthly build
6.2dev-20120930-230101-1, a new boolean field "active" has been added in
model 'ir.model.access', defaulting to True. The upgrade, however, did
not add the field to the existing database, which has been created with
6.2dev-20120925-230102-1 or earlier.

What is the correct way to migrate the database? I was under the
impression, that this is done automatically...

-- 
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