Package: tinyerp-server
Version: 4.2.2-1
Severity: important
Hi,
Sorry to report a known problem but I think it's important.
Using postgresql 8.3, you get the following erro while installing a new
database :
ProgrammingError: ERROR: function pg_catalog.substring(date, integer, integer)
does not exist
LINE 4: DISTINCT(SUBSTRING(l.date for 7))||'-'||...
^
HINT: 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
)
This is related to some missing explicit casting.
The problem is described and solved here :
http://archives.postgresql.org/pgsql-bugs/2008-01/msg00001.php . It is solved
upstream, see :
http://tinyforge.org/tracker/?group_id=13&atid=129&func=detail&aid=610 .
I don't know if it's possible to patch this version too.
Didrik
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.24-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages tinyerp-server depends on:
ii adduser 3.108 add and remove users and groups
ii python 2.5.2-1 An interactive high-level object-o
ii python-libxml2 2.6.32.dfsg-2 Python bindings for the GNOME XML
ii python-libxslt1 1.1.24-1 Python bindings for libxslt1
ii python-psycopg2 2.0.7-3 Python module for PostgreSQL
ii python-reportlab 2.1dfsg-2 ReportLab library to create PDF do
ii python-support 0.8.1 automated rebuilding support for P
Versions of packages tinyerp-server recommends:
ii graphviz 2.18-1+b2 rich set of graph drawing tools
ii postgresql 8.3.1-2 object-relational SQL database (su
ii postgresql-client-8.3 [postgr 8.3.1-2+b1 front-end programs for PostgreSQL
ii python-imaging 1.1.6-2 Python Imaging Library
ii python-pyparsing 1.4.11-2 Python parsing module
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
