Error when adding new user

Ask your questions regarding TimeTrex installation here.
Locked
jpyoung
Posts: 1
Joined: Fri Apr 11, 2008 12:49 pm

Error when adding new user

Post by jpyoung »

I am using Timetrex 2.2.8 on windows 2003/Wamp and Postgresql 8.3

When adding a user I get a blank page.

Error
Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-1: ERROR: function lpad(character varying, integer, integer) does not exist LINE 10: ORDER BY LPAD( employee_number, 10, 0 ) DESC ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.] in EXECUTE(" select * from users as a where company_id = ? AND id = ( select id from users where company_id = ? AND employee_number != '' AND employee_number IS NOT NULL AND deleted = 0 ORDER BY LPAD( employee_number, 10, 0 ) DESC LIMIT 1 ) AND deleted = 0 LIMIT 1 ") ' in C:\wamp\www\TimeTrex08\classes\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\wamp\www\TimeTrex08\classes\adodb\adodb.inc.php(886): adodb_throw('postgres7', 'EXECUTE', -1, 'ERROR: functio...', '??????select ?*...', Array, Object(ADODB_postgres7)) #1 C:\wamp\www\TimeTrex08\classes\adod in C:\wamp\www\TimeTrex08\classes\adodb\adodb-exceptions.inc.php on line 78
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

TimeTrex has not been tested with PostgreSQL 8.3 yet, I recommend installing PostgreSQL 8.2.X and trying that instead.
Locked