Forum .LRN Q&A: Re: notes on upgrading dotLRN to 2.2.0a1

<h1>Report of upgrade from 2.1.3 to 2.2</h1>

Hi all,
we just upgraded our test system from 2.1.3 to oacs5-2 with .LRN 2.2.0a2.
<h2>Upgrade Problems</h2>

Here the problemes we faced during upgrade:

For some reason upgrade of file-storage, content-repository and dotlrn were always hanging. Also the after upgrade callback of news resulted to an error saying that we have a duplicate value for the service contract in our database.
fter several runs file-storage went through. What was hanging was the update calls at the end of file-storage/sql/postgresql/upgrade/upgrade-5.1.0a16-5.1.0a17.sql
dotlrn upgrade stopped after running the sql/postgresql/upgrade/upgrade-2.1.3-2.2.0d1.sql script. So I assume dotlrn::apm::after_upgrade has not been called. But I need to check that. APM at least is displaying version 2.2.0a2.
Regarding content repository it turned out that the temporary function __tmp_crnewtree() in upgrade-5.2.0b2-5.2.0b3.sql was the reason why upgrade hanging. We found out accidently after 20 minutes that the upgrade continued.

<h2>Testing the site</h2>

Here a first report testing after the upgrade:
<h4>Static Portlet</h4>

For some reason all static portlets have an error because a column body is expended but we have a column content inside our database. No idea where that is coming from.
```
select body, pretty_name, format from static_portal_content where content_id = xyz
```
Creating a new static portlet therefore fails

<h4>Classes, Communities, Subgroups</h4>

Navigation to classes, courses, subgroups and communities work

Creating subgroups fails:

Database operation "dml" failed (exception ERROR, "FEHLER: Einfügen oder Aktualisieren in Tabelle »acs_objects« verletzt Fremdschlüssel-Constraint »acs_objects_package_id_fk« DETAIL: Schlüssel (package_id)=(0) ist nicht in Tabelle »apm_packages« vorhanden. ")

FEHLER: Einfügen oder Aktualisieren in Tabelle »acs_objects« verletzt Fremdschlüssel-Constraint »acs_objects_package_id_fk« DETAIL: Schlüssel (package_id)=(0) ist nicht in Tabelle »apm_packages« vorhanden.

SQL: update acs_objects set package_id = '0' where object_id = '2238349'

Copying a group fails

SQL: update acs_objects set package_id = '0' where object_id = '2238641' while executing "ns_pg_bind dml nsdb0 { update acs_objects set package_id = :object_id where object_id = :node_id }"

Archiving a group works
unarchiving a group works
Managing members
- adding a new member works
- changing role works (slow)
- removing member works
Changing portlet name works but
- For some reason so portlet headers dont shown anymore
- Simply displaying a page number instead of page name not good

Changing system template fails:

expected boolean value but got "" while executing "if {[parameter::get -package_id $dotlrn_package_id -parameter AdminChangeSiteTemplate_p]} { set site_template_id [get_site_template_id -community..." (procedure "dotlrn_community::get_site_template_id_not_cached" line 5) invoked from within "dotlrn_community::get_site_template_id_not_cached -community_id 2093034" ("eval" body line 1) invoked from within "eval $script"

Creating welcome message for group works. Wether it is send out, no idea

<h4>Forums</h4>

Creating a new forum works
Creating a new thread works works
Replying a post works
Move of thread to another thread/forum works
disabling forums works
Move to other thread not i18n-ized
Subscribe others not i18n-ized
Confirmation of moving to another thread not i18n-ized
statistics not i18n-ized

Note: We should provide a feature to delete a forum, no?

<h4>FAQ</h4>

Creating/deleting an FAQ works
create/delete/preview q&a works
separte page for each q&a works
Create form of faq not i18n
Configure link and configure form not i18n

<h4>Calendar</h4>

Creating a new item - Javascript to display date selector fails
Creating an new item works
Display of items works on all portlets and views
Deleting an item works
Editing an item works
Changing an recurring item is not provided

Creating a recurring item fails

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

FEHLER: ungültige Eingabesyntax für Typ timestamp with time zone: »12-Mai-2006 0:0«

SQL: select recurrence__new('week', '2', '1 2 4', '12-Mai-2006 0:0', NULL)

<h4>Bulk Mail</h4>

Simply sending a mail worked

<h4>News</h4>

Creating a new item works
"Choose an image" not i18n
"Return to edit" not i18n
Upload of an image fails ..."Image must be one of the following types:", error text not complete, text not i18n-ized
return to edit works
preview works
confirmation works
link to administer news on the right not using class button of style sheet
item displays on porlet

<h4>Survey</h4>

Creating/deleting a new survey works
Creating a new question works
Preview works
Different display types table, list, sections work
admin image on the right broken on page survey/one-survey
processing a survey works
display of given answers works
changing a given answer works
Link on survey portlet "view/edit previous responses" not i18n
activation/deactivation of survey works
copy of questions work
deleting a question works
moving questions work

<h4>File-Storage</h4>

File upload works
new revision works
delete revision works
rename works
copy of files works
deleting a file works
moving a file works (slow)
creating a new folder works (slow)
moving folder works (slow)
Parent folder display emtpy if child folder is empty as well (not good)
deleting a folder works (slow)