Forum OpenACS Q&A: Error installing mailing-lists

Collapse
1: Error installing mailing-lists
Posted by Ben Chan on 06/11/04 11:40 PM
I've tried installing from both the acs-admin/install software interface and downloading from cvs openacs-4/contrib/packages/mailing-lists and get the same error.

Is there a way to fix this? 
Database operation "0or1row" failed

ERROR:  Binding of AcsMailLite to mailing_lists failed.

SQL: 
            select acs_sc_binding__new(
                       'AcsMailLite', 
                       'mailing_lists'
                   ); 	
        
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select acs_sc_binding__new(
                       :contract_name, 
                       :impl_name
         ..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
       ..."
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
                ns_log Debug "PLPGSQL: bypassed anon function"
                set selection [..."
    ("uplevel" body line 6)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
            # plsql calls that are simple selects bypass the plpgsql 
            # mechanism for creating anonymous fun..."
    (procedure "db_exec_plsql" line 57)
    invoked from within
"db_exec_plsql binding_new {}"
    (procedure "acs_sc::impl::binding::new" line 3)
    invoked from within
"acs_sc::impl::binding::new -contract_name AcsMailLite -impl_name mailing_lists"
    (procedure "mail_job::after_install" line 4)
    invoked from within
"mail_job::after_install "
    ("eval" body line 1)
    invoked from within
"eval $command"
Collapse
2: Re: Error installing mailing-lists (response to 1)
Posted by Don Baccus on 06/12/04 01:45 AM
Is acs-mail-lite installed?  It's possible that the mailing list package is missing a dependency and getting installed without acs-mail-lite...

Just guessing...

Collapse
3: Re: Error installing mailing-lists (response to 1)
Posted by Ben Chan on 06/15/04 08:05 PM
Well I have acs-mail-lite 0.3.  However I'm running OpenACS 5.0 and if I go to install acs-mail-lite from admin, only acs-mail-lite 0.1 is available.
Collapse
4: Re: Error installing mailing-lists (response to 3)
Posted by Malte Sussdorff on 06/15/04 09:03 PM
Then get acs-mail-lite out of the contrib section and replace your current installed version 0.1. For OpenACS 5.0, mailing-list depends on the acs-mail-lite package in contrib.

In general I'd suggest to move to 5.1 if you have the chance.

Collapse
5: Re: Error installing mailing-lists (response to 4)
Posted by Ben Chan on 06/17/04 10:23 PM
Well I've got the binding with acs-mail-lite worked out, but I've been getting a categories error now after trying to create a new mailing list. Categories is version 0.1d from acs-admin/install:

Request Error

invalid command name "category::ad_form::get_categories"
    while executing
"category::ad_form::get_categories -container_object_id $package_id"
    invoked from within
"set category_ids [category::ad_form::get_categories -container_object_id $package_id]"
    ("uplevel" body line 2)
    invoked from within
"uplevel #$level $on_submit"
    ("1" arm line 1)
    invoked from within
"switch $errno {
            0 {
                # TCL_OK
            }
            1 {
                # TCL_ERROR
                global errorInfo er..."
    (procedure "ad_form" line 609)
    invoked from within
"ad_form -extend -name mailing_list_form -form {
    {sender_email:text {label "Mail Sender"} {html {size 50 maxlength 1000}}}
    {confirm_subject:tex..."
    ("uplevel" body line 34)
    invoked from within
"uplevel {
    	  ad_page_contract {
} {
    list_id:integer,optional
}

set user_id [ad_maybe_redirect_for_registration]
set package_id [ad_conn packa..."
    (procedure "code::tcl::/web/openacs/packages/mailing-lists/www/madmin/li..." line 2)
    invoked from within