I am running PO 3.3 on a Ubuntu machine, I installed following these instructions: https://help.ubuntu.com/community/ProjectOpen.

When I click Timesheet I get the following:

Database operation "0or1row" failed
(exception ERROR, "ERROR:  function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT:  PL/pgSQL function "last_day" line 6 at SQL statement
")
pqerror was: "ERROR:  function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT:  PL/pgSQL function "last_day" line 6 at SQL statement
"
(Status of PQexec call: PGRES_FATAL_ERROR)

When I click Absences I get the following:

Database operation "select" failed
(exception ERROR, "ERROR:  function upper(timestamp with time zone) does not exist
LINE 17:  order by owner_name, upper(start_date);
                               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
")
pqerror was: "ERROR:  function upper(timestamp with time zone) does not exist
LINE 17:  order by owner_name, upper(start_date);
                               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
"
(Status of PQexec call: PGRES_FATAL_ERROR)

I would really appreciate some help with this issue.
Thanks.
-Scott

Similar errors are popping up in many places, the errors usually include some date variable/function.

could it be that u r using PG 8.3?
http://www.mkyong.com/database/to_date-function-between-postgresql-82-and-83/
./k
 

hi, I have the same error with function to_date in  postgresql 8.3

so what is the solution? installing a previous version of postgre? 8.2? 8.1?

thanks
luciano

Ok, I just saw the fix for that replace the function to_date in postgresql 8.3

tx

**I have same issue. I am using psql 8.4.11. What can I do to fix the issue.

the timesheet tab shows the following error .**
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

    Database operation "0or1row" failed (exception ERROR, "ERROR:  function to_date(integer, unknown) does not exist
    LINE 1: select to_char(to_date(2456141, 'J'), 'YYYY-MM-DD');
                           ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    ")

    ERROR:  function to_date(integer, unknown) does not exist
    LINE 1: select to_char(to_date(2456141, 'J'), 'YYYY-MM-DD');
                           ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

The absences tab shows the following error.

Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

    Database operation "select" failed (exception ERROR, "ERROR:  function upper(timestamp with time zone) does not exist
    LINE 21:  order by owner_name, upper(start_date);
                                   ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    ")

    ERROR:  function upper(timestamp with time zone) does not exist
    LINE 21:  order by owner_name, upper(start_date);
                                   ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  Please please some one help me on this. From past 2 weeks i am stuck with this.

Hi,

Please see https://sourceforge.net/projects/project-open/forums/forum/295937/topic/5496635 for issues with PG 8.4.

Cheers,
Frank