Re: [Phpgroupware-users] Timetrack Error

[Kevin O Connor]

I have just compleated a clean install and get the same loop problem it is 
not possable to alter anything and there are no errors being reported. 
Calender and Address Book work fine. As this is my first installation of this 
I have nothing to compare it to but it seems as if the data is not being 
written to the tables just dumped.
Regards
Kevin


---------- Original Message -----------
From: "Brian Johnson" <address@hidden>
To: address@hidden
Sent: Fri, 28 Mar 2003 02:59:26 +0000
Subject: Re: [Phpgroupware-users] Timetrack Error

> 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 :)
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
------- End of Original Message -------