update base module error

[Diego Guzman]

Hi:

I have install a fresh database openerp v6.0.3.
Then I install modules base_contac_city and city.
In order to assure the integrity of the modules I run the update process of the base module.
There is the next error message:

Environment Information :
System : Linux-2.6.38-11-generic-x86_64-with-Ubuntu-11.04-natty
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 11.04
Release: 11.04
Codename: natty
Operating System Release : 2.6.38-11-generic
Operating System Version : #50-Ubuntu SMP Mon Sep 12 21:17:25 UTC 2011
Operating System Architecture : 64bit
Operating System Locale : es_US.UTF8
Python Version : 2.7.1+
OpenERP-Client Version : 6.0.3
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/home/diego/openerp-server-6.0.3/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/diego/openerp-server-6.0.3/bin/service/web_services.py", line 596, in dispatch
    security.check(db,uid,passwd)
  File "/home/diego/openerp-server-6.0.3/bin/service/security.py", line 43, in check
    pool = pooler.get_pool(db)
  File "/home/diego/openerp-server-6.0.3/bin/pooler.py", line 79, in get_pool
    pool = get_db_and_pool(db_name, force_demo, status, update_module)[1]
  File "/home/diego/openerp-server-6.0.3/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/home/diego/openerp-server-6.0.3/bin/addons/__init__.py", line 883, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/home/diego/openerp-server-6.0.3/bin/addons/__init__.py", line 719, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/home/diego/openerp-server-6.0.3/bin/addons/__init__.py", line 420, in init_module_objects
    obj.init(cr)
  File "/home/diego/openerp-server-6.0.3/bin/addons/crm/report/crm_lead_report.py", line 119, in init
    )""")
  File "/home/diego/openerp-server-6.0.3/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/diego/openerp-server-6.0.3/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: no existe la columna c.country_id
LÍNEA 23: c.country_id,
                              ^

Please help!!

Best regards

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Diego,

I have checked your issue with updated code with trunk and stable version both but It is working normally , I

didn't get any trace back at my end. I have checked with following revision :

Trunk :

          Server - 3772

         Gtk-client - 1985

         addons - 5432

Stable:

         Server - 3526

        Gtk-client - 1907

        Addons - 4894

Would you please try with updated code and informed us where you faced the problem.

Thanks and waiting for your reply.

[Launchpad Janitor (janitor)]

[Expired for OpenERP Addons because there has been no activity for 60 days.]

[Amit Parik (amit-parik)]

Hello Diego,

Would you please try with the latest updated code.

Currently I am closing this issue, If you still face the problem then you can reopen this with more information.

Thanks.

[Jose R. Prieto (joserprieto)]

I have the same error:

[2012-02-03 00:06:53,833][test_openerp_603] INFO:init:module crm: creating or updating database tables
[2012-02-03 00:06:54,609][test_openerp_603] ERROR:db.cursor:Programming error: no existe la columna c.country_id
LÍNEA 23: c.country_id,
                              ^
, in query
            CREATE OR REPLACE VIEW crm_lead_report AS (
                SELECT
                    id,
                    to_char(c.create_date, 'YYYY') as name,
                    to_char(c.create_date, 'MM') as month,
                    to_char(c.create_date, 'YYYY-MM-DD') as day,
                    to_char(c.create_date, 'YYYY-MM-DD') as creation_date,
                    to_char(c.date_open, 'YYYY-MM-DD') as opening_date,
                    to_char(c.date_closed, 'YYYY-mm-dd') as date_closed,
                    c.state,
                    c.user_id,
                    c.probability,
                    c.stage_id,
                    c.type,
                    c.company_id,
                    c.priority,
                    c.section_id,
                    c.channel_id,
                    c.type_id,
                    c.categ_id,
                    c.partner_id,
                    c.country_id,
                    c.planned_revenue,
                    c.planned_revenue*(c.probability/100) as probable_revenue,
                    1 as nbr,
                    (SELECT count(id) FROM mailgate_message WHERE model='crm.lead' AND res_id=c.id AND history=True) AS email,
                    date_trunc('day',c.create_date) as create_date,
                    extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as delay_close,
                    abs(extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24)) as delay_expected,
                    extract('epoch' from (c.date_open-c.create_date))/(3600*24) as delay_open
                FROM
                    crm_lead c
            )
[2012-02-03 00:06:54,609][test_openerp_603] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/6.0.x/openobject-server/bin/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/opt/openerp/repos/6.0.x/openobject-server/bin/addons/__init__.py", line 883, in load_modules
    processed_modules.extend(load_module_graph(cr,...

[Amit Parik (amit-parik)]

Hello Jose,

Would you please try this with latest vesrion6.1.
Currently I am closing this issue, If you still faced the problem then you can reopen this.

Thanks!

[Jose R. Prieto (joserprieto)]

This isn't a solution for me.
With the discontinuation of the development of the GTK Client, i need to stay en version 6.0.x.
Many thanks.

[Alexandre Fayolle - camptocamp (alexandre-fayolle-c2c)]

@amp-openerp: you cannot ask someone to upgrade from a LTS version to a non LTS one.

[Serpent Consulting Services (serpent-consulting-services)]

Hi,

This is more likely due to city module which alters the country_id field of the address to be functional field.

In order to solve, you can make the country field store=True in city module.

Thanks.