Re: [Phpgroupware-users] Timetrack Error

[Andrew Thurlow]

Hi Brian

I did a cvs update on just about everything in phpgroupware (filemanager is 
failing
for some reason) and while the error is still occuring at least it gives an SQL
error now...

Database error: Invalid SQL: select * from phpgw_ttrack_jobs where job_id=
MySQL Error: 1064 (You have an error in your SQL syntax near '' at line 1)

Session halted.



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

FTPdefdwn.txt
Description: Text document