After submitting form cal-item-new, the system returns an error. It doesn't find cal_item_new
The URL is https://iurix.com/dotlrn/clubs/calendariodebella/calendar/cal-item-new
i.e. /dotlrn/clubs/calendariodebella/calendar/cal-item-new
However, submitting the form/calendar/cal-item-new executes with no errors.
What would be the solution to make /dotlrn aware of calendar plsql functions?
Or would it be the other way around? (i.e. to make calendar already of multiple instances)
Database operation "0or1row" failed (exception ERROR, "ERROR: function cal_item__new(unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, timestamp with time zone, unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist
LINE 2: select cal_item__new (
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
")
ERROR: function cal_item__new(unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, timestamp with time zone, unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist
LINE 2: select cal_item__new (
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
while executing
"ns_pg_bind 0or1row nsdb0 {
select cal_item__new (
null,
:calendar_id,
:name,
null,
null,
..."
("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 func..."
(procedure "::nsf::procs::db_exec_plsql" line 56)
invoked from within
"db_exec_plsql cal_item_add {}"
(procedure "::nsf::procs::calendar::item::new" line 38)
invoked from within
"calendar::item::new -start_date $start_date -end_date $end_date -name $title -description $description -location $location -related_link_url $re..."
("uplevel" body line 13)
invoked from within
"uplevel #$level $new_data"
(procedure "::nsf::procs::ad_form" line 690)
invoked from within
"ad_form -extend -name cal_item -validate {
{title {[string length $title] <= 4000}
"Title is too long"
}
{description {[string equ..."
