Forum OpenACS Development: installation error on oacs head

Collapse
Posted by Iuri Sampaio on
I've a couple of error messages, on a fresh installation, august 22th.
I filled the installtion form and start to create de datamodel and etc.

at /log/error.log
*****************************
[23/Aug/2006:04:26:15][3654.1076596864][-main-] Error: Error sourcing /home/oacsbr/oacsbr/packages/acs-tcl/tcl/database-init.tcl:
expected integer but got ""
while executing
"ns_cache create db_cache_pool -size \
[parameter::get_from_package_key -package_key acs-kernel -parameter DBCacheSize]"
(file "/home/oacsbr/oacsbr/packages/acs-tcl/tcl/database-init.tcl" line 11)
invoked from within
"source $__file "

[23/Aug/2006:04:30:08][3724.1092766640][-conn:oacsbr::1] Error: package info file /home/oacsbr/oacsbr/packages/news/news.info contains more than one callback
proc of type before-uninstall

and on the browser:
******************************
Installed Subsite, version 5.3.0d1.Package enabled.Acs-subsite not installed.
Error:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: cannot EXECUTE a null querystring
CONTEXT: PL/pgSQL function "content_type__create_type" line 36 at execute statement

SQL:

select content_type__create_type('email_image','content_revision','Email_Image','Email_Images','users_email_image','email_image_id',NULL)

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

ERROR: cannot EXECUTE a null querystring
CONTEXT: PL/pgSQL function "content_type__create_type" line 36 at execute statement

SQL:

select content_type__create_type('email_image','content_revision','Email_Image','Email_Images','users_email_image','email_image_id',NULL)


while executing
"ns_pg_bind 0or1row nsdb0 {

select content_type__create_type(:content_type,:supertype,:pretty_name,:pretty_plural,:table_name,:id_column,:name_method..."
("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"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
# ns_log Debug "PLPGSQL: bypassed anon function"
set selection..."
("uplevel" body line 6)
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 exec_func_plsql {}"
(procedure "package_exec_plsql" line 31)
invoked from within
"package_exec_plsql -var_list [list [list content_type $content_type ] [list supertype $supertype ] [list pretty_name $pretty_name ] [list pretty_p..."
(procedure "content::type::new" line 3)
invoked from within
"content::type::new -content_type "email_image" -pretty_name "Email_Image" -pretty_plural "Email_Images" -table_name "users_email_image" -id_column "e..."
(procedure "subsite::package_install" line 2)
invoked from within
"subsite::package_install "
("eval" body line 1)
invoked from within
"eval $command"
(procedure "apm_invoke_callback_proc" line 37)
invoked from within
"apm_invoke_callback_proc -version_id $version_id -type after-install"
(procedure "apm_package_install" line 146)
invoked from within
"apm_package_install -load_data_model -enable -callback $callback $spec_file" Completing Install sequence by mounting the main site and other core packages.
CREATE FUNCTION
inline_0
----------
(1 row)
DROP FUNCTION

any idea?

Collapse
Posted by vivian Aguilar on
What version of postgres are you using?
Collapse
Posted by Iuri Sampaio on
Thanks vivian,
you reminded me in the past i had a problem with postgresql
and i needed to to reinstall a package, which was
postgresql-client (7.4.7-6sarge2)

and OACS-Postgresql debian installation gets pkgs
postgresql (7.4.7-6sarge1)

Do you think it could be that the reason? having diferent sarges of the same aplication?

anyway,
Although it's unuseful because i still have diferent sarges. i reinstalled OACS-Postgresql debian installation pkgs.
But i still get the error.

Collapse
Posted by Emmanuelle Raffenne on
We/Uned are setting up test servers (oracle9i and pg8) and have problems installing from HEAD with both DB (see http://www.openacs.org/bugtracker/openacs/bug?bug%5fnumber=2981).

Can someone have a look at this and fix it so we can go on with test servers installation?

Thanks in advance.

Collapse
Posted by Iuri Sampaio on
I am glad to know was me who initiated it. if possible, i'd like to participate on that!

Emmanuelle,
Thanks for the implicit enlighten.
I read bugtracker's docs ! I promess i will be diligent! :)

Collapse
Posted by Emmanuelle Raffenne on
Hi Iuri,

I think the errors you got are because of postgresql version, as Vivian suggested. OpenACS HEAD needs postgresql 8. You can install it on Sarge stable using backport packages (see http://www.backports.org).

Regarding the news package error, the duplicated callback has been fixed on HEAD. Thanks for reporting it.

Collapse
Posted by Emmanuelle Raffenne on
Bug #2981 that caused installation error for acs-messaging package has been fixed and committed on HEAD.