Forum OpenACS Q&A: Problems installing dowload package with OpenACS 5.1.4

o.title and o.package_id don't exist. So I removed them from the download-create.sql manually.

Now when I try to create a new repository I get the following exception:

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

ERROR: function content_item__new(character varying, integer, integer, "unknown", timestamp with time zone, integer, integer, character varying, "unknown", "unknown", character varying, character varying, "unknown", "unknown", character varying, "unknown", integer) does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
CONTEXT: PL/pgSQL function "download_rep__new" line 17 at select into variables

SQL:
select download_rep__new(
'908999',
'Test',
NULL,
NULL,
now(),
'27685',
'908825',
'908825',
'908825',
null
);

while executing
"ns_pg_bind 0or1row nsdb0 {
select download_rep__new(
:repository_id,
:title,
:description,
:help_text,
now(),
:user_id,
..."

Any idea why the installation failed?

Greetings,
Nima

I've downloaded the 5.20b1 tarball and installed it.
Then from acs-admin/install I chose "Install from Repository" and installed the download package.

The list of installed packages on acs-admin/install is telling me that it's Download 5.1d1

... and it doesn't work.  I've added two types of archive, "OACS code" and "Palm OS code" but when I try to add an archive, it chokes.  Here's how

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

Looking at the log for more details, I see

[04/Oct/2005:17:46:05][21937.114696][-conn:bitdojo::4] Error: Ns_PgExec: result status: 7 message: ERROR:  -20000: Cou\ld not find a root folder for item ID 608. Either the item does not exist or its parent value is corrupted.
CONTEXT:  PL/pgSQL function "content_item__new" line 50 at assignment
PL/pgSQL function "content_item__new" line 20 at assignment
PL/pgSQL function "__exec_5_archive_new" line 45 at assignment

[04/Oct/2005:17:46:05][21937.114696][-conn:bitdojo::4] Error: Ns_PgExec: result status: 7 message: ERROR:  current tran\saction is aborted, commands ignored until end of transaction block

As an aside, I also get the following:

[04/Oct/2005:17:46:05][21937.114696][-conn:bitdojo::4] Error: rp_report_error: Error rendering error page (!)
can't read "error_desc": no such variable

Any tips would be appreciated.  Anything having to do with the content repository just gives me headaches <g>.