Forum OpenACS Q&A: Re: Upgrade Problem from 5.4 to 5.5

Collapse
Posted by Nima Mazloumi on
During upgrade I got these two errors.

First:

[11/Nov/2009:20:31:54][6577.1125480784][-default:14-] Notice: <h3>Installing Kernel 5.5.1</h3>
[11/Nov/2009:20:31:55][6577.1125480784][-default:14-] Notice: reading /www/dotlrn-2.5.0/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml in ISO-8859-1
[11/Nov/2009:20:31:55][6577.1125480784][-default:14-] Notice: Loading messages in file /www/dotlrn-2.5.0/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml
[11/Nov/2009:20:31:55][6577.1125480784][-default:14-] Notice: reading /www/dotlrn-2.5.0/packages/acs-kernel/catalog/acs-kernel.de_DE.ISO-8859-1.xml in ISO-8859-1
[11/Nov/2009:20:31:55][6577.1125480784][-default:14-] Notice: Loading messages in file /www/dotlrn-2.5.0/packages/acs-kernel/catalog/acs-kernel.de_DE.ISO-8859-1.xml
[11/Nov/2009:20:31:56][6577.1125480784][-default:14-] Error: Ns_PgExec: result status: 7 message: FEHLER: NULL-Wert in Spalte »tree_sortkey« verletzt Not-Null-Constraint
CONTEXT: SQL-Anweisung »insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )«
PL/pgSQL function "acs_object__new" line 39 at SQL statement
PL/pgSQL function "apm_package_version__new" line 25 at assignment

[11/Nov/2009:20:31:56][6577.1125480784][-default:14-] Error: apm_package_install: Error installing Kernel version 5.5.1: Database operation "0or1row" failed
(exception ERROR, "FEHLER: NULL-Wert in Spalte »tree_sortkey« verletzt Not-Null-Constraint
CONTEXT: SQL-Anweisung »insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )«
PL/pgSQL function "acs_object__new" line 39 at SQL statement
PL/pgSQL function "apm_package_version__new" line 25 at assignment
")

Database operation "0or1row" failed
(exception ERROR, "FEHLER: NULL-Wert in Spalte »tree_sortkey« verletzt Not-Null-Constraint
CONTEXT: SQL-Anweisung »insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )«
PL/pgSQL function "acs_object__new" line 39 at SQL statement
PL/pgSQL function "apm_package_version__new" line 25 at assignment
")

while executing
"ns_pg_bind 0or1row nsdb0 {
select apm_package_version__new(
:version_id,
:package_key,
:version_name,
:version_uri,
:summary,
:des..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"

And then:

[11/Nov/2009:20:34:17][6577.1123424592][-default:13-] Notice:

Installed Subsite, version 5.5.1.

[11/Nov/2009:20:34:17][6577.1123424592][-default:13-] Notice:

Package enabled.
[11/Nov/2009:20:34:17][6577.1123424592][-default:13-] Notice: apm_invoke_callback_proc: invoking callback after-upgrade with command subsite::after_upgrade -from_version_name 5.4.2 -to_version_name 5.5.1
[11/Nov/2009:20:34:17][6577.1123424592][-default:13-] Error: POST http://33333/acs-admin/apm/packages-install-4?
referred by "http://33333/acs-admin/apm/packages-install-3";
no such array: apm_subsite_packages_list
while executing
"nsv_get apm_subsite_packages_list package_keys"
(procedure "subsite::package_keys" line 2)
invoked from within
"subsite::package_keys"