When trying to create a database I get the following error:
(on FreeBSD-current with pgsql 8.3.1)
File
"/usr/home/mathiasp/Developer/TinyERP/tinyerp-server-4.2.3-rc1/bin/addons/__init__.py",
line 204, in load_module_graph
init_module_objects(cr, m, modules)
File
"/usr/home/mathiasp/Developer/TinyERP/tinyerp-server-4.2.3-rc1/bin/addons/__init__.py",
line 181, in init_module_objects
obj.init(cr)
File
"/usr/home/mathiasp/Developer/TinyERP/tinyerp-server-4.2.3-rc1/bin/addons/report_analytic_line/report_analytic_line.py",
line 70, in init
""")
File
"/usr/home/mathiasp/Developer/TinyERP/tinyerp-server-4.2.3-rc1/bin/sql_db.py",
line 75, in execute
res = self.obj.execute(sql)
ProgrammingError: ERROR: function pg_catalog.substring(date, integer, integer)
does not exist
ZEILE 4: DISTINCT(SUBSTRING(l.date for 7))||'-'||...
^
TIP: No function matches the given name and argument types. You might need to
add explicit type casts.
CREATE OR REPLACE VIEW report_account_analytic_line_to_invoice AS (
SELECT
DISTINCT(SUBSTRING(l.date for 7))||'-'||'01' AS name,
MIN(l.id) AS id,
l.product_id,
l.account_id,
SUM(l.amount) AS amount,
SUM(l.unit_amount*t.list_price) AS sale_price,
SUM(l.unit_amount) AS unit_amount,
l.product_uom_id
FROM
account_analytic_line l
left join
product_product p on (l.product_id=p.id)
left join
product_template t on (p.product_tmpl_id=t.id)
WHERE
(invoice_id IS NULL) and (to_invoice IS NOT NULL)
GROUP BY
SUBSTRING(date for 7), product_id, product_uom_id,
account_id
)
-------------------- m2f --------------------
--
http://www.openerp.com/forum/viewtopic.php?p=23288#23288
-------------------- m2f --------------------
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
