[webdev] FW: Errors on The Aclug Community

["Dale W Hodge" <dwh@xxxxxxxxxxxxxxxx>]

I'm trying to run OpenACS on Debian. Things were working fine until I updated
the database to version 7.2.1.  Enclosed is the message from the OpenACS
logwatch daemon:

 -----
Errors since 08/Jun/2002:17:31:03

[08/Jun/2002:17:31:44]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Unable to identify an
operator '<=' for types 'date' and 'timestamp without time zone'
        You will have to retype this query using an explicit cast


[08/Jun/2002:17:31:44]
    Error: dbinit: error(localhost::aclug,ERROR:  Unable to identify an operator
'<=' for types 'date' and 'timestamp without time zone'
        You will have to retype this query using an explicit cast
    ): 'select spam_id, creation_user, from_address, body_plain, body_html,
body_aol, title, user_class_query, user_class_description, send_date, status,
last_user_id_sent, template_p from spam_history
        where send_date::date <= sysdate()
        and (status = 'unsent' or status = 'interrupted')
        order by send_date
        for update'

[08/Jun/2002:17:31:44]
    Error: Database operation "select" failed (exception NSDB, "Query was not a
statement returning rows.")
    Database operation "select" failed (exception NSDB, "Query was not a
statement returning rows.")
        while executing
    "ns_db select $db "select spam_id, creation_user, from_address, body_plain,
body_html, body_aol, title, user_class_query, user_class_description, send_..."
        (procedure "send_scheduled_spam_messages" line 41)
        invoked from within
    "send_scheduled_spam_messages"
        ("eval" body line 1)
        invoked from within
    "eval [concat [list $proc] $args]"
        (procedure "ad_run_scheduled_proc" line 43)
        invoked from within
    "ad_run_scheduled_proc {t f 1810 send_scheduled_spam_messages {} 1023568254
0 t}"
    Notice: Running scheduled proc wd_mail_errors...