Re: [Phpgroupware-users] Timetrack Error

[Brian Johnson]

Have you had any luck yet?

Andrew Thurlow (address@hidden) wrote:
>
>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
>>
>>
>
>
>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
>

--
Brian Johnson

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