openerp-india team mailing list archive

[Yann Papouin <yann.papouin@xxxxxxxxx>]

I foud why it's not working in my case.
I've installed the "City" module from Pablo Rocandio in addons-extra, that allows to keep homogeneous data for addresses.

class res_partner_address(osv.osv):
    _inherit = "res.partner.address"
    _columns = {
        'city_id': fields.many2one('city.city', 'Location', select=1),
        'zip': fields.related('city_id', 'zip', type="char", string="Zip", store=False),
        'city': fields.related('city_id', 'name', type="char", string="City",  store=False),
        'state_id': fields.related('city_id', 'state_id', type="many2one", relation="res.country.state", string="State", store=False),
        'country_id': fields.related('city_id', 'country_id', type="many2one", relation="res.country", string="Country", store=False),
    }
res_partner_address()

The problem comes from "crm_lead_report.py" that uses pure SQL to create
a VIEW, the field country_id does not exists anymore. Removing the
"c.country_id," line fixes the update issue.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1000468

Title:
  [6.1] crm module crashes on installation...

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Hi: 
  When I try to install the crm module in version 6.1, the system tries to install fetchmail_crm and sale_crm to install. 
  Then I confirm the installation but there is the next error message:

  Environment Information : 
  System : Linux-3.2.0-24-generic-x86_64-with-Ubuntu-12.04-precise
  OS Name : posix
  Distributor ID:	Ubuntu
  Description:	Ubuntu 12.04 LTS
  Release:	12.04
  Codename:	precise
  Operating System Release : 3.2.0-24-generic
  Operating System Version : #37-Ubuntu SMP Wed Apr 25 08:43:22 UTC 2012
  Operating System Architecture : 64bit
  Operating System Locale : es_US.UTF-8
  Python Version : 2.7.3
  OpenERP-Client Version : 6.1.1
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/home/saturno/openerp-6.1-1/openerp/service/netrpc_server.py", line 64, in run
      result = netsvc.dispatch_rpc(msg[0], msg[1], msg[2:])
    File "/home/saturno/openerp-6.1-1/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/saturno/openerp-6.1-1/openerp/service/web_services.py", line 572, in dispatch
      res = fn(db, uid, *params)
    File "/home/saturno/openerp-6.1-1/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/saturno/openerp-6.1-1/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/saturno/openerp-6.1-1/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/saturno/openerp-6.1-1/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 "/home/saturno/openerp-6.1-1/openerp/pooler.py", line 39, in restart_pool
      registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
    File "/home/saturno/openerp-6.1-1/openerp/modules/registry.py", line 160, in new
      openerp.modules.load_modules(registry.db, force_demo, status, update_module)
    File "/home/saturno/openerp-6.1-1/openerp/modules/loading.py", line 338, in load_modules
      processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
    File "/home/saturno/openerp-6.1-1/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 "/home/saturno/openerp-6.1-1/openerp/modules/loading.py", line 170, in load_module_graph
      init_module_models(cr, package.name, models)
    File "/home/saturno/openerp-6.1-1/openerp/modules/module.py", line 382, in init_module_models
      obj.init(cr)
    File "/home/saturno/openerp-6.1-1/openerp/addons/crm/report/crm_lead_report.py", line 151, in init
      )""")
    File "/home/saturno/openerp-6.1-1/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/home/saturno/openerp-6.1-1/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column c.country_id does not exist
  LINE 29:                     c.country_id,
                               ^

  What is missing?

  Thanks

  DG

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