[Phpgroupware-developers] PostgerSQL Errors with Timetrack

[Tina Messmann]

Hello,
i encountered a few Errors when using Timetrack.
my System:
debian woody
apache-ssl
postgresql 7.1.3
phpgw0.9.14RC2
timetrack is the newest version (i got it this morning via cvs)

Here are the errors:

-in Area 'Auftrags-Status':
when inserting a criteria in the textfield and clicking on 'Suchen':
Database error: Invalid SQL: SELECT count(*) from phpgw_ttrack_jobs as j 
left join phpgw_ttrack_customers as c on j.company_id = c.company_id 
WHERE j.account_id=9 order by c.company_name,j.job_number,j.job_revision asc
PostgreSQL Error: 1 (ERROR: Attribute c.company_name must be GROUPed or 
used in an aggregate function )

File: /var/www/htdocs/phpgroupware/timetrack/jobslist.php
Line: 88

- in Area 'View Job Entry' clicking on 'Generate' for the Activity Report:
Database error: Invalid SQL: SELECT 
j.work_date,e.lid,w.catagory_desc,j.num_hours,j.comments FROM 
phpgw_ttrack_job_details as j LEFT JOIN phpgw_ttrack_emplyprof as e on 
j.account_id = e.id left join phpgw_ttrack_wk_cat as w on 
j.work_catagory_id = w.work_catagory_id WHERE j.job_id='5' AND
j.work_date >= '20-0--2-02' AND j.work_date <= '2002-03-21' ORDER by 
work_date
                        ^^^^^^^^^^
PostgreSQL Error: 1 (ERROR: Bad date external representation '20-0--2-02' )

note:  in the Job Entry, the date was correct and it is correctly 
displayed in 'View Job Entry'

- in Area 'New Job Entry': I am a bit confused about the Job-ID. 
sometimes the correct ID (the next free number) is displayed and 
sometimes not. So i have now different jobs with the same ID.


- in Area 'Edit Time Entry the default Date of 'Date Worked' is 
displayed as 21-0--2-02 and the calendar does not function (the window 
pops up but it is empty). After clicking on 'Aktualisieren' a PostgreSQL 
Error occurs; same thing as above because of the wrog date format and a 
second error with an undefined function .

Database error: Invalid SQL: UPDATE phpgw_ttrack_job_details SET
work_catagory_id=6,work_date='21-0--2-02',start_time='12:15:00',end_time='13:15:00',num_hours='1',detail_billable='Y',comments='
                                                    ^^^^^^^^ ^
' WHERE detail_id=3
PostgreSQL Error: 1 (ERROR: Bad date external representation '21-0--2-02' )

Session halted.
Fatal error: Call to undefined function: parse_navbar_end() in 
/var/www/htdocs/phpgroupware/phpgwapi/inc/footer.inc.php on line 62

that was it for the moment, perhaps i'll find some more ;)
Best Regards to all developers
tina  aka zordaz