Forum OpenACS Q&A: Error installing Core Services
OpenACS Installation: Installing OpenACS Core Services
Failed to install ACS Core Documents, version 4.5. The following error was generated:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
Package enabled.
Failed to install Skin, version 4.5. The following error was generated:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
Package enabled.
Completing Install sequence.
CREATE FUNCTION
CREATE FUNCTION
CREATE TABLE
id
----
(0 rows)
UPDATE 0
DROP FUNCTION
DROP FUNCTION
DROP TABLE
And that's all it does and it stalls or soemthing and nothing else happens. I had installed OpenACS before with this same platform (SuSE 8.0) and all went pretty well. Any ideas?
check the aolserver error log for meaningfull error messages. The messages displayed in the browser don't contain all the information.
/Bart
these are the errors I found. If you want to see the whole thing I just posted it in another note.
first one:
...[30/Jan/2003:07:18:28][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/tcl-documentation-procs.tcl...
[30/Jan/2003:07:18:28][1129.1024][-main-] Warning: apm_boostrap_load_file skipping /home/lgarcia3/web/exchange/packages/acs-tcl/tcl/tcl-documentation-tests.tcl because it isn't either a -procs.tcl or -init.tcl file
[30/Jan/2003:07:18:28][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/text-html-procs.tcl...
second:
...[30/Jan/2003:07:18:29][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/xml-2-procs.tcl...
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Multiple definition of util_memoize in /home/lgarcia3/web/exchange/packages/acs-tcl/tcl/memoize-procs.tcl and /home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/bootstrap.tcl
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Installation is not complete - sourcing the installer.
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Sourcing files for postload...
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Done.
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Executing initialization code blocks...
third:
...[30/Jan/2003:07:18:31][1129.8201][-nssock-] Notice: nssock: starting
[30/Jan/2003:07:18:31][1129.8201][-nssock-] Notice: nssock: accepting connections
[30/Jan/2003:07:19:10][1129.5126][-conn2-] Error: tclop: invalid return code from filter proc '': must be filter_ok, filter_return, or filter_break
[30/Jan/2003:07:19:16][1129.6151][-conn3-] Notice: Scanning for new unregistered packages...
[30/Jan/2003:07:19:16][1129.6151][-conn3-] Notice: /home/lgarcia3/web/exchange/packages/acs-admin/acs-admin.info...
fourth:
...[30/Jan/2003:07:19:17][1129.6151][-conn3-] Notice: /home/lgarcia3/web/exchange/packages/wp-slim/wp-slim.info
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM/QD = loading up package query files for acs-core-docs
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM: Query files for acs-core-docs:
WARNING: Error occurred while executing PL/pgSQL function apm_package_version__new
WARNING: line 16 at if
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Error: Ns_PgExec: result status: 7 message: ERROR: pg_atoi: zero-length string
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM/QD = loading up package query files for skin
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM: Query files for skin:
WARNING: Error occurred while executing PL/pgSQL function apm_package_version__new
WARNING: line 16 at if
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Error: Ns_PgExec: result status: 7 message: ERROR: pg_atoi: zero-length string
[30/Jan/2003:07:19:38][1129.6151][-conn3-] Error: Error sourcing /home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/installer/packages-install.tcl:
psql:acs-install.sql:247: WARNING: Error occurred while executing PL/pgSQL function inline_0
psql:acs-install.sql:247: WARNING: line 15 at assignment
psql:acs-install.sql:247: ERROR: Function apm_service__new("unknown", "unknown", "unknown", "unknown", timestamptz, "unknown", "unknown", integer) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
psql:acs-install.sql:254: WARNING: Error occurred while executing PL/pgSQL function acs_permission__grant_permission
psql:acs-install.sql:254: WARNING: line 17 at SQL statement
psql:acs-install.sql:254: ERROR: ExecInsert: Fail to add null value in not null attribute object_id
invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-install.sql"
invoked from within
"if { ![ad_acs_admin_node] } {
ns_write " <p><li> Completing Install sequence.<p>
<blockquote><pre>"
cd [file join [acs_root_dir] packages..."
(file "/home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/installer/packages-install.tcl" line 34)
invoked from within
"source $__file "
[30/Jan/2003:07:19:38][1129.7176][-conn4-] Error: tclop: invalid return code from filter proc '': must be filter_ok, filter_return, or filter_break
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: dbdrv: opening database 'postgres:localhost::exchange'
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: Opening exchange on localhost
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::exchange.