Re: [Phpgroupware-users] Timetrack Error

[Brian Johnson]

These errors that you get don't seem to be timetrack related

It was working for you right?

Have you changed config (or upgraded) phpgw, php, or mysql recently?

What version or phpgw are you running?  When is last time you upgraded 
timetrack?


Andrew Thurlow (address@hidden) wrote:
>
>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
>>
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
Brian Johnson

This is where my witty signature line would be if I bothered to edit this line 
:)