[6.1] Programming error: column res_company.address_validation_method does not exist

Bug #967293 reported by Maxime Chambreuil (http://www.savoirfairelinux.com)
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenERP-USA Localization
Fix Released
Medium
Unassigned

Bug Description

I tried to install shipping_api_ups module on OpenERP 6.1 and I got this error message at installation:

2012-03-28 16:44:41,668 10138 INFO openerpdev openerp.modules.loading: module partner_address_validation: loading objects
/Users/openerpdev/openerp/openerp-usa/partner_address_validation/usps_account.py:44: SyntaxWarning: import * only allowed at module level
  def address_validation(self,cr, uid, address_id, context={}):
2012-03-28 16:44:41,702 10138 INFO openerpdev openerp.modules.module: module partner_address_validation: creating or updating database tables
2012-03-28 16:44:41,761 10138 ERROR openerpdev openerp.sql_db: Programming error: column res_company.address_validation_method does not exist
LINE 1: ..._company."paper_format",res_company."overdue_msg",res_compan...
                                                             ^
, in query SELECT res_company."rml_header",res_company."security_lead",res_company."currency_id",res_company."logo",res_company."partner_id",res_company."account_no",res_company."expense_currency_exchange_account_id",res_company."name",res_company."parent_id",res_company."po_lead",res_company."manufacturing_lead",res_company."rml_header2",res_company."rml_header3",res_company."rml_header1",res_company."vat_check_vies",res_company."lzipmatch",res_company."schedule_range",res_company."rml_footer1",res_company."paypal_account",res_company."company_registry",res_company."paper_format",res_company."overdue_msg",res_company."address_validation_method",res_company."local_media_repository",res_company."income_currency_exchange_account_id",res_company.id FROM "res_company" WHERE res_company.id IN %s ORDER BY name
2012-03-28 16:44:41,762 10138 ERROR openerpdev openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "/Users/openerpdev/openerp/server/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/Users/openerpdev/openerp/server/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/Users/openerpdev/openerp/server/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/Users/openerpdev/openerp/server/openerp/addons/base/module/wizard/base_module_upgrade.py", line 101, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/Users/openerpdev/openerp/server/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/Users/openerpdev/openerp/server/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/Users/openerpdev/openerp/server/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/Users/openerpdev/openerp/server/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/Users/openerpdev/openerp/server/openerp/modules/loading.py", line 170, in load_module_graph
    init_module_models(cr, package.name, models)
  File "/Users/openerpdev/openerp/server/openerp/modules/module.py", line 378, in init_module_models
    result = obj._auto_init(cr, {'module': module_name})
  File "/Users/openerpdev/openerp/server/openerp/osv/orm.py", line 2995, in _auto_init
    default = self._defaults[k](self, cr, SUPERUSER_ID, context)
  File "/Users/openerpdev/openerp/openerp-usa/partner_address_validation/partner_address_validation.py", line 88, in _get_address_validation_method
    return user and user.company_id and user.company_id.address_validation_method
  File "/Users/openerpdev/openerp/server/openerp/osv/orm.py", line 476, in __getattr__
    return self[name]
  File "/Users/openerpdev/openerp/server/openerp/osv/orm.py", line 391, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/Users/openerpdev/openerp/server/openerp/osv/orm.py", line 3406, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/Users/openerpdev/openerp/server/openerp/osv/orm.py", line 3465, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/Users/openerpdev/openerp/server/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/Users/openerpdev/openerp/server/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column res_company.address_validation_method does not exist
LINE 1: ..._company."paper_format",res_company."overdue_msg",res_compan...
                                                             ^

2012-03-28 16:44:41,928 10138 ERROR openerpdev openerp.netsvc: column res_company.address_validation_method does not exist
LINE 1: ..._company."paper_format",res_company."overdue_msg",res_compan...

Tags: 6.1
Revision history for this message
Serpent Consulting Services (serpent-consulting-services) wrote :

Maxime,

We just faced it and found a fix in local.

Today when I update the code, it has been fixed already by revision http://bazaar.launchpad.net/~uslocalizationteam/openerp-usa/US_Localization_v6/revision/50

Thanks.

Changed in openerp-usa:
status: New → Confirmed
importance: Undecided → Medium
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.