Re: [Phpgroupware-users] Timetrack Error

[Andrew Thurlow]

Hi

I have now done a full cvs update (including setup of the database). No errors 
and
no problems except with time track. I can successfully add and delete users,
calendar events, addresses.

Everything in timetrack doesnt want to save though. Initial screens are OK but 
if I
try do do anything it returns me to the default, If I try to add a job I get to 
the
add job screen but then in selecting a customer I get put back to the select
customer screen...

Only error is the database 1056 error which comes up in a number of places when
chasing final data. But the data is definately in ...

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
>
>

--
Andrew Thurlow
BIT CNE MCSE CCA

Director
Portal Computing
Phone: 08 89420411
Fax:   08 89420433
www.portalcomputing.com.au