Forum OpenACS Q&A: Response to member value error message

Collapse
Posted by Ben Koot on
Hi ,

here's a copy of the latest error report... The point is we are not interested in charging a creditcard. The whole module does not seem to work, or did we miss something stupid? Ben koot

[17/Sep/2001:18:18:47]
    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 mbs.*,round((success_time-start_time)*24*60) as n_minutes from mv_billing_sweeps mbs order by start_time desc""
        invoked from within
    "if [mv_parameter UseRealMoneyP 0] {
        ns_write "
    <h3>Billing</h3>

    These are records of when we actually tried to bill users' credit
    cards.

    <ul>
    "
    ..."
        (file "/var/lib/aolserver/servers/kles/www/admin/member-value/index.tcl" line 55)
        invoked from within
    "source $ad_conn(file)"
        (procedure "ad_handle_abstract_url" line 67)
        invoked from within
    "ad_handle_abstract_url cns258 {}"
    217.120.34.78 - - [17/Sep/2001:18:18:47 -0100] "GET /admin/member-value/ HTTP/1.1" 500 540 "http://klessebes.timedesk.net:800/doc/member-value.html" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:18:47 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    Notice: ns_getform using encoding iso8859-1 for charset iso-8859-1

[17/Sep/2001:18:18:54]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Unable to identify an operator '>' for types 'money' and 'int4'
        You will have to retype this query using an explicit cast

[17/Sep/2001:18:18:54]
    Error: dbinit: error(localhost::kles,ERROR:  Unable to identify an operator '>' for types 'money' and 'int4'
        You will have to retype this query using an explicit cast
    ): 'select users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state, sum(users_char!
ges.amount) as accumulated_charges
        from users, users_charges
        where users.user_id = users_charges.user_id
    and (users_charges.order_id is null)
    group by users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state
    having sum(users_charges.amount) > 20'

