Forum OpenACS Q&A: Re: learn to debug an error

Collapse
10: Re: learn to debug an error (response to 1)
Posted by Yves Goldberg on 07/07/04 10:49 AM
Thanks Yarkko,

I've created a bug and resolve report at:
https://openacs.org/bugtracker/openacs/bug?filter%2estatus=resolved&bug%5fnumber=1961

with the following:

in packages/robot-detection/tcl/robot-detection-procs-postgresql.xql

change:
===============================================
select trunc(current_timestamp - max(coalesce(modified_date, in\
sertion_date))) from robots
===============================================
with
===============================================
select date_part('days',current_timestamp - max(coalesce(modified_date,insertion_date))) from robots
===============================================

Thank you again.

Collapse
11: Re: learn to debug an error (response to 10)
Posted by Jarkko Laine on 07/07/04 11:14 AM
Yves,

The state 'Resolved' in bug tracker should only be used when the bug has been fixed in OpenACS CVS repository. Now you have a solution but it's not yet fixed in CVS. If you please, you could upload a patch to bug tracker, which would enhance the possibilities that someone with commit rights will fix the bug soon:

  1. Go to the directory in your checkout where the file in question lies.
  2. Write cvs diff -Nu robot-detection-procs-postgresql.xql > patch-file
  3. Go to your bug in bug tracker.
  4. Hit "Submit a Patch".
  5. Fill in the form and submit the patch file you got from diff.
Collapse
12: Re: learn to debug an error (response to 11)
Posted by Jarkko Laine on 07/07/04 11:21 AM
Oh yes, and please read the patch instructions Jeff pointed to earlier if you want to understand better the reasoning for this workflow.