we are investigating openERP as part of our business but we did not get good
start. Trying to install modules we got this one:
Traceback (most recent call last):
File "/usr/lib/tinyerp-server/netsvc.py", line 202, in _dispatch
r=m(*params)
File "/usr/lib/tinyerp-server/service/web_services.py", line 422, in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "/usr/lib/tinyerp-server/service/web_services.py", line 402, in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "/usr/lib/tinyerp-server/wizard/__init__.py", line 160, in execute
res = self.execute_cr(cr, uid, data, state, context)
File "/usr/lib/tinyerp-server/wizard/__init__.py", line 75, in execute_cr
action_res = action(self, cr, uid, data, context)
File
"/usr/lib/tinyerp-server/addons/base/module/wizard/wizard_module_upgrade.py",
line 80, in _upgrade_module
db, pool = pooler.restart_pool(cr.dbname, update_module=True)
File "/usr/lib/tinyerp-server/pooler.py", line 64, in restart_pool
return get_db_and_pool(db_name, force_demo, update_module=update_module)
File "/usr/lib/tinyerp-server/pooler.py", line 53, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib/tinyerp-server/addons/__init__.py", line 274, in load_modules
load_module_graph(cr, graph, status, report=report)
File "/usr/lib/tinyerp-server/addons/__init__.py", line 204, in
load_module_graph
init_module_objects(cr, m, modules)
File "/usr/lib/tinyerp-server/addons/__init__.py", line 181, in
init_module_objects
obj.init(cr)
File "/usr/lib/tinyerp-server/addons/report_crm/report_crm.py", line 75, in
init
)""")
File "/usr/lib/tinyerp-server/sql_db.py", line 75, in execute
res = self.obj.execute(sql)
ProgrammingError: ERROR: function pg_catalog.substring(timestamp without time
zone, integer, integer) does not exist
LINE 5: substring(c.create_date for 7)||'-01' as name,
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
create or replace view report_crm_case_user as (
select
min(c.id) as id,
substring(c.create_date for 7)||'-01'
as name,
c.state,
c.user_id,
c.section_id,
count(*) as nbr,
sum(planned_revenue) as amount_revenue,
sum(planned_cost) as amount_costs,
sum(planned_revenue*probability)::decimal(16,2) as amount_revenue_prob,
avg(probability)::decimal(16,2) as
probability,
to_char(avg(date_closed-c.create_date),
'DD"d" HH24:MI:SS') as delay_close
from
crm_case c
group by substring(c.create_date for 7),
c.state, c.user_id, c.section_id
)
******************************
Is this typical that this software is not ready to used?
-------------------- m2f --------------------
--
http://www.openerp.com/forum/viewtopic.php?p=25804#25804
-------------------- m2f --------------------
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
