c2c-oerpscenario team mailing list archive

["Vo Minh Thu \(OpenERP\)" <701104@xxxxxxxxxxxxxxxxxx>]

It seems you're using an updated server code with a non-updated db.

Did you try to use the -u option (used together with -d) to update your
db?

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/701104

Title:
  [6.0 rc2] ERROR module install/upgrade fails on existing db

Status in OpenObject Server:
  New

Bug description:
  following the last changes to the server, I get an error on install/upgrade of any module.
I suppose that this is due to the lack of the field ir_translation.xml_id, which did not exist and it is not created during install upgrade. everything is ok on new db.

i checked several [un]certified modules...

[2011-01-10 17:57:03,429][bs_assets] INFO:i18n:module hr: loading translation file (fr) for language fr_FR
[2011-01-10 17:57:03,430][bs_assets] INFO:i18n:loading /home/openerp/addons/hr/i18n/fr.po
[2011-01-10 17:57:03,443][bs_assets] ERROR:db.cursor:Programming error: column "xml_id" of relation "ir_translation" does not exist
LINE 1: insert into "ir_translation" (id,"lang","src","xml_id","name...
                                                      ^
, in query insert into "ir_translation" (id,"lang","src","xml_id","name","type","value","module","res_id") values (10469,%s,%s,%s,%s,%s,%s,%s,%s)
[2011-01-10 17:57:03,444][bs_assets] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 885, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 774, in load_module_graph
    modobj.update_translations(cr, 1, [mid], None)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/module.py", line 514, in update_translations
    tools.trans_load(cr, f, lang, verbose=False, context=context2)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/translate.py", line 841, in trans_load
    r = trans_load_data(cr, fileobj, fileformat, lang, verbose=verbose, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/translate.py", line 928, in trans_load_data
    trans_obj.create(cr, uid, dic)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/ir/ir_translation.py", line 184, in create
    ids = super(ir_translation, self).create(cursor, user, vals, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3601, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "xml_id" of relation "ir_translation" does not exist
LINE 1: insert into "ir_translation" (id,"lang","src","xml_id","name...
                                                      ^