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

Collapse
Posted by Jeff Davis on
Yeah, that is a new (but somewhat related) bug; both of these are related to changes in postgres from 7.2 to 7.3 for timestamp handling and this package was never updated.

In this case, trunc on an interval used to return the number of days but that was removed in 7.3, now it should use date_part('days',...).

the other thing to do after you fix these is to submit a patch in bug tracker so everyone else can benefit from your bug fixing :)

There are some instructions for that here It's good if they are attached to a bug report but even if not submitting patches is the best way (short of committing directly) to make sure the fixes find their way into the release.