#33 Project. Error creating invoice
When I try to create an invoice i receive this error
<-- CUT HERE -->
Warning: PostgreSQL query failed: ERROR: Function
'ceiling(numeric)' does not exist Unable to identify a
function that satisfies the given argument types You
may need to add explicit typecasts in
/var/www/html/calendar/phpgwapi/inc/phpgw_db_pgsql.inc.php
on line 78
Database error: Invalid SQL: SELECT
sum(billperae*ceiling(minutes/minperae)) as sum FROM
p_hours,p_invoicepos WHERE p_invoicepos.invoice_id=2
AND p_hours.id=p_invoicepos.hours_id
PostgreSQL Error: 1 (ERROR: Function 'ceiling(numeric)'
does not exist Unable to identify a function that
satisfies the given argument types You may need to add
explicit typecasts )
<-- CUT HERE -->
I use Postgres 7.0.3, phpgroupware 0.9.9p1 (although it
continues saying me that I'm using 0.9.9).