Forum OpenACS Q&A: cms request error

Collapse
Posted by Philipp Strazny on
I'm just getting started w/ ACS in general and the CMS module specifically and it may be possible that I am missing something very basic.

When I am trying to add an item to the content repository (image, basic item, journal article), I only get the following error:


Request Error

Database operation "0or1row" failed (exception NSINT, "Query returned 
more than one row.")

    while executing

"ns_pg_bind 0or1row nsdb0 {

      

      select

        label, map.content_method

      from

        cm_content_type_method_map map, cm_content_methods..."

    ("uplevel" body line 1)

    invoked from within

"uplevel $ulevel [list ns_pg_bind $type $db $sql"

    invoked from within

"db_exec 0or1row $db $statement_name $sql 3"

    (procedure "template::query::onerow" line 5)

    invoked from within

"template::query::$type $full_statement_name $db $result_name $sql"

    invoked from within

"set ret_code [template::query::$type $full_statement_name $db 
$result_name $sql] "

    ("uplevel" body line 2)

    invoked from within

"uplevel 1 $code_block "

    invoked from within

"db_with_handle db { 

      set ret_code [template::query::$type $full_statement_name $db 
$result_name $sql] 

  }"

    (procedure "template::query" line 28)

    invoked from within

"template::query get_content_default_method default_method onerow "

      select

        label, map.content_method

      from

        cm_content_type_m..."

    (procedure "content_method::get_content_method_options" line 5)

    invoked from within

"content_method::get_content_method_options $content_type"

    (procedure "content_method::get_content_methods" line 5)

    invoked from within

"content_method::get_content_methods $content_type -get_labels"

    invoked from within

"set content_methods  [content_method::get_content_methods 
$content_type -get_labels]"

    ("uplevel" body line 48)

    invoked from within

"uplevel {

            # create-1.tcl

# choose from (no content, file upload, text entry, xml import)

#    then forward to create-2 or revision-upload

 

requ..."

    
(procedure "code::tcl::/web/openacs/packages/cms/www/modules/items/cre
at..." 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 3)

    invoked from within

"adp_prepare "

    (procedure "template::adp_parse" line 31)

    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..."

 
Is there something I missed during setup, or am I just trying to do something that I can't do?

With an out-of-the-box setup, should I be able to add e.g. a "basic item" or do I have to write the user interface?

Also, as the site-wide administrator, I can access the cms via "Main Site: Administration: Site Map", but how do I make a cms-controlled directory accessible on user's workspaces?

I suspect that there are relevant texts in the wealth of documentation, and I found both high-level descriptions and nitty- gritty programming docs. Can anybody point me to medium-level entry points?

Thanks,

Philipp

Collapse
Posted by Philipp Strazny on
I apologize. This went to the wrong forum. But if anybody could help, I'd still appreciate it.
Philipp
Collapse
Posted by Dan Wickstrom on
I'm leaving for the airport now, and I'll be out of touch until Saturday, but I'll look at it when I get back.
Collapse
Posted by Dan Wickstrom on
Could you post more details on how you arrived at this error?  I'm unable reproduce it.
Collapse
Posted by Philipp Strazny on
Since I was still in the beginning stages, I did a complete reinstall, and now I can't reproduce the error either 😉. Thanks anyway.