c2c-oerpscenario team mailing list archive

[Cesitar Jones <682651@xxxxxxxxxxxxxxxxxx>]

I have a similar error message after I pulled the saturday trunk update:
"column ir_ui_menu.web_icon_data does not exist". the database structure
has changed. You have to restart the server using the --update=all
switch. It didn't work flawless for me. It failed because of a unique
constraint in a column.

-- 
db.cursor:Programming error: column ir_ui_menu.web_icon_data does not exist
https://bugs.launchpad.net/bugs/682651
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: New

Bug description:
I experience errors below when trying to update the module lists. Below is the errors reported in the log files and in the Client UI, respectively

Server side
addons/: revno: 3972
addons-community/: revno: 282
addons-extra/: revno: 5157
server/: revno: 3051

log/openerp-server.log

[2010-11-29 19:52:32,296][demo60] ERROR:db.cursor:Programming error: column ir_ui_menu.web_icon_data does not exist
LINE 1: SELECT ir_ui_menu.web_icon_data,ir_ui_menu.name,ir_ui_menu.w...
               ^
, in query SELECT ir_ui_menu.web_icon_data,ir_ui_menu.name,ir_ui_menu.web_icon,ir_ui_menu.sequence,ir_ui_menu.web_icon_hover,ir_ui_menu.parent_id,ir_ui_menu.web_icon_hover_data,ir_ui_menu.icon,ir_ui_menu.id FROM "ir_ui_menu" WHERE ir_ui_menu.id IN %s ORDER BY sequence,id
[2010-11-29 19:52:32,296][demo60] WARNING:base.ir.module.module:Unknown error while browsing ir.ui.menu[397]
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/module/module.py", line 126, in _get_views
    res_mod_dic['menus_by_module'].append(menu_obj.browse(cr,uid,data_id.res_id).complete_name)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 278, in __getattr__
    return self[name]
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 203, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 2995, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3115, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/fields.py", line 751, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/ir/ir_ui_menu.py", line 169, in _get_full_name
    res[m.id] = self._get_one_full_name(m)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/ir/ir_ui_menu.py", line 175, in _get_one_full_name
    if menu.parent_id:
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 278, in __getattr__
    return self[name]
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 203, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 2995, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3054, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column ir_ui_menu.web_icon_data does not exist
LINE 1: SELECT ir_ui_menu.web_icon_data,ir_ui_menu.name,ir_ui_menu.w...
               ^

[2010-11-29 19:52:32,299][demo60] ERROR:db.cursor:bad query: SELECT ir_ui_view.inherit_id,ir_ui_view.name,ir_ui_view.type,ir_ui_view.priority,ir_ui_view.model,ir_ui_view.arch,ir_ui_view.field_parent,ir_ui_view.id FROM "ir_ui_view" WHERE ir_ui_view.id IN (899) ORDER BY priority
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block


Client side

Environment Information : 
System : Linux-2.6.32-26-generic-x86_64-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID:	Ubuntu
Description:	Ubuntu 10.04.1 LTS
Release:	10.04
Codename:	lucid
Operating System Release : 2.6.32-26-generic
Operating System Version : #47-Ubuntu SMP Wed Nov 17 15:58:05 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : en_AU.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :1703 launchpad_translations_on_behalf_of_openerp-20101129045036-bbxhc7451w6lhdo8
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/var/local/software/openerp-v6.0dev/server/bin/service/web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base_module_record/base_module_record.py", line 41, in execute
    res = super(recording_objects_proxy, self).execute(*args, **argv)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/module/wizard/base_module_update.py", line 42, in update_module
    update, add = module_obj.update_list(cr, uid,)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/module/module.py", line 385, in update_list
    self.write(cr, uid, mod.id, updated_values)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3564, in write
    self.pool.get(object)._store_set_values(cr, user, todo, fields, context)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3856, in _store_set_values
    ','.join(upd0) + ' where id = %s', upd1)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block