Re: [Phpgroupware-users] CVS Errors & Timetrack

[Andrew Thurlow]

That seems to be a database call so I get error

Database error: Invalid SQL: SELECT 3, In Progress FROM phpgw_ttrack_job_status

File: 
/usr/local/apache/htdocs/phpgroupware/phpgwapi/inc/class.nextmatchs.inc.php
Line: 479

Session halted.

when I try that ...

If this is passing the tablename and details is there somewhere this is turned 
into
the drop down? Specific to timetrack?

Not really sure where to go from here...

Andrew

Brian Johnson (address@hidden) wrote*:
>
>It's a quick hack - I think you can fill in the filter box by sticking the
>following line inside the if statement you added (make sure it is below the
>existing $filterobj = ... line near the beginning of the file)
>
>  // Substitute your default status-id and status_name values
>  $filterobj = $GLOBALS['phpgw']->nextmatchs->filterobj
>("phpgw_ttrack_job_status", "status_id", "status_name");
>
>
>
>
>
>Andrew Thurlow (address@hidden) wrote*:
>>
>>That works a treat .. thanks...
>>
>>but it still says Show All (even thought its only showing the in progress and 
>>I
>>cant find that text pattern anywhere. I am assuming its text as it doesnt 
>>appear
in
>>the database.
>>
>>
>>
>>
>>Brian Johnson (address@hidden) wrote*:
>>>
>>>I did a fair bit of modification to joblist.php including what I would call 
>>>some
>>>bug fixes to allow the user to sort by column by picking on the column 
>>>heading
and
>>>reverse the sort by clicking again (I think this is how it was expected to 
>>>work)
>>>
>>>I also added a new admin screen to set some site options - I suppose I could 
>>>look
>>>at creating an option for a default filter on the jobslist.php screen
>>>
>>>In the meantime, try adding a few lines near the top of the file (you will 
>>>have
to
>>>look up the status_id for the "in progress" record in the database table 
>>>yourself
>>>for now) - here I've assumed that it is 1
>>>
>>>
>>>  if (($filter == "") {
>>>    // Change 1 to the status_id value of the record you want
>>>    $filter = 1;
>>>    //You will have to type "none" in the filter box to clear this selection
>>>  }
>>>
>>>
>>>Andrew Thurlow (address@hidden) wrote*:
>>>>
>>>>Hi
>>>>
>>>>Did the update
>>>>
>>>>After a cvs on timetrack I got an error
>>>>Parse error: parse error, expecting `','' or `';''
>>>>in /usr/local/apache/htdocs/phpgroupware/timetrack/timesheets.php on line 
>>>>179
>>>>
>>>>when trying to look at timesheets
>>>>
>>>>To fix it needed to add  " on line 175 after the "\n
>>>>
>>>>Can someone fix the cvs...
>>>>
>>>>I would like to change the default job list from "show all" to "in 
>>>>progress".
>>Looks
>>>>like its the $order variable h_order... where does this live?
>>>>
>>>>Thanks
>>>>
>>>>Andrew
>>>>
>>>>
>>>>Chris Weiss (address@hidden) wrote*:
>>>>>
>>>>>the file manager error might be related to phpgwebhosting being renamed to
>>>>>filemanager, but I though that happened before the .14 release.
>>>>>
>>>>>For the reset, you making it to complicated, which is easy to do from 
>>>>>trying to
>>>>read
>>>>>the cvs docs.  Since the tarball already has the CVS dir in it, you only 
>>>>>need
to
>>>>run
>>>>>`cvs -z6 update -dP` to do an update.  If you only want to update one app, 
>>>>>run
>>>that
>>>>>from that apps dir.  SO you only need to do:
>>>>>
>>>>>cd timetrack
>>>>>cvs -z6 update -dP
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>Andrew Thurlow (address@hidden) wrote*:
>>>>>>
>>>>>>Hi
>>>>>>
>>>>>>I have been trying to do a CVS version update from base tarball 
>>>>>>0.9.14.000 to
>>>>>>latest cvs. Particularly to get the timetrack updates. When cvs-ing using
>>>>>>
>>>>>>cvs -d:pserver:address@hidden:/cvsroot/phpgroupware login
>>>>>>no password
>>>>>>cvs -z6 update -Pd
>>>>>>
>>>>>>I get updates until
>>>>>>
>>>>>>cvs [server aborted]: missing expected branches
>>>>>>in /cvsroot/phpgroupware/filemanager/index.php,v
>>>>>>
>>>>>>Also if I just choose timetrack
>>>>>>
>>>>>>cvs -z6 -d blah co timetrack I get a
>>>>>>
>>>>>>Parse error: parse error, expecting `','' or `';''
>>>>>>in /usr/local/apache/htdocs/phpgroupware/timetrack/timesheets.php on line 
>>>>>>179
>>>>>>
>>>>>>when trying to access previous timesheets
>>>>>>
>>>>>>Any Ideas?
>>>>>>
>>>>>>Andrew
>>>>>>
>>>>>>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
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>_______________________________________________
>>>>>Phpgroupware-users mailing list
>>>>>address@hidden
>>>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>>>
>>>>>
>>>>
>>>>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
>>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>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
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>