#48 Issue to add new dynfield

[Tahmina Khatoon]

Hi,

I was trying add new dynfield in company object. But it displays the following error.
I filled up all the input fields.

Can anyone help me, how to fix this error?

Thank you.

=====================================================

There was a server error processing your request. We apologize.

Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

Database operation "dml" failed
(exception ERROR, "ERROR:  type "im_name_from_id" does not exist
LINE 1: alter table persons add column sure_name im_name_from_id;
                                                 ^
")

    while executing
"ns_pg_bind dml nsdb0 {alter table persons add column sure_name im_name_from_id}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    invoked from within
"db_exec dml $db $full_statement_name $sql"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
            db_exec dml $db $full_statement_name $sql
        }"
    (procedure "db_dml" line 100)
    invoked from within
"db_dml add_column "alter table $table_name add column $attribute_name $sql_datatype""
    (procedure "im_dynfield::attribute::add" line 111)
    invoked from within
"im_dynfield::attribute::add  -object_type $object_type  -widget_name $widget_name  -attribute_name $attribute_name  -pretty_name $pretty_name  -pretty..."
    ("uplevel" body line 9)
    invoked from within
"uplevel #$level $new_data"
    (procedure "ad_form" line 644)
    invoked from within
"ad_form  -name attribute_form  -form $form_fields  -mode $form_mode  -method POST  -new_request {
} -edit_request {
} -validate {
    # Validation tha..."
    ("uplevel" body line 354)
    invoked from within
"uplevel {
ad_page_contract {

    @author Matthew Geddert openacs@geddert.com
    @creation-date 2004-07-28
    @cvs-id $Id: attribute-new.tcl,v 1.23 ..."
    (procedure "code::tcl::d:/project-open/servers/projop/packages/intranet-..." line 2)
    invoked from within
"code::tcl::$__adp_stub"
    ("uplevel" body line 12)
    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"
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 6)
    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/$extra_url""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
            rp_serve_abstract_file "$root/$extra_url"
            set tcl_url2file([ad_conn url]) [ad_conn file]
            set tcl_url2path..."

[Frank Bergmann]

Please replace "im_name_from_id" by "integer" or whatever is the data-type for your new DynField.
We offer training for DynFields and other advanced configurations...