Forum OpenACS Development: regading the package of acs-person

hi
i am facing a problem with acs-person package when i am adding a new person i am getting the following error please any body could help me  out
the error is

Request Error

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind 0or1row nsdb0 {
        select acs_person__new (
    :acs_person_id,
    :given_name,
        :middle_name,
        :family_name,
    :formatted_na..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    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 [db_exec ..."
    ("uplevel" body line 6)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        # plsql calls that are simple selects bypass the plpgsql
        # mechanism for creating anonymous functions (OpenACS - ..."
    (procedure "db_exec_plsql" line 13)
    invoked from within
"db_exec_plsql new_person { }"
    ("uplevel" body line 3)
    invoked from within
"uplevel #5 {

  db_exec_plsql new_person { }
  ad_returnredirect "."
  ad_script_abort

}"
    ("uplevel" body line 1)
    invoked from within
"uplevel 1 $args"
    (procedure "ad_page_contract_eval" line 2)
    invoked from within
"ad_page_contract_eval uplevel #$level $new_data"
    (procedure "ad_form" line 594)
    invoked from within
"ad_form -name new_person -form {

acs_person_id:key

{given_name:text(text)
    {label "First Name"}
    {html {size 40}}
    {value {$given_name}}}
..."
    ("uplevel" body line 44)
    invoked from within
"uplevel {
          # packages/acs-person/www/add-edit.tcl

ad_page_contract {
  @author Jon Griffin mailto:jon@jongriffin.com
  @creation-date 2002-09-21
  @cv..."
    (procedure "code::tcl::/web/webwork/packages/acs-person/www/add-edit" 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..."

thanks
vamshi

Collapse
Posted by Jon Griffin on
acs-person is deprecated.
You should use the head and get the additions to persons from there. There is an upgrade script for PG.

This will be in 5.0

Collapse
Posted by Vamshi Krishna Kaniganti on
hi Jon

Is there any other solution to use it please suggest me in detail, so that i can proceed further it would be a great help to me.

thanks for your reply

cheers
vamshi