Forum OpenACS Q&A: member value error message

Collapse
Posted by Ben Koot on
Hi folks,

We are trying to get the member value module operational but keep getting this message.. any thoughts, Thanks
Ben koot

<h2>Member Value (Money)</h2>

<a href="/pvt/home.tcl">Your Workspace</a> : <a href="/admin/">Admin 
Home</a> : Member Value

<hr>

<ul>
<li>documentation: <a
href="#/doc/member-value.html">/doc/member-value.html</a>
<li>using real money? Yes
<li>charging monthly? No
</ul>


<h3>Charges</h3>

<ul>
<li><a href="/admin/users/action-choose.tcl?
expensive=1&include_accumulated_charges_p=1">expensive users</a>

<p>


<li><a href="charges-all.tcl">review all charges</a>
</ul>


<h3>Billing</h3>

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

<ul>
HTTP/1.0 500 Internal Server Error
Content-Type: text/html; charset=iso-8859-1
MIME-Version: 1.0
Date: Mon, 17 Sep 2001 13:31:58 GMT
Server: AOLserver/3.3.1+ad13
Content-Length: 540
Connection: close

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML>
<HEAD>
<TITLE>Server Error</TITLE>
</HEAD>
<BODY>
<H2>Server Error</H2>
The requested URL cannot be accessed due to a system error on this 
server.
<P ALIGN=RIGHT><SMALL><I>AOLserver/3.3.1+ad13 on 
http://klessebes.timedesk.net:800</I></SMALL></P>
 
</BODY></HTML>
Collapse
Posted by Jonathan Ellis on
what does the server log say actually caused the error?
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)"

Collapse
Posted by Jonathan Ellis on
So, if you're not interested in CC billing, comment that part out. :)  You could also "officially" report a bug <a href=https://openacs.org/sdm/open-bafs.tcl?package_id=1>here</a>.

If you're determined to get it working "just because," (or to make sure it IS a bug and not misconfiguration of some sort) then run tail -f on your error log before you click so you can see which single error corresponds to this output.  Then you can post it between <pre></pre> tags so it doesn't run together like that.