Re: [Phpgroupware-users] Timetrack Error

[Andrew Thurlow]

Hi Brian

This is the link
http://phpgw.portalcomputing.com.au/timetrack/viewjob.php?
jobid=244&start=0&order=&filter=&query=&sort=&qfield=
at the bottom of the jobs list.

If I run the query through a mysql text interface it works fine.

Basically I cant get any info out of timetrack now except the default. If I try 
and
change the job type, timesheets (as an admin) or even the In-Out it goes back to
the default pages.

The whole thing is hamstrung.



Brian Johnson (address@hidden) wrote*:
>
>view the job = hit the view button from the job status/list screen?
>
>is that the entire error message?
>
>when in job status/list screen, move the cursor over the view button and tell 
>us
>what the meessage is in the bottom of the browser (where it shows the url that 
>it
>links to)
>
>can you do other things in ttrack after this error?
>
>
>
>Andrew Thurlow (address@hidden) wrote:
>>
>>Hi
>>
>>I am running Apache 1.3.27. PHP 4.2.3 Redhat 7.3, mysql 3.22.32
>>
>>In time track I can get a job list but when I try to view the job I get
>>
>>Database error: Invalid SQL: select * from phpgw_ttrack_jobs where job_id=
>>
>>Session halted.
>>
>>I select the jobs myself with out any issues from another mysql interface.
>>
>>I have recently recompiled apache to add mod_perl in but this should be
irrelevant.
>>I also had to delete a user using SQL prompt instead of phpgw as it gives me 
>>an
>>error. This may be something
>>
>>Grateful for any ideas of how to get out. This thing runs my billing...
>>
>>Thanks
>>
>>Andrew
>>
>>Director
>>Portal Computing
>>Phone: 08 89420411
>>Fax:   08 89420433
>>www.portalcomputing.com.au
>>
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>This is where my witty signature line would be if I bothered to edit this line 
>:)
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>