← Back to team overview

openerp-india team mailing list archive

[Bug 1092024] Re: Cant create new database: ProgrammingError: column res_users.menu_id does not exist

 

Hello Alan,

You are trying to connect your old database with latest changes of the trunk that's why you have faced this type of error.
Because on trunk day by day the latest changes is updated. You can try the following steps for using a old database.

You have to update your old database bu using -u all -d database name.
Or you have to create new database and then you can try.

Thanks hope this help.

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

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

Title:
  Cant create new database: ProgrammingError: column res_users.menu_id
  does not exist

Status in OpenERP Server:
  Invalid

Bug description:
  Just built a new OpenERP 7 from trunk pull on Ubuntu 64 bit.

  When trying to create a database without demo data I get the following
  error and then you cannot get back to the database admin page (it's
  just a blank page) without a restart:

  Client Traceback (most recent call last):
    File "/opt/openerp70/web/addons/web/http.py", line 195, in dispatch
      response["result"] = method(self, **self.params)
    File "/opt/openerp70/web/addons/web/controllers/main.py", line 819, in authenticate
      req.session.authenticate(db, login, password, env)
    File "/opt/openerp70/web/addons/web/session.py", line 116, in authenticate
      if uid: self.get_context()
    File "/opt/openerp70/web/addons/web/session.py", line 166, in get_context
      self.context = self.model('res.users').context_get() or {}
    File "/opt/openerp70/web/addons/web/session.py", line 40, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/opt/openerp70/web/addons/web/session.py", line 28, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/opt/openerp70/web/addons/web/session.py", line 101, in send
      raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

  
  Server Traceback (most recent call last):
    File "/opt/openerp70/web/addons/web/session.py", line 87, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/opt/openerp70/server/openerp/netsvc.py", line 281, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/opt/openerp70/server/openerp/service/web_services.py", line 603, in dispatch
      res = fn(db, uid, *params)
    File "/opt/openerp70/server/openerp/osv/osv.py", line 169, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/opt/openerp70/server/openerp/osv/osv.py", line 123, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/openerp70/server/openerp/osv/osv.py", line 179, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/openerp70/server/openerp/osv/osv.py", line 166, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp70/server/openerp/tools/cache.py", line 18, in lookup
      r = self.lookup(self2, cr, *args)
    File "/opt/openerp70/server/openerp/tools/cache.py", line 46, in lookup
      value = d[key] = self.method(self2, cr, *args)
    File "/opt/openerp70/server/openerp/addons/base/res/res_users.py", line 349, in context_get
      res = getattr(user,k) or False
    File "/opt/openerp70/server/openerp/osv/orm.py", line 484, in __getattr__
      return self[name]
    File "/opt/openerp70/server/openerp/osv/orm.py", line 399, in __getitem__
      field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
    File "/opt/openerp70/server/openerp/addons/base/res/res_users.py", line 794, in read
      res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
    File "/opt/openerp70/server/openerp/addons/base/res/res_users.py", line 268, in read
      result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
    File "/opt/openerp70/server/openerp/osv/orm.py", line 3606, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/opt/openerp70/server/openerp/osv/orm.py", line 3658, in _read_flat
      cr.execute(query, [tuple(sub_ids)] + rule_params)
    File "/opt/openerp70/server/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp70/server/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column res_users.menu_id does not exist
  LINE 1: SELECT res_users."menu_id",res_users."login_date",res_users....
                 ^

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


References