Update bugs: doesnt existe column res_partner.tz_offset

Asked by iehoshia_

Hi,

I'm testing openerp 6.2. I found a bug when upgrade the server with the latest nightly release. If exist a database before the release of the server, i receive this message:

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 91, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 361, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 601, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 351, in context_get
    res = getattr(user,k) or False
  File "/opt/openerp/server/openerp/osv/orm.py", line 485, in __getattr__
    return self[name]
  File "/opt/openerp/server/openerp/osv/orm.py", line 400, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 796, in read
    res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
  File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 272, in read
    result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3558, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3633, in _read_flat
    res2 = self.pool.get(table).read(cr, user, [x[col] for x in res], cols, context, load)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3558, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3610, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/opt/openerp/server/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
ProgrammingError: no existe la columna res_partner.tz_offset
LÍNEA 1: ...s_partner."signup_token",res_partner."country_id",res_partne...

I'm reading about this issue, and it's probabily a error on postgres or configuration, but dont know how to correct this.

Any helps will be appreciated!

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Ray Carnes
Solved:
Last query:
Last reply:
Revision history for this message
Ray Carnes (rcarnes) said :
#1

Did you upgrade the database when you upgraded the server?

Revision history for this message
iehoshia_ (jepgez) said :
#2

No, i didnt upgrade the database, use postgresql 9.1

Revision history for this message
Ray Carnes (rcarnes) said :
#3

I don't mean the database software, I mean the database. If a newer build of OpenERP changes a module definition (adds a column to a model), then those changes (a new table column) needs to be made in all databases you want to use with the newer build, which can only happen if you upgrade the database(s)

To invoke a database upgrade after installing a new version, you need to start the server with the –update=all argument.

Revision history for this message
iehoshia_ (jepgez) said :
#4

How I do start the server with the -update=all argument? I try to start from $ sudo /etc/init.d/openerp-server start -update=all argument... Is it correct?

Revision history for this message
Best Ray Carnes (rcarnes) said :
#5

/opt/openerp/server/openerp-server -c /etc/openerp-server.conf --update=all

Revision history for this message
iehoshia_ (jepgez) said :
#6

This works for me, thanks !!