Forum OpenACS Development: Add link URL on file-storage pkg

Collapse
Posted by Iuri Sampaio on
Hi there,

simple-add form breaks and returns the following error message

This items content type content_extlink is not registered to this folder 25914

Even though 25914 is present on cr_items and its content_type is content_folder

My guess it's missing some data in the datamodel to allow such operation (add link, i.e. simple add ad_form)

Best wishes,
Iuri


item_id | parent_id | name | locale | live_revision | latest_revision | publish_status | content_type | storage_type | storage_area_key | tree_sortkey | max_child_sortkey
---------+-----------+-----------------------+--------+---------------+-----------------+----------------+----------------+--------------+------------------+--------------------------------------------------------------------------+-------------------
25914 | -100 | 23456787654345-folder | | | | | content_folder | text | CR_FILES | 100000000000000000000011111001001000000000000000000000111000010000001100 |
(1 row)

(END)

[17/Jan/2018:04:27:22][14011.7f3be2256700][-conn:evex:13-] Error: nsdbpg: result status: 7 message: ERROR: -20000: This items content type content_extlink is not registered to this folder 25914
CONTEXT: PL/pgSQL function content_extlink__new(character varying,character varying,character varying,character varying,integer,integer,timestamp with time zone,integer,character varying,integer) line 28 at assignment

[17/Jan/2018:04:27:22][14011.7f3be2256700][-conn:evex:13-] Notice: checking entry 127.0.0.1 from host_node_map ->
[17/Jan/2018:04:27:22][14011.7f3be2256700][-conn:evex:13-] Warning: ignore untrusted host header field: '127.0.0.1:8443'
[17/Jan/2018:04:27:22][14011.7f3be2256700][-conn:evex:13-] Notice: ignore non-existing or untrusted host header, fall back to evex.co
[17/Jan/2018:04:27:22][14011.7f3be2256700][-conn:evex:13-] Error: Database operation "0or1row" failed (exception ERROR, "ERROR: -20000: This items content type content_extlink is not registered to this folder 25914
CONTEXT: PL/pgSQL function content_extlink__new(character varying,character varying,character varying,character varying,integer,integer,timestamp with time zone,integer,character varying,integer) line 28 at assignment
")

ERROR: -20000: This items content type content_extlink is not registered to this folder 25914
CONTEXT: PL/pgSQL function content_extlink__new(character varying,character varying,character varying,character varying,integer,integer,timestamp with time zone,integer,character varying,integer) line 28 at assignment

SQL:

select content_extlink__new(NULL,'https://www.youtube.com/embed/DDIxdmUravQ','Video1',NULL,'25914',NULL,'now',NULL,NULL,NULL)


while executing
"ns_pg_bind 0or1row nsdb0 {

select content_extlink__new(:name,:url,:label,:description,:parent_id,:extlink_id,'now',NULL,NULL,:package_id)

}"
("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"
("uplevel" body line 8)
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 "::nsf::procs::db_exec_plsql" line 56)
invoked from within
"db_exec_plsql exec_func_plsql {}"
(procedure "::nsf::procs::package_exec_plsql" line 34)
invoked from within
"package_exec_plsql -var_list [list [list extlink_id $extlink_id ] [list url $url ] [list parent_id $parent_id ] [list name $name ] [list label $l..."
(procedure "::nsf::procs::content::extlink::new" line 2)
invoked from within
"content::extlink::new -url $url -label $title -description $description -parent_id $folder_id"
("uplevel" body line 4)
invoked from within
"uplevel #$level $on_submit"
(procedure "ad_form" line 706)
invoked from within
"ad_form -extend -form {
{submit:text(submit) {label $submit_label}}
} -on_request {
} -on_submit {

set description ""
set item_id [conten..."
("uplevel" body line 76)
invoked from within
"uplevel {
ad_page_contract {
page to add a new nonversioned object to the system

@author Ben Adida (mailto:ben@openforce.net)
@author ar..."
(procedure "code::tcl::/var/w