[17/Sep/2001:18:18:54]
    Error: can't read "The query
    <blockquote>
    select users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state, sum(users_charges.!
amount) as accumulated_charges
        from users, users_charges
        where users.user_id = users_charges.user_id
    and (users_charges.order_id is null)
    group by users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state
    having sum(users_charges.amount) > 20
    </blockquote>
    is invalid.
    <hr>
    <a href="mailto:webmaster@digiTaaldienst.nl";><address>mailto:webmaster@digiTaaldienst.nl</address></a>
    </body>
    </html>": no such variable
    can't read "The query
    <blockquote>
    select users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state, sum(users_charges.!
amount) as accumulated_charges
        from users, users_charges
        where users.user_id = users_charges.user_id
    and (users_charges.order_id is null)
    group by users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state
    having sum(users_charges.amount) > 20
    </blockquote>
    is invalid.
    <hr>
    <a href="mailto:webmaster@digiTaaldienst.nl";><address>mailto:webmaster@digiTaaldienst.nl</address></a>
    </body>
    </html>": no such variable
        while executing
    "append  "The query
    <blockquote>
    $query
    </blockquote>
    is invalid.
    [ad_admin_footer]""
        invoked from within
    "if { [ad_parameter NumberOfUsers] == "small" } {
        # we print out all the users
        append action_heading "<ul>"
        set query [ad_user_class_query ..."
        (file "/var/lib/aolserver/servers/kles/www/admin/users/action-choose.tcl" line 49)
        invoked from within
    "source $script"
        (procedure "ns_sourceproc" line 6)
        invoked from within
    "ns_sourceproc cns260 {}"
    217.120.34.78 - - [17/Sep/2001:18:18:54 -0100] "GET /admin/users/action-choose.tcl?expensive=1&include_accumulated_charges_p=1 HTTP/1.1" 500 540 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:18:56 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"

[17/Sep/2001:18:19:00]
    Error: Ns_PgExec: result status: 7 message: ERROR:  parser: parse error at or near "("

[17/Sep/2001:18:19:00]
    Error: dbinit: error(localhost::kles,ERROR:  parser: parse error at or near "("
    ): 'select uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator_name
    from users_charges uc, users u, users au
    where uc.user_id = u.user_id
    and uc.admin_id = au.user_id(+)
    order by entry_date desc'

[17/Sep/2001:18:19:00]
    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 uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator_name
    from user..."
        invoked from within
    "set selection [ns_db select $db "select uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator..."
        (file "/var/lib/aolserver/servers/kles/www/admin/member-value/charges-all.tcl" line 19)
        invoked from within
    "source $script"
        (procedure "ns_sourceproc" line 6)
        invoked from within
    "ns_sourceproc cns262 {}"
    217.120.34.78 - - [17/Sep/2001:18:19:00 -0100] "GET /admin/member-value/charges-all.tcl HTTP/1.1" 500 540 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:19:01 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/charges-all.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    Notice: Running scheduled proc ec_sweep_for_cybercash_zombie_gift_certificates...

[17/Sep/2001:18:19:27]
    Error: Ns_PgExec: result status: 7 message: ERROR:  parser: parse error at or near "("

[17/Sep/2001:18:19:27]
    Error: dbinit: error(localhost::kles,ERROR:  parser: parse error at or near "("
    ): 'select uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator_name
    from users_charges uc, users u, users au
    where uc.user_id = u.user_id
    and uc.admin_id = au.user_id(+)
    order by entry_date desc'

[17/Sep/2001:18:19:27]
    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 uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator_name
    from user..."
        invoked from within
    "set selection [ns_db select $db "select uc.*, u.first_names || ' ' || u.last_name as user_name, au.first_names || ' ' || au.last_name as administrator..."
        (file "/var/lib/aolserver/servers/kles/www/admin/member-value/charges-all.tcl" line 19)
        invoked from within
    "source $script"
        (procedure "ns_sourceproc" line 6)
        invoked from within
    "ns_sourceproc cns265 {}"
    217.120.34.78 - - [17/Sep/2001:18:19:27 -0100] "GET /admin/member-value/charges-all.tcl HTTP/1.1" 500 540 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:19:27 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/charges-all.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"

[17/Sep/2001:18:19:35]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Function 'round(interval)' does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

[17/Sep/2001:18:19:35]
    Error: dbinit: error(localhost::kles,ERROR:  Function 'round(interval)' does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts
    ): 'select mbs.*,round((success_time-start_time)*24*60) as n_minutes from mv_billing_sweeps mbs order by start_time desc'

[17/Sep/2001:18:19:35]
    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 mbs.*,round((success_time-start_time)*24*60) as n_minutes from mv_billing_sweeps mbs order by start_time desc""
        invoked from within
    "if [mv_parameter UseRealMoneyP 0] {
        ns_write "
    <h3>Billing</h3>

    These are records of when we actually tried to bill users' credit
    cards.

    <ul>
    "
    ..."
        (file "/var/lib/aolserver/servers/kles/www/admin/member-value/index.tcl" line 55)
        invoked from within
    "source $script"
        (procedure "ns_sourceproc" line 6)
        invoked from within
    "ns_sourceproc cns267 {}"
    217.120.34.78 - - [17/Sep/2001:18:19:35 -0100] "GET /admin/member-value/index.tcl HTTP/1.1" 500 540 "http://klessebes.timedesk.net:800/admin/member-value/charges-all.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:19:36 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/index.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:00 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/index.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    Notice: ns_getform using encoding iso8859-1 for charset iso-8859-1
    217.120.34.78 - - [17/Sep/2001:18:20:06 -0100] "GET /doc/sql/display-sql.tcl?url=/doc/sql/member-value.sql HTTP/1.1" 200 7731 "http://klessebes.timedesk.net:800/doc/member-value.html" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:14 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/index.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:15 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/charges-all.tcl" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:16 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/member-value/" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:36 -0100] "GET /doc/membervalue HTTP/1.1" 404 547 "" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:38 -0100] "GET /graphics/ad_at_angle.gif HTTP/1.1" 404 547 "http://klessebes.timedesk.net:800/admin/curriculum/element-list" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:40 -0100] "GET /pvt/home.tcl HTTP/1.1" 302 344 "http://klessebes.timedesk.net:800/admin/curriculum/element-list" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"
    217.120.34.78 - - [17/Sep/2001:18:20:40 -0100] "GET /intranet/index.tcl HTTP/1.1" 200 9249 "http://klessebes.timedesk.net:800/admin/curriculum/element-list" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)"