I am trying to upgrade acs-templating from version 5.1.5 to version 5.5.1 and i got an SQL error saying there's no such parameter called XinhaDefaultPlugins
I believe it is missing one script that creates the parameter XinhaDefaultPlugins and its related stuff.
Moreover, I can not run scripts to upgrade, unless I do the amends before.
What would be the best thing to do?
1. Manually create the parameter then run the upgrade script
(but I don't know id there's something more to create)
or
2. Uninstall package acs-templating 5.1.5 then install acs-templating 5.5.1 (Is delete acs-tempating package's script a cleaned uninstalling process?)
Please see log below:
[21/Apr/2010:20:08:44][19820.3058224016][-default:2-] Error: apm_package_install: Error installing Templating version 5.5.1: Database operation "0or1row" failed
(exception ERROR, "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
")
pqerror was: "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select apm__set_value(
'170',
'XinhaDefaultPlugins',
NULL
);Database operation "0or1row" failed
(exception ERROR, "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
")
pqerror was: "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select apm__set_value(
'170',
'XinhaDefaultPlugins',
NULL
);
while executing
"ns_pg_bind 0or1row nsdb0 {
select apm__set_value(
:package_id,
:parameter,
:value
..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
("uplevel" body line 8)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql set_parameter_value {}"
(procedure "parameter::set_value" line 7)
invoked from within
"parameter::set_value -package_id $package_id_templating -parameter "XinhaDefaultPlugins" -value $plugins "
("uplevel" body line 7)
invoked from within
"uplevel $chunks($key)"
(procedure "apm_upgrade_logic" line 19)
invoked from within
"apm_upgrade_logic -from_version_name $from_version_name -to_version_name $to_version_name -spec {
4.6.4 5.0d1 {
db_tran..."
(procedure "template::apm::before_upgrade" line 3)
invoked from within
"template::apm::before_upgrade -from_version_name 5.1.5 -to_version_name 5.5.1"
("eval" body line 1)
invoked from within
"eval $command"
(procedure "apm_invoke_callback_proc" line 37)
invoked from within
"apm_invoke_callback_proc -proc_name $callbacks(before-upgrade) -version_id $version_id -type before-upgrade -arg_list [list from_version_name $upg..."
("uplevel" body line 46)
invoked from within
"uplevel $body "
[21/Apr/2010:20:08:44][19820.3058224016][-default:2-] Error:
Failed to install Templating, version 5.5.1. The following error was generated:
Database operation "0or1row" failed
(exception ERROR, "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
")
pqerror was: "ERROR: -20000: The specified package 170 AND/OR parameter XinhaDefaultPlugins do not exist in the system
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select apm__set_value(
'170',
'XinhaDefaultPlugins',
NULL
);
NOTE: If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.
[21/Apr/2010:20:08:44][19820.3058224016][-default:2-] Notice: Querying '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '18261' and ppm.party_id = '624' and ppm.privilege = 'admin' );'
[21/Apr/2010:20:08:44][19820.3058224016][-default:2-] Notice: dbinit: sql(localhost::projop): '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '18261' and ppm.party_id = '624' and ppm.privilege = 'admin' )
'
[21/Apr/2010:20:08:44][19820.3058224016][-default:2-] Debug: db_exec: timing 0 seconds nsdb0 0or1row dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p