Forum OpenACS Q&A: Adserver errors

Collapse
Posted by Ravi Gadad on
I'm having some trouble with the adserver.  When I try to delete
an ad, I get an error message.  Looking closer, it seems that the
query requesting "round(max(entry_date)-min(entry_date))" is
causing problems, since Postgres seems to think I'm trying to
round an interval.  From what I understand, the query is
requesting the result of subtracting min(entry_date) from
max(entry_date), and trying to round it.  Anyone have any
suggestions?  Obviously, this isn't an extremely important issue,
since I can just stop using the ad, or delete it manually, but I
would like to be able to use delete-adv.tcl in admin/adserver/ if
possible.

Thank you for any help!