Forum .LRN Q&A: .LRN installation

Hello guys,
I just installed OpenACS 5.2.0b9, AOLserver 4.0.10, and PostgreSQL 8.1 on my machine. I did a fresh checkout from the CVS, and tried to install dotLRN on my machine.
The problem is that when i navigate to localhost:8000, it shows me the installation page, starts running and then bombs (see attached error message).
The installation start with "Installing OpenACS kernel data model", and bombs before reaching any other module.
I know it should work, because i tried installing dotLRN on a machine with PostgreSQL 8.0.4, and it worked just fine.
Can anybody tell me what is wrong?

Error Message:
[15/Dec/2005:11:01:08][24112.3066452912][-conn:faisal::3] Error: Error sourcing /web/faisal/packages/acs-bootstrap-installer/installer/install.tcl:
psql:lob.sql:34: WARNING: changing return type of function on_lobs_delete from "opaque" to "trigger"
psql:acs-metadata-create.sql:88: WARNING: changing return type of function acs_object_type_insert_tr from "opaque" to "trigger"
psql:acs-metadata-create.sql:137: WARNING: changing return type of function acs_object_type_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:188: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "inline_0" line 20 at assignment
psql:acs-objects-create.sql:254: WARNING: changing return type of function acs_objects_mod_ip_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:269: WARNING: changing return type of function acs_objects_last_mod_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:307: WARNING: changing return type of function acs_objects_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:355: WARNING: changing return type of function acs_objects_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:456: WARNING: changing return type of function acs_objects_context_id_in_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:528: WARNING: changing return type of function acs_objects_context_id_up_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:540: WARNING: changing return type of function acs_objects_context_id_del_tr from "opaque" to "trigger"
psql:acs-relationships-create.sql:308: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_rel_type__create_type" line 23 at perform
psql:acs-relationships-create.sql:420: WARNING: changing return type of function acs_rels_in_tr from "opaque" to "trigger"
psql:utilities-create.sql:29: ERROR: syntax error at or near "'.nextval as a_seq_val'" at character 40
QUERY: SELECT 'select ' || quote_ident( $1 ) '.nextval as a_seq_val'
CONTEXT: SQL statement in PL/PgSQL function "util__multiple_nextval" near line 8
psql:utilities-create.sql:29: LINE 1: SELECT 'select ' || quote_ident( $1 ) '.nextval as a_seq_va...
psql:utilities-create.sql:29: ^
psql:authentication-create.sql:92: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:community-core-create.sql:237: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'party', 'MESSAGE KEY MISSING: 'acs-kernel.Party'', 'MESSAGE KEY MISSING: 'acs-kernel.Parties'', 'acs_object', 'parties', 'party_id', 'party', 'f', null, 'party.name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:community-core-create.sql:547: ERROR: insert or update on table "acs_object_type_tables" violates foreign key constraint "acs_obj_type_tbls_obj_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_type_tables (object_type, table_name, id_column) values ('user', 'user_preferences', 'user_id')"
PL/pgSQL function "inline_1" line 3 at SQL statement
psql:groups-create.sql:158: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_0" line 7 at assignment
psql:groups-create.sql:424: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:439: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:452: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
psql:groups-create.sql:457: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
psql:rel-segments-create.sql:42: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_segment', 'MESSAGE KEY MISSING: 'acs-kernel.lt_Relational_Party_Segm'', 'MESSAGE KEY MISSING: 'acs-kernel.lt_Relational_Party_Segm_1'', 'party', 'rel_segments', 'segment_id', 'rel_segment', 'f', 'rel_segment', 'rel_segment.name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:rel-segments-create.sql:292: WARNING: changing return type of function parties_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:306: WARNING: changing return type of function parties_del_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:329: WARNING: changing return type of function rel_segments_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:346: WARNING: changing return type of function rel_segments_del_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:39: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_constraint', 'MESSAGE KEY MISSING: 'acs-kernel.lt_Relational_Constraint'', 'MESSAGE KEY MISSING: 'acs-kernel.lt_Relational_Constraint_1'', 'acs_object', 'rel_constraints', 'constraint_id', 'rel_constraint', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:rel-constraints-create.sql:540: WARNING: changing return type of function rel_constraints_ins_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:590: WARNING: changing return type of function rel_constraints_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:184: WARNING: changing return type of function acs_priv_hier_ins_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:198: WARNING: changing return type of function acs_priv_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:421: WARNING: changing return type of function acs_permissions_lock_tr from "opaque" to "trigger"
psql:groups-body-create.sql:86: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:113: WARNING: changing return type of function membership_rels_up_tr from "opaque" to "trigger"
psql:groups-body-create.sql:141: WARNING: changing return type of function membership_rels_del_tr from "opaque" to "trigger"
psql:groups-body-create.sql:250: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:350: WARNING: changing return type of function composition_rels_del_tr from "opaque" to "trigger"
psql:journal-create.sql:35: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'journal_entry', 'Journal Entry', 'Journal Entries', 'acs_object', 'journal_entries', 'journal_id', 'journal_entry', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:site-nodes-create.sql:30: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'site_node', 'Site Node', 'Site Nodes', 'acs_object', 'site_nodes', 'node_id', 'site_node', 'f', null, null )"
PL/pgSQL function "inline_0" line 4 at perform
psql:site-nodes-create.sql:99: WARNING: changing return type of function site_node_insert_tr from "opaque" to "trigger"
psql:site-nodes-create.sql:159: WARNING: changing return type of function site_node_update_tr from "opaque" to "trigger"
psql:apm-create.sql:97: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'apm_package', 'Package', 'Packages', 'acs_object', 'APM_PACKAGES', 'package_id', 'apm_package', 'f', 'apm_package_types', 'apm_package.name' )"
PL/pgSQL function "inline_0" line 3 at perform
psql:apm-create.sql:209: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "inline_1" line 5 at assignment
psql:apm-create.sql:668: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_2" line 4 at assignment
psql:apm-create.sql:964: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_4" line 4 at assignment
psql:apm-create.sql:1041: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_5" line 4 at assignment
psql:apm-create.sql:1118: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_6" line 5 at assignment
psql:apm-create.sql:1148: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_7" line 5 at assignment
psql:apm-create.sql:2376: ERROR: syntax error at or near "initial_install_p" at character 350
QUERY: UPDATE apm_package_types SET pretty_name = coalesce( $1 , pretty_name), pretty_plural = coalesce( $2 , pretty_plural), package_uri = coalesce( $3 , package_uri), package_type = coalesce( $4 , package_type), spec_file_path = coalesce( $5 , spec_file_path), spec_file_mtime = coalesce( $6 , spec_file_mtime), singleton_p = coalesce( $7 , singleton_p) initial_install_p = coalesce( $8 , initial_install_p) where package_key = $9
CONTEXT: SQL statement in PL/PgSQL function "apm_package_type__update_type" near line 21
psql:apm-create.sql:2376: LINE 1: ...mtime), singleton_p = coalesce( $7 , singleton_p) initial_in...
psql:apm-create.sql:2376: ^
psql:acs-create.sql:213: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "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 40 at SQL statement
PL/pgSQL function "inline_0" line 5 at assignment
psql:acs-create.sql:315: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_objects (object_id, object_type, title) values (0, 'user', 'MESSAGE KEY MISSING: 'acs-kernel.Unregistered_Visitor'')"
PL/pgSQL function "inline_2" line 8 at SQL statement
psql:acs-create.sql:360: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(group) is not present in table "acs_object_types".
CONTEXT: SQL statement "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 40 at SQL statement
PL/pgSQL function "party__new" line 12 at assignment
PL/pgSQL function "acs_group__new" line 16 at assignment
PL/pgSQL function "inline_3" line 8 at assignment
psql:acs-create.sql:372: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "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 40 at SQL statement
PL/pgSQL function "acs_object__new" line 10 at return
psql:acs-create.sql:377: ERROR: insert or update on table "acs_magic_objects" violates foreign key constraint "acs_magic_objects_object_id_fk"
DETAIL: Key (object_id)=(-3) is not present in table "acs_objects".
psql:acs-create.sql:404: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
CONTEXT: SQL statement "SELECT acs_object_id_seq.nextval from dual"
PL/pgSQL function "acs_object__new" line 17 at select into variables
PL/pgSQL function "authority__new" line 38 at assignment

invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-kernel-create.sql"
(procedure "install_do_data_model_install" line 7)
invoked from within
"install_do_data_model_install"
invoked from within
"if { ![install_good_data_model_p] } {
install_do_data_model_install
} else {
ns_write "Kernel data model already installed."
# If kernel i..."
(file "/web/faisal/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[15/Dec/2005:11:01:08][24112.3065400240][-conn:faisal::4] Warning: tclfilter: install_handler return invalid result: