openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #06195
[Bug 878956] Re: update base module error
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, graph, status, report=report, skip_modules=processed_modules))
File "/opt/openerp/repos/6.0.x/openobject-server/bin/addons/__init__.py", line 719, in load_module_graph
init_module_objects(cr, package.name, modules)
File "/opt/openerp/repos/6.0.x/openobject-server/bin/addons/__init__.py", line 420, in init_module_objects
obj.init(cr)
File "/opt/openerp/repos/6.0.x/openobject-addons/crm/report/crm_lead_report.py", line 119, in init
)""")
File "/opt/openerp/repos/6.0.x/openobject-server/bin/sql_db.py", line 78, in wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/repos/6.0.x/openobject-server/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,
^
[2012-02-03 00:06:54,611][test_openerp_603] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
File "/opt/openerp/repos/6.0.x/openobject-server/bin/service/netrpc_server.py", line 70, in run
result = self.dispatch(msg[0], msg[1], msg[2:])
File "/opt/openerp/repos/6.0.x/openobject-server/bin/netsvc.py", line 499, in dispatch
raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException
[2012-02-03 00:06:54,967][test_openerp_603] DEBUG:init:loading 1 packages..
My enviroment:
OpenERP 6.0.3 from Launchpad (yesterday)
Ubuntu 10.04.3
PostgresSQL 8.4
Start debug:
[2012-02-03 00:06:30,922][?] INFO:server:OpenERP version - 6.0.3
[2012-02-03 00:06:30,922][?] INFO:server:addons_path - /opt/openerp/repos/6.0.x/openobject-localizations-openerp-spain,
/opt/openerp/repos/6.0.x/openobject-addons-aeroo,
/opt/openerp/repos/6.0.x/openobject-addons-openlabs-poweremail/poweremail,
/opt/openerp/repos/6.0.x/openobject-addons-magentoerpconnect,
/opt/openerp/repos/6.0.x/openobject-addons-fleetmanager/fleetmanager,
/opt/openerp/repos/6.0.x/openobject-addons-prestashop-sync,
/opt/openerp/repos/6.0.x/openobject-addons-avanzosc,
/opt/openerp/repos/6.0.x/openobject-addons-c2c,
/opt/openerp/repos/6.0.x/openobject-addons-c2c-agile-openerp-support,
/opt/openerp/repos/6.0.x/openobject-addons-c2c-financial-addons,
/opt/openerp/repos/6.0.x/openobject-addons-c2c-geoengine-addons,
/opt/openerp/repos/6.0.x/openobject-addons-extra,
/opt/openerp/repos/6.0.x/openobject-addons,
/opt/openerp/6.0.x/openobject-server/bin/addons
[2012-02-03 00:06:30,923][?] INFO:server:database hostname - localhost
[2012-02-03 00:06:30,923][?] INFO:server:database port - 5432
[2012-02-03 00:06:30,923][?] INFO:server:database user - oerp60x_7jrxq2
[2012-02-03 00:06:30,923][?] INFO:server:initialising distributed objects services
[2012-02-03 00:06:31,072][?] DEBUG:psycopg2:installed. Logging using Python logging module
[2012-02-03 00:06:31,074][?] DEBUG:web-services:Registered an exported service: db
[2012-02-03 00:06:31,074][?] DEBUG:web-services:Registered an exported service: common
[2012-02-03 00:06:31,074][?] DEBUG:web-services:Registered an exported service: object
[2012-02-03 00:06:31,075][?] DEBUG:web-services:Registered an exported service: wizard
[2012-02-03 00:06:31,075][?] DEBUG:web-services:Registered an exported service: report
[2012-02-03 00:06:31,088][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 60301
[2012-02-03 00:06:31,088][?] INFO:web-services:Registered XML-RPC over HTTP
[2012-02-03 00:06:31,089][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 60303
[2012-02-03 00:06:31,089][?] INFO:server:Starting 2 services
[2012-02-03 00:06:31,089][?] INFO:server:OpenERP server is running, waiting for connections...
** Changed in: openobject-addons
Status: Invalid => Incomplete
--
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/878956
Title:
update base module error
Status in OpenERP Addons (modules):
Incomplete
Bug description:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/878956/+subscriptions
