Re: [Phpgroupware-users] CVS Errors & Timetrack

[Brian Johnson]

OK delete that line we addedd and stick in this one with the correct values
  $filter_obj = array(array('none','show all'));


Andrew Thurlow (address@hidden) wrote*:
>
>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
>>
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>