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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
