Hi
I had a minor error in calendar package in my upgrade. Perhaps it is a problem with some upgrade script that didn't load (not in kernel package). I don't know.
Some data to check the problem:
- In package/calendar/www/cal-item-new
--- Error Log ---
[18/Nov/2013:15:59:06][2076.153182208][-default:0-] Error: Ns_PgExec: result status: 7 message: ERROR: missing FROM-clause entry for table "timespan_seq"
LINE 1: select timespan_seq.nextval from dual
^
QUERY: select timespan_seq.nextval from dual
CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement
PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN[18/Nov/2013:15:59:06][2076.153182208][-default:0-] Notice: -- creating per thread sequence table
[18/Nov/2013:15:59:06][2076.153182208][-default:0-] Error: POST http://localhost/despacho/agenda/cal-item-new?
referred by "https://localhost/despacho/agenda/cal-item-new?start%5ftime=7&date=2013%2d11%2d18";
Database operation "0or1row" failed
(exception ERROR, "ERROR: missing FROM-clause entry for table "timespan_seq"
LINE 1: select timespan_seq.nextval from dual
^
QUERY: select timespan_seq.nextval from dual
CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement
PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN
")
while executing
"ns_pg_bind 0or1row nsdb0 {
select timespan__new (
:start_date::timestamptz,
:end_date::timestamptz
)
}"
("uplevel" body line 1)
invoked from within
--- DB output ---
openacs=# \df+ time_interval__new
\df+ time_interval__new
List of functions
-[ RECORD 1 ]-------+-----------------------------------------------------------------
Schema | public
Name | time_interval__new
Result data type | integer
Argument data types | timestamp with time zone, timestamp with time zone
Type | normal
Security | invoker
Volatility | volatile
Owner | openacs
Language | plpgsql
Source code | -- time_intervals.interval_id%TYPE
| declare
| new__start_date alias for $1; -- default null,
| new__end_date alias for $2; -- default null
| v_interval_id time_intervals.interval_id%TYPE;
| begin
| select timespan_seq.nextval into v_interval_id from dual;
|
| insert into time_intervals
| (interval_id, start_date, end_date)
| values
| (v_interval_id, new__start_date, new__end_date);
|
| return v_interval_id;
|
| end;
Description |openacs=#
