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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
