Odoo中文社区可以通过以下两个域名访问:shine-it.net , odoo.net.cn

由于系统升迁的原因,本论坛部分较早期的内容存在格式和链接损坏失效的问题,并非本论坛系统本身的缺陷,望谅解

本社区没有维护任何QQ群讨论组,任何与本社区同名的QQ群讨论组的言论与本社区无关!

开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

如果您登录系统碰到问题,请在微信公众号留言:

安装报表模块出错



  • 我在本机上安装的,当我尝试添加报表模块里,服务端出现下面的错误信息:
    Thu, 06 Mar 2008 18:25:59 ERROR:web-services:Exception in call: Traceback (most recent call last):
    File "/usr/lib/python2.5/site-packages/tinyerp-server/netsvc.py", line 200, in _dispatch
    r=m(*params)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/service/web_services.py", line 422, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
    File "/usr/lib/python2.5/site-packages/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/python2.5/site-packages/tinyerp-server/wizard/init.py", line 160, in execute
    res = self.execute_cr(cr, uid, data, state, context)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/wizard/init.py", line 75, in execute_cr
    action_res = action(self, cr, uid, data, context)
    File "/usr/lib/python2.5/site-packages/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/python2.5/site-packages/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/python2.5/site-packages/tinyerp-server/pooler.py", line 53, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/addons/init.py", line 274, in load_modules
    load_module_graph(cr, graph, status, report=report)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/addons/init.py", line 204, in load_module_graph
    init_module_objects(cr, m, modules)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/addons/init.py", line 181, in init_module_objects
    obj.init(cr)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/addons/report_sale/report_sale.py", line 72, in init
    """)
    File "/usr/lib/python2.5/site-packages/tinyerp-server/sql_db.py", line 75, in execute
    res = self.obj.execute(sql)
    ProgrammingError: 错误: 函数 pg_catalog.substring(date, integer, integer) 不存在
    LINE 5: substring(s.date_order 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_sale_order_product as (
                                select
                                        min(l.id) as id,
                                        substring(s.date_order for 7)||'-'||'01' as name,
                                        s.state,
                                        l.product_id,
                                        sum(l.product_uom_qty*u.factor) as quantity,
                                        count(*),
                                        sum(l.product_uom_qty*l.price_unit) as price_total,
                                        (sum(l.product_uom_qty*l.price_unit)/sum(l.product_uom_qty*u.factor))::decimal(16,2) as price_average
                                from sale_order s
                                        right join sale_order_line l on (s.id=l.order_id)
                                        left join product_uom u on (u.id=l.product_uom)
                                group by l.product_id, substring(s.date_order for 7),s.state
                        )

Log in to reply