Hi. Upgrade to OpenERP 4.2.3 or downgrade PostgreSQL to 8.2.x.
Cheers. Mugoma, Yengas Technologies. [EMAIL PROTECTED] wrote: > 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 _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
