Forum OpenACS Q&A: Addressbook Request Error

Collapse
Posted by Ben Koot on
Hi folks,

We upgraded yesterday to openacs 4.6.2. The addressbook show this error message. Any idea what we missed?

Thanks
Ben

Request Error
invalid command name "place::address::entry1row"
    while executing
"place::address::entry1row address address"
    ("uplevel" body line 57)
    invoked from within
"uplevel {
          ad_page_contract {

    Address Book Contact Add Page

    @author John Mileham (mailto:jmileham@arsdigita.com)
    @creation-date 11/20/200..."
    (procedure "code::tcl::/web/snorri/packages/address-book/www/contact-add" line 2)
    invoked from within
"code::tcl::$__adp_stub"
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init tcl $__adp_stub
..."
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 2)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 7)
    invoked from within
"$handler"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
    $handler
      } ad_script_abort val {
    # do nothing
      }"
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file "$root/$path""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
    rp_serve_abstract_file "$root/$path"
    set tcl_url2file([ad_conn url]) [ad_conn file]
    set tcl_url2path_info([ad_conn url]) [ad_conn path_inf..."

Collapse
Posted by Jon Griffin on
address-book has been deprecated for a long time.
Collapse
Posted by Ben Koot on
Jon,

I am well aware of the discussions, that's why I was surprised to find the module in the first place. It wasn't in our 4.6 installation, but all of a sudden shows up in 4.6.2. so i hoped we have a functional address book. To bad. It might be an idea to remove it alltogether from the distribution.

Ben

Collapse
Posted by Jon Griffin on
I am close to completing the new contacts package, it may have some issues but should be usable.

Note there are some data model changes.

http://jongriffin.com/static/openacs/packages/

Collapse
Posted by Ben Koot on
Jon,

That sure looks interesting. It seems to cover the topics in my latest project. Here's a mock up. http://www.timedesk.nl/list.htm
Ben

Collapse
Posted by David Cotter on
Jon

Should your Contacts Lite package work with PG and Opnacs 4.6.2? I have installed it but I have not had much luck running it.

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind select nsdb0 { *SQL* }"
    ("uplevel" body line 1)
    invoked from within
...

Collapse
Posted by Jon Griffin on
Yes it works. Did you restart your server?
Collapse
Posted by David Cotter on
Jon

Thanks for the reply. I installed Contacts Lite but got an error. I then installed all your other packages followed by Contacts Lite and the install went ok but nothing works (restarted server). I uninstalled Contacts Lite and reinstalled it but got the error below. I tried to uninstall the other pachages to start again but there were error in the uninstall procedure. I'll try this again. Is there any particular order I should install the packages?

Installing data model for Contacts Lite 0.2.1d...
Loading data model /home/david/web/openacs-4.6.2/packages/contacts-lite/sql/postgresql/contacts-lite-create.sql...
CREATE
CREATE
COMMENT
COMMENT
CREATE
DROP
COMMIT
COMMIT
HTTP/1.0 200 OK
Server: AOLserver/3.3.1+ad13
Content-Type: text/html; charset=iso-8859-1
MIME-Version: 1.0
Date: Tue, 13 May 2003 09:14:33 GMT
Content-Length: 4409
Connection: close

Request Error

    psql:contact-category-create.sql:17: ERROR:  Relation 'contact_categories' already exists
psql:contact-category-plsql-create.sql:18: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:contacts-lite-create.sql:26: ERROR:  Relation 'contacts' already exists
psql:contacts-lite-create.sql:28: ERROR:  index named "contacts_category_ix" already exists
psql:contacts-lite-create.sql:29: ERROR:  index named "contacts_party_ix" already exists
psql:contacts-plsql.sql:22: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:contacts-plsql.sql:60: ERROR:  parser: parse error at or near "t"
psql:contacts-plsql.sql:61: ERROR:  parser: parse error at or near "return"
psql:contacts-plsql.sql:70: ERROR:  parser: parse error at or near "'"
psql:contacts-plsql.sql:71: ERROR:  parser: parse error at or near "v_return"
psql:contacts-plsql.sql:75: ERROR:  parser: parse error at or near "delete"
psql:contacts-plsql.sql:78: ERROR:  Attribute 'p_contact_id' not found
psql:contacts-plsql.sql:80: ERROR:  parser: parse error at or near "raise"
psql:contacts-plsql.sql:82: ERROR:  parser: parse error at or near "perform"
psql:contacts-plsql.sql:84: ERROR:  parser: parse error at or near "return"
psql:contacts-plsql.sql:89: ERROR:  parser: parse error at or near "'"

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
    (procedure "apm_package_install_data_model" line 32)
    invoked from within
"apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path"
    (procedure "apm_package_install" line 103)
    invoked from within
"apm_package_install  -enable=$enable_p  -install_path $install_path  -callback apm_ns_write_callback  -load_data_model  -data_model_files $data_model_..."
    ("foreach" body line 45)
    invoked from within
"foreach pkg_info $pkg_install_list {
    set spec_file [pkg_info_spec $pkg_info]

Collapse
Posted by Jon Griffin on
I just did a fresh install and had no problems. You need to patch parties, did you do that?
Collapse
Posted by Jade Rubick on
David, it looks to me like the drop script wasn't run correctly.

What I would do is try to drop the package in the APM, then manually run each statement from the drop script to make sure it actually worked, and then reinstall the package. The duplicates mean it was already installed but not properly uninstalled.

Or at least that's my take on it.

Collapse
Posted by Gilbert Price on
Good Afternoon All,

Where would I find the parties patch?

Thanks,

Collapse
Posted by Jon Griffin on
The parties patch is only in my contacts package (it will be part of 5.0).
Addressbook is deprecated, I don't know why it got undeprecated. You really don't want to use it.
Collapse
Posted by David Cotter on
Jon, No I wasn't aware of the patch.

Jade, I will drop the tables manually and see if I can do a fresh install.

Thanks.