Re: [Phpgroupware-users] Timetrack Error

[Andrew Thurlow]

Hi Brian

Yeah timetrack works really well... and has done now for ages... I am running
0.9.14.001 I have done a CVS a while ago but havent had time to go with 002 yet.

I was doing two things at the time... I delted the user through the mysql 
interface
not through phpgw but I also recompiled in perl into apache 1.3.27 so also a
recompile of my original version of php 4.2.3

I am happy to do another cvs but doesnt this just update the php files not the
database...

I have had to go back to manual for now until I get it fixed and the data in it 
is
$$$ so it is important to me...

Regards

Andrew

Brian Johnson (address@hidden) wrote*:
>
>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
>>
>
>
>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
>
>