Hi,
Last week, we have upgraded from .LRN2.0.3 to .LRN2.1a2. (postgresql version)
First, we have made changes that Hector proposed. To solve bug 2094, we have deleted line 36 of the script:
-- alter table workflow_fsm_action_en_in_st add constraint workflow_fsm_action_en_in_st_pk primary key (action_id, state_id);
Any implication?
Other problems we have had are:
* We couldn't see "DAY SUMMARY" in initial screens of users o classes. In our log, we got:
[09/Sep/2004:13:15:03][27086.4101][-conn:elane::1] Error: Error in include templ ate "/var/lib/aolserver/elane/packages/calendar/www/view-one-day-display": No fu llquery for dbqd.calendar.www.views.select_all_day_items and default SQL empty - query for statement missing No fullquery for dbqd.calendar.www.views.select_all_day_items and default SQL empty - query for statement missing
while executing
...
To solve it, we have duplicated code of function "select_items" in packages/calendar/www/view-postgresql.xql and have named it "select_all_day_items"
* Neither we could see the section "CLASS INFO" in the initial screens of classes or communities. We always get next error:
Error in include template "/var/lib/aolserver/elane/packages/static-portlet/www/static-portlet": Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.") ERROR: column "body" does not exist SQL: select body as content, pretty_name from static_portal_content where content_id = '3322'
To solve it we had to execute manually the pgrade script static-portlet/sql/postgresql/upgrade/upgrade-2.0.3d1-2.0.3d2.sql
* We couldn't create any course or community. We got:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: syntax error at or near ":" at character 9
CONTEXT: PL/pgSQL function "fold_rename" line 5 at if
SQL:
select content_folder__edit_name(
'4811',
null,
'Documentos de Nueva asignatura',
null
);
while executing
"ns_pg_bind 0or1row nsdb0 {
select content_folder__edit_name(
:folder_id,
null,
:name,
..."
This problem came from a trigger definition in file fs-portlet/sql/postgresql/upgrade/upgrade-2.0.3-2.0.4.sql.
We made some changes and now it works. Our new definition is:
create or replace function fold_rename() returns trigger as '
declare
row_res record;
begin
if old.label <> new.label then
for row_res in select m.element_id
from portal_element_map m,
portal_element_parameters p
where p.key = ''folder_id''
and p.value = new.folder_id
and m.element_id = p.element_id
and m.name = ''fs_contents_portlet'' loop
update portal_element_map
set pretty_name = new.label
where element_id = row_res.element_id;
end loop;
end if;
return new;
end; ' language 'plpgsql';
