Forum .LRN Q&A: Re: .LRN 2.1 a2 tagged

Collapse
25: Re: .LRN 2.1 a2 tagged (response to 1)
Posted by Gerard Low on
on postgresql 7.3.4, the .LRN admin function "Archived Classes and Communities" appears to be broken.

http://localhost:8000/dotlrn/admin/archived-communities

the error.log file is also showing this as well

Warning: Query dbqd.dotlrn.www.admin.archived-communities.select_archived_comms has rdbms info postgres 7.2 which is not compatible with system rdbms postgresql 7.3

Collapse
26: Re: .LRN 2.1 a2 tagged (response to 25)
Posted by David Ortega on
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';